hi experts - total quantity in so

[Former Member]

hi all

i have customer po number in the tax invoice, now from this CPO nomber i have to get the total quantity from the sales order for that cutomer p.o. number.

right now i am getting bill quantity in tax invoice, i want total quantity for that cust. p.o. in tax invoice in the sales order.

thanx

rocky

[Former Member]

Hello,

U can use the below logic for the progtram

Get the material number from VBRP

fetch the PO number from the VBAK table for that invocie

check table EKPO for that material and the PO number

You can get the quantities from the PO and print the same

hope it helps ,

Thanks

Akasha

[Former Member]

You can go to VBAK table and pass your Customer PO Number to get the corresponding sales order number...

Once you get your sales order number, through VBAP table, you can get the sales order quantities..