05-12-2010 6:24 AM
Hai All,
Can any one tell me , in which table is the First Date of the Sales Document stored?
I have used VBEP table, but it fetches all the Delivery Dates. But I need only the First Date.
Kavitha.
05-12-2010 6:28 AM
Hi,
What you meant by first date ? Order related dates are available in VBAK.
Regards
Vinod
05-12-2010 6:33 AM
First Date is the "Schedule line date". No, in VBAK , this date is not stored.
05-12-2010 6:39 AM
Hi,
Refer to VBEP-EDATU. This is the explected delivery date of the schedule line of a line item.
Regards
Vinod
05-12-2010 6:42 AM
I have used the same field. But in the output, its fetching all the delivery dates and all the data related to those dates, whereas, I need only the first delivery date and data related to that date.
05-12-2010 6:49 AM
I guess you need to search VBFA (docflow table) for each line item to get the delivery details (vbtyp_n = 'J'). VBFA-ERDAT will give you the delivery created date for VBTYP_N = 'J'.
Regards
Vinod