The Ultimate Resource for SAP ERP Flowcharts, Diagrams, and Cheat Sheets.

Picture Description

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.

CategoryTable Names
Material DataMPG – 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 MasterMARA – General Material Master
Material DescriptionMAKT – Material Description
Production VersionMKAL – Production Version of Material
Bill of Material (BOM)MAST – BOM Link to Material
STKO – BOM Header
STPO – BOM Item
RoutingMAPL – Routing Assignment to Material
PLKO – Routing Header
PLPO – Routing Item
Material LedgerCKLMHD – Material Ledger Header
CKLMLCR – Material Ledger Total Values
CKLMLPP – Material Ledger Total Quantity
CKLMLPR – Material Ledger Prices
Material AttributeT134 – Material Type
T023 – Material Group
T179 – Material Production Hierarchy
Material Control RecordMARV – Material Control Record

Leave a Comment