How to calulate GR quantity

[Former Member]

Hi All,

In my report, when there is more than one item for a Purchase order, it is bringing the total quantity. The requirement is for each PO item, its GR quantity should be printed.

How to calculte GR quantity for a particular purchase order item?

Thanks,

Ezhil.

[Former Member]

Hi All,

In my report, when there is more than one item for a Purchase order, it is bringing the total quantity. The requirement is for each PO item, its GR quantity should be printed.

How to calculte GR quantity for a particular purchase order item?

Thanks,

Ezhil.

[Former Member]

Hi,

Refer to link below for helpful information:

Regards,

Venkat.

[Former Member]

select the records from ekbe where ebeln = <Purchase Order No>

and ebelp = <PO Line Item>

and vgabe = '1'.

Use the field menge for GR Quantity.

Regards

Vinod

[Former Member]

Dear Ezhil,

you can find GR qty for particular purchase order and line item from table EKET(Schedual line table). In this table WEMNG field is for GR qty but you also need to consider schedual line.

Special mention: This information is not known to all the person working with MM module as I have already passed through such issue so i feel proud to share with the community.

Hope it will also work for you.

Regards,

Neel Thakkar.

Edited by: neelthakkar on Mar 29, 2010 12:23 PM

[Former Member]

It is EKBE( purchase order history table) that will work for you. it has all details you need.