Purchase Order Open quantity calculation.

[Former Member]

Hi All..

I would like your help in finding out the logic behind calculating the open quantity for a given line item of a purchase order.

Iam aware that i should go to the EKBE table to see purchase order history. Can someone tell me what are all the conditions i need to consider to calculate the Open quantity.

Iam able to give a value E to field BEWTP (Purchase Order History Category) in EKBE and for all the recieved records iam adding the quantity for movement type 101 and removing the quantity for movement type 102 that finally gives my total GR qty. Then iam doing Original PO qty - GR qty to get the Open qty.

Let me know if this logic is wrong or else is there any other conditions to consider.

Appreciate your help and will reward.

THanks.

[Former Member]

Hi All..

I would like your help in finding out the logic behind calculating the open quantity for a given line item of a purchase order.

Iam aware that i should go to the EKBE table to see purchase order history. Can someone tell me what are all the conditions i need to consider to calculate the Open quantity.

Iam able to give a value E to field BEWTP (Purchase Order History Category) in EKBE and for all the recieved records iam adding the quantity for movement type 101 and removing the quantity for movement type 102 that finally gives my total GR qty. Then iam doing Original PO qty - GR qty to get the Open qty.

Let me know if this logic is wrong or else is there any other conditions to consider.

Appreciate your help and will reward.

THanks.

[Former Member]

subtract the PO quantity EKPO-MENGE with the delivery quantity field EKET-GLMNG

Thanks

Seshu