Material Master Data structure
Some material master datas are valid everywhere, but some only on respective organisational level. For instance, a material may be shipped differently in different plants. The different datas on the respective orgalisational levels are stored in different database tables, approximately following the principle of relational database management. The data structures are:
Table | Key | Description |
---|---|---|
MARA | MATNR: Material Number | General Material Data |
MAKT | MATNR: Material Number | Descriptions |
MARC | MATNR: Material Number | Plant Data |
MARD | MATNR: Material Number | Storage Location Data |
MAPE | MATNR: Material Number | Export Control File |
MBEW | MATNR: Material Number | Material Valuation |
MBEWH | MATNR: Material Number | Material Valuation History |
MVKE | MATNR: Material Number | Sales Data |
MARM | MATNR: Material Number | Units of Measure |
MEAN | MATNR: Material Number | EANs |
MLEA | MATNR: Material Number | Vendor-Specific EANs |
MAMT | MATNR: Material Number | Texts per UoM and Text ID |
MLGN | MATNR: Material Number | Data per Warehouse Number |
MLGT | MATNR: Material Number | Data per Storage Type |
MLAN | MATNR: Material Number | Tax Classification |
MAEX | MATNR: Material Number | Legal Control |
MAPR | MATNR: Material Number | Index for Forecast |
MVER | MATNR: Material Number | Material Consumption |
MDMA | MATNR: Material Number | MRP Area |