This diagram illustrates the relational structure of data tables within the SAP Material Master. It presents a “Material Master View,” showcasing how various tables are linked to manage comprehensive material information. The central table, MARA (General Material Master), serves as the core, branching out to categories like Material Data, Production, Logistics, and Accounting aspects. These categorized tables, often represented by SAP transaction codes and table names, collectively paint a detailed picture of a material within the SAP system.
Category | Table Names |
---|---|
Material Data | MPG – Material Planning Data |
MARM – Material Unit of Measure | |
MLAN – Material Tax Classification | |
MPOP – Material Forecast Parameter | |
MBEW – Material Valuation Data | |
MARC – Material Data by Plant | |
MARD – Material Data by Storage Location | |
MLGT – Material Data by Storage Type | |
MVKE – Material Sales Data | |
General Material Master | MARA – General Material Master |
Material Description | MAKT – Material Description |
Production Version | MKAL – Production Version of Material |
Bill of Material (BOM) | MAST – BOM Link to Material |
STKO – BOM Header | |
STPO – BOM Item | |
Routing | MAPL – Routing Assignment to Material |
PLKO – Routing Header | |
PLPO – Routing Item | |
Material Ledger | CKLMHD – Material Ledger Header |
CKLMLCR – Material Ledger Total Values | |
CKLMLPP – Material Ledger Total Quantity | |
CKLMLPR – Material Ledger Prices | |
Material Attribute | T134 – Material Type |
T023 – Material Group | |
T179 – Material Production Hierarchy | |
Material Control Record | MARV – Material Control Record |