11-09-2006 10:26 PM
11-09-2006 10:35 PM
Hi,
Check the table VBAK, VBAP, VBRK & VBRP..
What dates are you looking for in the billing document??
Thanks,
Naren
11-10-2006 2:28 AM
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
11-10-2006 9:58 AM
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..
11-10-2006 10:03 AM
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
11-13-2006 10:47 AM
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