The Main Important SAP Material Master Tables ( Data & Customizing )

In this article, you will find the main SAP Material Master Tables divided into SAP Master Material Tables for Data and for Customizing.

So you will find other than SAP Material Tables, the list of SAP Material Group / Category for better handle the SAP Material Management…

What’s Material Master ?

Up to SAP, “The material master contains information on all the materials that a company procures or produces, stores, and sells. It is the company’s central source for retrieving material-specific data.

This information is stored in individual material master records.”

Where SAP Material Master is used ?

The material master is used by all components in the SAP Logistics System.

The integration of all material data in a single database object eliminates redundant data storage.

In the SAP Logistics System, the data contained in the material master is required, for example, for the following functions:

  • In Purchasing for ordering
  • In Inventory Management for goods movement postings and physical inventory
  • In Invoice Verification for posting invoices
  • In Sales and Distribution for sales order processing
  • In Production Planning and Control for material requirements planning, scheduling, and work scheduling

(Source: Material Master (LO-MD-MM) )


SAP Material Master Tables List

The main Material Master Tables in SAP are:

SAP TABLESDESCRIPTION
MARASAP Material Master Table for General data
MAKTMaterial Master: Description
MARMMaterial Master: Unit of Measure
MAPEMaterial master: Export control file
MARCMaterial master: Plant data
MARDMaterial master: Storage location
MBEWMaterial valuation
MLGNMaterial Master: WM Inventory
MLGTMaterial Master: WM Inventory type
MDIPMaterial: MRP profiles (field contents)
MVERMaterial Master: Consumption
DVERSAP Material Master: Consumption
MVKESAP ?Material Master: Sales
MLANSAP Material Master: Tax indicator
MAPRSAP Material Master: Forecast
MCH1SAP Material Master: X Plant Batches
MCHASAP Material Master Table: ?Batches
MCHBSAP Material Master: Batch Stock
MOFFOutstanding Material Master Records (Maintenance status)
MARCHMaterial Master C Segment: History
MARDHMaterial Master Storage Location Segment: History
MBEWHMaterial Valuation: History
STKOBOM Header Details
STPOBOM Item Details
MASTMaterial to BOM Link
T023Material Groups

The new section, some important Material Master Tables in SAP will detail with the condition to Join.

Also the main Customizing SAP MM Tables for Materials ( for SAP Material Category and Material Type )


SAP Material Master Tables Details

General Material Data Table: MARA

MARA is the SAP Master data Table for Material. MARA stores all the General Material Data.

The Key for a SAP Material is MARA-MATNR.

MARC: Plant Data for Material

MARC stored the Plant related data for SAP Material.

The keys for this Table are:

  • MATNR for the Material Number
  • WERKS for the Plant id.

MARD: Storage Location Data for Material

In SAP, the definition of a PLANT is : “A place where materials are produced, or goods and services are provided.”

MAKT: Material Descriptions

MAKT is the table where SAP Material Description are set. It is language-dependent table.

The field for Material Description is MAKT-MAKTX

MARM: Units of Measure for Material

MARM sets the conversion between the possible units of measure for the material.

For more detail check my other post about SAP Material Alternative Unit.

MBEW: Material Valuation

  • MATNR for Material Number
  • BWKEY for Valuation Area
  • BWTAR for BWTAR_D Valuation Type

Valuation Area (BWKEY) is BWKEY “Organizational level at which the material is valuated. A valuation area can a plant or all plants belonging to a company.

Valuation Type (BWTAR) Uniquely identifies separately valuated stocks of a material. For example, if you want to evaluate the material by origin, set Valuation type to Origin H.


SAP Material Tables for Customizing

SAP Material Type

The type of Material is set on MARA-MTART.

The Material Type is configured in the table T134 (Material Types). The description of the type can be found on T134T Table.

Read more about List of Important SAP Material Types in SAP MM

SAP Material Category ( SAP Material Group )

The field MARA-ATTYP define the SAP Material Category.
The value are set in the fixed value of the Domain ATTYP.

Check the table DD07T with DOMNAME= ‘ATTYP’.

Material Categories can have these value:

SAP MATERIAL CATEGORYDESCRIPTION
Single material (industry)
00Single material
01Generic material
02Variant
10Sales set
11Prepack
12Display
20Material group material
21Hierarchy material
22Group material
30Material group reference material