Question Re: EWM tables for material master in Supply Chain Management Q&A

EWM tables for material master

sandeep_pv — Tue, 08 Jan 2019 04:16:44 GMT

Hi All,

I have checked few tables in EWM for material master like /SAPAPO/MATKEY, /SAPAPO/MATMAP etc.

But could not find any table where I can see all the materials for a warehouse.

Is there any table which shows this data (like MLGN)?

Please advice.

Thanks

Re: EWM tables for material master

former_member543347 — Tue, 08 Jan 2019 13:53:08 GMT

Hi PV,

/SAPAPO/MATLWH. However the warehouse number is not a key in the table; instead the GUID of the supply chain unit and the default party entitled to dispose are used. Check /SCWM/T300_MD for the warehouse number / SCU / entitled assignment.

Re: EWM tables for material master

former_member543347 — Tue, 08 Jan 2019 13:55:17 GMT

Keep in mind also that there is an important difference between WM and EWM: in WM an entry in MLGN is mandatory; in EWM however, an entry in /SAPAPO/MATLWH is optional: you can perfectly have stock in your warehouse without warehouse-specific master data and therefore without an entry in this table.