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…
Table of Contents
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.”
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:
(Source: Material Master (LO-MD-MM))
The main Material Master Tables in SAP are:
SAP TABLES | DESCRIPTION |
---|---|
MARA | SAP Material Master Table for General data |
MAKT | Material Master: Description |
MARM | Material Master: Unit of Measure |
MAPE | Material master: Export control file |
MARC | Material master: Plant data |
MARD | Material master: Storage location |
MBEW | Material valuation |
MLGN | Material Master: WM Inventory |
MLGT | Material Master: WM Inventory type |
MDIP | Material: MRP profiles (field contents) |
MVER | Material Master: Consumption |
DVER | SAP Material Master: Consumption |
MVKE | SAP ?Material Master: Sales |
MLAN | SAP Material Master: Tax indicator |
MAPR | SAP Material Master: Forecast |
MCH1 | SAP Material Master: X Plant Batches |
MCHA | SAP Material Master Table: ?Batches |
MCHB | SAP Material Master: Batch Stock |
MOFF | Outstanding Material Master Records (Maintenance status) |
MARCH | Material Master C Segment: History |
MARDH | Material Master Storage Location Segment: History |
MBEWH | Material Valuation: History |
STKO | BOM Header Details |
STPO | BOM Item Details |
MAST | Material to BOM Link |
T023 | Material 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)
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 stored the Plant related data for SAP Material.
The keys for this table are:
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 is the table where SAP Material Description are set. It is language-dependent table.
The field for Material Description is MAKT-MAKTX
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.
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.
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
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 CATEGORY | DESCRIPTION |
---|---|
Single material (industry) | |
00 | Single material |
01 | Generic material |
02 | Variant |
10 | Sales set |
11 | Prepack |
12 | Display |
20 | Material group material |
21 | Hierarchy material |
22 | Group material |
30 | Material group reference material |
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…