Sales Document from VBAK ,VBAP and VEDA

[Former Member]

Hi ,

I need to fetch the Sales Document from VBAK and VBAP and VEDA with the contract sign date for sales document line item .

Contract sign date is in selection screen as select options.

Please let me know how to fetch the sales Document per line item from these 3 tables considering that A sales document could have many line items and each can have a different sign date.

Thanks

Sachin

[Former Member]

Hi,

You can achieve this through SAP Query reports.

Regards

Aadesh Kamat

[Former Member]

Hii Sachin Sharma,

Plz use "sq01" to cretae query and find out the data.

Thanks and Regards,

Santanu

[Former Member]

hI...I know the ways to fetch the data..here i want to know the link ups in between these tables...

[Former Member]

Hi,

The link between all the tables VBAK, VBAP and VEDA is VBELN i.e sales document number.

However, while fetching from VBAP and VEDA you would need to consider POSNR as well.

As your ABAPer to code the logic using 'for all entries' method.

Regards,

Amit

Edited by: Amit Iyer on Jun 23, 2011 12:28 PM

[Former Member]

Hii Sachin Sharma,

Please use SE11 to fetch the data.

Thanks and Regards,

Santanu