Solved: How to calulate GR quantity

Former Member · ‎2010 Mar 29

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 · ‎2010 Mar 29

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 · ‎2010 Mar 29

Hi,

Refer to link below for helpful information:

Regards,

Venkat.

Former Member · ‎2010 Mar 29

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 · ‎2010 Mar 29

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 · ‎2010 Mar 29

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