table for P.O or STO to fetch Delivery number.

[Former Member]

Is there any other table for delivery like LIPS where i can enter P.O or STO (EBELN) number and fetch its delivery (VBELN) ?

Based on STO or P.O number can I fetch data of outboound and Inboudn delivery ?

I tried using

LIPS -vgpos , but it is line item table AND

EKES table in this table based on P.O or STO i can get VBELN i.e Delivery ,

But it work only with P.O not with STO

[Former Member]

Hi,

You can get it from the table EKBE.

Give the PO number you will get the list of documents created for the PO.

For the delivery number the field PO history Cat = L (Delivery note)

FOR GI the field PO history Cat = U.

Regards,

Gopal.

[Former Member]

Thanks for your reply,

But EKBE append delivery at the time of GI Creation till it is blank

what I want once delivery created then also it must show in EKBE table

[Former Member]

Hi

As mentioned in EKBE tabe select VGABE field for selection ( Transaction Type ) which Gives you status of subsequent documents before PGI and after that.

Regards

Rohit