Selecting from Delivery to PO ?

[Former Member]

Hi All,

Would you know the best way to get a PO number from Delivery no.?

Currently I am search PO from EKBE-BELNR and EKBE-VGABE but it takes time.

Thankss,

Neeeth

[Vinod_Chandran]

Hi,

Pls follow these steps.

1. Get the sales order of the delivery from VBFA table

2. Using the sales order (VBELN), get the PO (BSTNK) from VBAK table.

Hope this will help you.

Thanks

Vinod

[Former Member]

Since one PO can have many deliveries and one delivery can be for multiple POs(depending on configuration), the link is store at the line item level of the delivery document. On LIPS table there are two fields VGBEL and VGPOS, they should be having the PO number and line item number.

[Former Member]

If it is solved, please close the post.

Regards,

Srinivas