Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

sales order and billing document fields

Former Member
0 Kudos

what are the fields for sales order and billing document dates?

5 REPLIES 5

Former Member
0 Kudos

Hi,

Check the table VBAK, VBAP, VBRK & VBRP..

What dates are you looking for in the billing document??

Thanks,

Naren

Former Member
0 Kudos

Hi

Couldnt really get the exact requirement:

1. If Billing Dates are to be extracted from Sales Documents, we can do that by extracting field <b>FKDAT</b> from table <b>VBKD</b>.

2. If it is Billing Document creation date, extract from VBRK-ERDAT with below condition.

  select vbrp~vbeln vbrp posnr vbrp~aubel 
         vbrp~aupos vbrk~erdat into table itab
         from vbrp as a
         inner join vbrk as b
         on vbrp~vbeln = vbrk~vbeln
         where vbrp~aubel in s_vbeln.  "Sales Documents

Hope this gives you some idea.

Kind Regards

Eswar

Former Member
0 Kudos

Hi Priyankareddy,

Billing Doc Dates : vbrk-fkdat, vbrk-erdat, vbrk-valdt,vbrk-aedat, etc..

Sales order dates : vbak-erdat, vbak-audat, vbak-vdatu , etc...

hope this helps..

Former Member
0 Kudos

Hi Priyanka,

Generally all sales tables would start with VB*.The required tables for you is VBAK,VBAP,VBRK,VBRP.But if you wanna see Sales order number and its corresponding billing date then you need to link vbak,vbap ->vbuk->vbrk,vbrp.

Regards,

Raghav

Former Member
0 Kudos

Hello,

check these out

Billing Doc Dates : vbrk-fkdat, vbrk-erdat, vbrk-aedat,vbrk-valdt.

Sales order dates : vbak-erdat,vbak-vdatu, vbak-audat.

Regards,

Shehryar