Skip to Content
0
Former Member
Nov 08, 2006 at 10:55 PM

how to combine sales and delivery data

64 Views

hi

i have requirement to make a report from sales as well as deliveries. Important fields in report are sales document , material , plant , sales document type , country key , sold to party , ordered quantity , delivered quantity , price from vakon ( KBETR ), actual goods issue date.

The required extractors are 2LIS_11_VASCL, 2LIS_11_V_SSL ,2LIS_11_VAKON.

Problem is how to combine sales and delivery data as V_SSL has different key figures.Multicube is not the solution as dont have plant , sold to party and many other fields in V_SSL.

Kindly suggest how to combine sales and deivery data.

Regards,

Monika