Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

sales doc number to delivery doc number

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

VBFA - Document Flow.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

From VBFA table you can link the tables

VBELV - Preceeding document

VBELN - Subsequent document.

Regards,

Satish

Former Member
0 Kudos

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