SAP Reference

MM01

Create S/4HANA status: Active

Create Material

Module: MM · Materials Management
What the badges mean
S/4HANA status: Active
Active and unchanged in S/4HANA.
S/4HANA status: Deprecated
Still readable today, but no longer SAP's strategic path — plan around it.
S/4HANA status: Replaced
Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
S/4HANA status: Migrating to IBP
Planning scope is moving from APO toward IBP.
S/4HANA status: Active (StRM) · Replaced (EWM)
Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
S/4HANA status: Replaced · Compat View
Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
S/4HANA status: Active · Proxy View
Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
master
Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

5 parameters not filled: <catalog>, <schema>, <MANDT>, <MATNR>, <WERKS>

-- ============================================================
-- T-Code : MM01 Create Material
-- Purpose: Create material-master record across client, plant, and storage-location views
-- Grain  : One row per material / plant / storage-location combination
-- Tables : MARA, MAKT, MARC, MARD, MBEW, T001W, T001L, T134T, T023T
-- Notes  : MARA is client-level; MARC adds plant; MARD adds storage location. MAKT carries descriptions by language — filter SPRAS = 'E'. Valuation currency is T001.WAERS via T001K (valuation area), not stored on MBEW.
-- ============================================================
SELECT
  -- Keys
  m.MANDT   AS "Client",
  m.MATNR   AS "Material Number",
  mc.WERKS  AS "Plant",
  md.LGORT  AS "Storage Location",

  -- Descriptive text
  mt.MAKTX  AS "Material Description",
  t134t.MTBEZ AS "Material Type Description",
  t023t.WGBEZ AS "Material Group Description",

  -- Quantities + UOM (paired)
  m.BRGEW   AS "Gross Weight",
  m.GEWEI   AS "Weight Unit",
  m.NTGEW   AS "Net Weight",
  md.LABST  AS "Unrestricted Stock",
  m.MEINS   AS "Base Unit of Measure",

  -- Dates
  m.ERSDA   AS "Created On",
  m.LAEDA   AS "Changed On",

  -- Status / indicators
  m.LVORM   AS "Deletion Flag (Client)",
  mc.MMSTA  AS "Plant Status",
  md.LVORM  AS "Deletion Flag (Storage Loc)",

  -- Org fields
  pt.NAME1  AS "Plant Name",
  sl.LGOBE  AS "Storage Location Name",

  -- Master data enrichment
  m.MTART   AS "Material Type",
  m.MATKL   AS "Material Group",
  mc.DISMM  AS "MRP Type",
  mc.DISPO  AS "MRP Controller",
  mc.EKGRP  AS "Purchasing Group",
  mb.STPRS  AS "Standard Price",
  mb.VERPR  AS "Moving Average Price",
  mb.PEINH  AS "Price Unit"
FROM <catalog>.<schema>.mara m
LEFT JOIN <catalog>.<schema>.makt mt
  ON  mt.MANDT = m.MANDT
  AND mt.MATNR = m.MATNR
  AND mt.SPRAS = 'E'
LEFT JOIN <catalog>.<schema>.marc mc
  ON  mc.MANDT = m.MANDT
  AND mc.MATNR = m.MATNR
LEFT JOIN <catalog>.<schema>.mard md
  ON  md.MANDT = mc.MANDT
  AND md.MATNR = mc.MATNR
  AND md.WERKS = mc.WERKS
LEFT JOIN <catalog>.<schema>.mbew mb
  ON  mb.MANDT = m.MANDT
  AND mb.MATNR = m.MATNR
  AND mb.BWKEY = mc.WERKS
LEFT JOIN <catalog>.<schema>.t001w pt
  ON  pt.MANDT = mc.MANDT
  AND pt.WERKS = mc.WERKS
LEFT JOIN <catalog>.<schema>.t001l sl
  ON  sl.MANDT = md.MANDT
  AND sl.WERKS = md.WERKS
  AND sl.LGORT = md.LGORT
LEFT JOIN t134t t134t
  ON  t134t.MANDT = m.MANDT
  AND t134t.MTART = m.MTART
  AND t134t.SPRAS = 'E'
LEFT JOIN t023t t023t
  ON  t023t.MANDT = m.MANDT
  AND t023t.MATKL = m.MATKL
  AND t023t.SPRAS = 'E'
WHERE
  m.MANDT = '<MANDT>'
  AND m.MATNR = '<MATNR>'
  -- AND mc.WERKS = '<WERKS>'
  -- AND m.LVORM <> 'X'
ORDER BY m.MATNR, mc.WERKS, md.LGORT;

Tables Used by This Transaction

How these tables connect — join details in the list below.

Join details

  • MARAMARCforeign key · 1:N
    ON mara.MATNR = marc.MATNR
  • MARCMARDforeign key · 1:N
    ON marc.MATNR = mard.MATNR
  • MARAMAKTtext table · 1:N
    ON mara.MATNR = makt.MATNR
  • MARAMBEWforeign key · 1:N
    ON mara.MATNR = mbew.MATNR
  • MARAMVKEforeign key · 1:N
    ON mara.MATNR = mvke.MATNR
  • MARAMARMforeign key · 1:N
    ON mara.MATNR = marm.MATNR

R read · W write · R/W read + write

More Materials Management t-codes