Query on GR/IR values

Question:
HI
I am trying to create a query which will give me the GR and IR values of a PO which has been closed.
I am using tables EKPO and EKBE, however I cannot find the related GR value/quantity field. I checked the data and it tells me that GR quantity / value is found in table structure EKBES-WEMNG and EKBES-WEMRT.
Does anyone know how I can add these two fields to my query???
Thanks
Clare
Answer:
Hi Clare,
please check table MSEG, fields MENGE, WAERS and DMBTR.
Bye
Ralf
Answer:
Thanks Ralf
That's great
Clare

More Articles:

Field selection for Purchase info record?
How to get the international version data ?
Details of Release Procedure on a PO?
Want to create New PR through MRP disregarding old PR?
Vendor master?
material view?