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.

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

Leave a Comment