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: 

Link between Purchase Orders - Sales Documents

Former Member
0 Kudos

Hi all,

How can I find the link between a Purchase Order and a Delivery? I searched in table VBFA (Sales Document Flow) but I can't find anything. When I look into this table I only can see WMS Transfers Order and Shipment numbers. Does anybody have a clue where I can find the link?

Thx in advance!

Carl

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

in <b>EKKN</b> table you have sales order and Item fields (VBELN and POSNR)

using these fields search for the deliveries in LIPS table

EKKN-VBELN = LIPS-VGBEL and

EKKN-POSNR = LIPS-VGPOS

<b>Reward points for useful Answers</b>

Regards

Anji

2 REPLIES 2

Former Member
0 Kudos

Hi

in <b>EKKN</b> table you have sales order and Item fields (VBELN and POSNR)

using these fields search for the deliveries in LIPS table

EKKN-VBELN = LIPS-VGBEL and

EKKN-POSNR = LIPS-VGPOS

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member
0 Kudos

Why should we use table <b>EKKN</b>? I've made the link between <b>EKPO</b> and <b>LIPS</b>. (EKPO-EBELN = LIPS-VGBEL and EKPO-EBELP = LIPS-VGPOS). Does it matter? Or is it the same?

Message was edited by:

Carl Onbelet