Tables name & linkages for Delivery qty,Order qty,Inv Qty

[Former Member]

Hi,

can any one tell me where can I find delivery qty, ordered qty, Invoice qty for a PO i.e for a given PO number how can I find the above quantities.

thanks

[former_member181966 · Accepted solution]

You have to read tables VBAP ( Order qty ) , Deliver qty ( LIKP or LIPS ) and invloice qty ( VBRP).

Get one material number . start tracking from VBAP ->VBRP->LIKP

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

Message was edited by: Saquib Khan

[former_member181966]

you can also refer :

http://www.sapgenie.com/abap/tables_sd.htm

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

[Former Member]

Hi,

If you are looking to get the Order quantity, delivered quantity(Goods received) and invoiced quantity (Invoice Receipt - IR), get them from following tables.

EKPO for PO items (it will have PO item details)

EKBE for GR (Goods Receipt) quantity and invoiced quantity. Use the transaction type (VGABE) 1 to get the GR quantities and 2 for IR quantities.. don't forget to subtract the reversed GR quantities using the movement type while calculating the total GR quantity for item (See what movement type being used in your system for GR reversal).

Hope this helps.

Regards,

Nagaraju Chidurupalli.

[Former Member]

Go to the PO history table EKBE.

Rob