Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

display the purchase order using plant & material in reports

Former Member
0 Kudos

Hi experts,

i wanna print purchase order based on plant and material. in the purchase order i need date(cretion date of po) , po item, po num ,quantity , available quantity.

i could not able to find the table in which date , quan & available quantity available .please tell me the table name.

thanks in advance,

regards,

srikanth.

3 REPLIES 3

madhu_vadlamani
Active Contributor
0 Kudos

Hi Srikanth,

Check the tables. Ekko.ekpo,Mara.

Regards,

Madhu.

Former Member
0 Kudos

Hello Srikanth,

Please check the tables below:

MARA General Material Data

MARC Plant Data for Material

EKKO Purchasing Document Header

EKPO Purchasing Document Item

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

For more table names please check the link below:

http://www.sap-img.com/materials/common-tables-used-by-sap-mm.htm

Hope that helps!

Regards,

Saba

Edited by: Saba Sayed on Feb 18, 2011 6:29 PM

Former Member
0 Kudos

Hi Srikanth,

I think you try this way.

get data from EKPO for matnr and werks then use PO doc to get erdat from EKKO, go to MARD to get alv quantity.

Thanks,

Anmol.