Equivalent tables for MARA, MAKT and MCH1 in the EWM system
I would like to construct a report using the existing tables in EWM. But it turns out that it's somewhat different from the ECC system.
The material tables, MARA and MAKT and the batch table, MCH1 table are not there. I need the material number( like MARA-MATNR), material description/name(MAKT-MAKTX), the division ( MARA-SPART) and the batch number(MCH1-CHARG) and expiration date(MCH1-VFDAT).
Could someone provide the EWM equivalent for these tables and fields?
In EWM the closest thing to MARA i would say is /SAPAPO/MATKEY. Description can be found in /SAPAPO/MATTXT. I doubt there is any table that has division to product in EWM. EWM is a delivery processing system and division is irrelevant to it. Batch number and SLED can be found in /SCWM/AQUA.
Hope this helps.