12-12-2007 10:28 AM
Hi,
How to find Delivery document number using the sales document number ? i.e how is the link between VBAK and LIKP tables?
regards,
Kannan
12-12-2007 10:30 AM
12-12-2007 10:34 AM
VBAK-vbeln = VBAP-vbeln.
VBAP-vbeln = LIPS-vgbel. and
VBAP-posnr = LIPS-vgpos.
LIPS-vbeln = LIKP-vbeln.
Hope this suffice ur requirement.
Award Points if useful.
12-12-2007 10:37 AM
Hi,
From VBFA table you can link the tables
VBELV - Preceeding document
VBELN - Subsequent document.
Regards,
Satish
12-12-2007 10:43 AM
Hi Kannan,
Delivery items can come from multiple sales orders, depending on your customizing.
LIPS-VGBEL and LIPS-VGPOS point to sales order header and item number.
For one delivery in LIKP you can find multiple items in LIPS which can point to multiple sales orders.
Regards,
Frank Umans