Skip to end of metadata
Go to start of metadata

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 
SPRAS: Language

Descriptions

     MARC

MATNR: Material Number 
WERKS: Plant

Plant Data

              MARD

MATNR: Material Number
WERKS: Plant
LGORT: Storage Location

Storage Location Data

              MAPE

MATNR: Material Number
WERKS: Plant
GZOLX: Preference zone

Export Control File

     MBEW

MATNR: Material Number 
BWKEY: Valuation Area
BWTAR: Valuation Type

Material Valuation

              MBEWH

MATNR: Material Number 
BWKEY: Valuation Area
BWTAR: Valuation Type
LFGJA: Current Year
LFMON: Current period

Material Valuation History

     MVKE

MATNR: Material Number 
VKORG: Sales Organization
VTWEG: Distribution Channel

Sales Data

     MARM

MATNR: Material Number 
MEINH: Unit of Measure

Units of Measure

              MEAN 

MATNR: Material Number 
MEINH: Unit of Measure 
LFNUM: Consecutive Number

EANs

                       MLEA   

MATNR: Material Number 
MEINH: Unit of Measure 
LIFNR: Vendor number 
LFNUM: Consecutive Number

Vendor-Specific EANs

                       MAMT  

MATNR: Material Number 
MEINH: Unit of Measure 
LFDNR: Consecutive Number
SPRAS: Language 
MTXID: Short Text ID

Texts per UoM and Text ID

     MLGN

MATNR: Material Number 
LGNUM: Warehouse Number

Data per Warehouse Number

              MLGT

MATNR: Material Number 
LGNUM: Warehouse Number
LGTYP: Storage Type

Data per Storage Type

     MLAN

MATNR: Material Number 
ALAND: Country

Tax Classification

     MAEX

MATNR: Material Number
ALAND: Country
GEGRU: Legal regulation

Legal Control

     MAPR

MATNR: Material Number 
WERKS: Plant

Index for Forecast

     MVER

MATNR: Material Number 
WERKS: Plant
GJAHR: Fiscal Year
PERKZ: Period Indicator
ZAHLR: Follow-on Records

Material Consumption

     MDMA

MATNR: Material Number 
BERID: MRP Area

MRP Area

 

Related Content

Related Documents

Related SAP Notes/KBAs 

  • No labels