07-31-2007 2:03 PM
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
07-31-2007 5:45 PM
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
07-31-2007 5:45 PM
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
08-01-2007 8:32 AM
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