SAP Reference

MARC

master Active

Plant Data for Material

Identity

Module: MM · Materials ManagementType: transparent

What the badges mean

Active

Active and unchanged in S/4HANA.

Deprecated

Still readable today, but no longer SAP's strategic path — plan around it.

Replaced

Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).

Migrating to IBP

Planning scope is moving from APO toward IBP.

Active (StRM) · Replaced (EWM)

Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.

Replaced · Compat View

Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.

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).

Linked type codes

CLNT — the client key; filter it explicitly and carry it through every join.

NUMC — fixed-width numeric text; keep it a string and keep the leading zeros.

DATS, TIMS — character date (YYYYMMDD) and time (HHMMSS), zero-filled when initial.

CURR, CUKY, QUAN, UNIT — amounts and quantities, meaningful only beside the currency key or unit that qualifies them.

LANG — a language key in a text table — one row per language.

In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.

Modeling guide

Inventory & stock — What is on hand, where, and what moved it?

Used in the library

Dashboard patterns

D-01Inventory Health

D-03S&OP / Demand Review

Cross-ERP guides

GuideERP Deletes & Change Tracking

GuideSource History & Ingestion Path

Fields

88 fields · 3 key

The join key is all 3 key fields together — matching on any single one fans out. See composite keys in the quirks guide.

88 fields.

Table fields: key flag, field name, description, data type (linked to the data quirks guide where the type carries a known trap), length, and check-table references. 88 fields.
Key	Field	Description	Type	Length	References
Primary key	MANDT	Client	CLNT	3	T000
Primary key	MATNR	Material Number	CHAR	18 / 40	MARA
Primary key	WERKS	Plant	CHAR	4	T001W
	PSTAT	Maintenance Status	CHAR	15
	LVORM	Flag Material for Deletion at Plant Level	CHAR	1
	BWTTY	Valuation Category	CHAR	1
	XCHAR	Batch Management Indicator (Plant)	CHAR	1
	MMSTA	Plant-Specific Material Status	CHAR	2
	MMSTD	Date from Which the Plant-Specific Material Status Is Valid	DATS	8
	MAABC	ABC Indicator	CHAR	1
	KZKRI	Indicator: Critical Part	CHAR	1
	EKGRP	Purchasing Group	CHAR	3	T024
	AUSME	Unit of Issue	UNIT	3	T006
	DISPR	Material: MRP Profile	CHAR	4
	DISMM	MRP Type	CHAR	2
	DISPO	MRP Controller	CHAR	3
	KZDIE	Indicator: MRP Controller Is Buyer	CHAR	1
	PLIFZ	Planned Delivery Time in Days	DEC	3
	WEBAZ	Goods Receipt Processing Time in Days	DEC	3
	MDACH	Action Control: Planned Order Processing	CHAR	2
	LFRHY	Planning Cycle	CHAR	3
	BSTRF	Rounding Value for Purchase Order Quantity	QUAN	13,3
	BSTMI	Minimum Lot Size	QUAN	13,3
	BSTMA	Maximum Lot Size	QUAN	13,3
	BSTFE	Fixed Lot Size	QUAN	13,3
	BESKZ	Procurement Type	CHAR	1
	SOBSL	Special Procurement Type	CHAR	2
	LOSGR	Lot Size (MRP)	QUAN	13,3
	DISLS	Lot Sizing Procedure (MRP)	CHAR	2
	SBDKZ	Dependent Requirements Ind. for Individual and Coll. Reqmts	CHAR	1
	LAGPR	Storage Costs Indicator	CHAR	1	T439L
	ALTSL	Method for Selecting Alternative BOMs	CHAR	1
	KZAUS	Discontinuation Indicator	CHAR	1
	AUSDT	Effective-Out Date	DATS	8
	NFMAT	Follow-Up Material	CHAR	18	MARA
	KZBED	Indicator for Requirements Grouping	CHAR	1
	MISKZ	Mixed MRP Indicator	CHAR	1
	FHORI	Scheduling Margin Key for Floats	CHAR	3
	PFREI	Indicator for Automatic Fixing of Planned Orders	CHAR	1
	FFREI	Release Indicator for Production Orders	CHAR	1
	RGEKZ	Indicator: Backflush	CHAR	1
	FEVOR	Production Supervisor	CHAR	3
	BEARZ	Processing Time	DEC	5,2
	RUEZT	Setup Time	DEC	5,2
	TRANZ	Interoperation Time	DEC	5,2
	BASMG	Base Quantity	QUAN	13,3
	DZEIT	In-House Production Time	DEC	3
	MAXLZ	Maximum Storage Period	DEC	5
	LZEIH	Unit for Maximum Storage Period	UNIT	3	T006
	KZPRO	Indicator: Withdrawal of Stock from Production Bin	CHAR	1
	GPMKZ	Indicator: Material Included in Rough-Cut Planning	CHAR	1
	WZEIT	Total Replenishment Lead Time	DEC	3
	ATPKZ	Replacement Part Indicator	CHAR	1
	VZUSL	Surcharge Factor for Cost in Percent	DEC	5,2
	HERBL	State of Manufacture	CHAR	2
	INSMK	Post to Inspection Stock	CHAR	1
	STRGR	Planning Strategy Group	CHAR	2
	VRMOD	Consumption Mode	CHAR	1
	VINT1	Consumption Period: Backward	NUMC	3
	VINT2	Consumption Period: Forward	NUMC	3
	VERKZ	Version Indicator	CHAR	1
	STLAL	Alternative BOM	CHAR	2
	STLAN	BOM Usage	CHAR	1
	PLNNR	Key for Task List Group	CHAR	8
	APLAL	Group Counter	CHAR	2
	LADGR	Loading Group	CHAR	4
	LGPRO	Issue Storage Location	CHAR	4	T001L
	LGFSB	Default Storage Location for External Procurement	CHAR	4	T001L
	SCHGT	Indicator: Bulk Material	CHAR	1
	CCFIX	CC Indicator Is Fixed	CHAR	1
	EPRIO	Stock Determination Group	CHAR	4
	QZGTP	Certificate Type	CHAR	4
	QMATV	Inspection Setup Exists for Material/Plant	CHAR	1
	PRCTR	Profit Center	CHAR	10	CEPC
	SFEPR	Repetitive Manufacturing Profile	CHAR	4	T437S
	XMCNG	Negative Stocks Allowed in Plant	CHAR	1
	LGRAD	Service Level	DEC	3,1
	OBJID	PP Object ID	NUMC	8
	MTVFP	Checking Group for Availability Check	CHAR	2
	PERIV	Fiscal Year Variant	CHAR	2
	KZKFK	Indicator: Take Correction Factors into Account	CHAR	1
	VRVEZ	Shipping Setup Time	DEC	5,2
	VBAMG	Base Quantity for Shipping	QUAN	13,3
	VBEAZ	Shipping Processing Time	DEC	5,2
	LIZYK	Delivery Cycle (Deactivated — Obsolete)	CHAR	4
	BWESB	Valuated Goods Receipt Blocked Stock	QUAN	13,3
	FABKZ	Indicator: Item-Relevant for JIT Delivery Schedules	CHAR	1
	TRAME	Stock in Transit	QUAN	13,3

Lengths shown as ECC / S/4HANA where the extended material number applies.

Linked type codes in the Type column jump to the matching section of the SAP data quirks guide.

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MARC on Databricks. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaClient (MANDT)Material (MATNR)Plant (WERKS)

Include optional filters (2)

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

-- ============================================================
-- Table  : MARC Plant Data for Material
-- Purpose: Column-selected read of MARC — auto-generated from field metadata
-- Grain  : One row per MATNR + WERKS
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  mc.MANDT AS "Client",
  mc.MATNR AS "Material Number",
  mc.WERKS AS "Plant",
  mc.PSTAT AS "Maintenance Status",
  mc.LVORM AS "Flag Material for Deletion at Plant Level",
  mc.BWTTY AS "Valuation Category",
  mc.XCHAR AS "Batch Management Indicator (Plant)",
  mc.MMSTA AS "Plant-Specific Material Status",
  mc.MMSTD AS "Date from Which the Plant-Specific Material Status Is Valid",
  mc.MAABC AS "ABC Indicator",
  mc.KZKRI AS "Indicator: Critical Part",
  mc.EKGRP AS "Purchasing Group",
  mc.AUSME AS "Unit of Issue",
  mc.DISPR AS "Material: MRP Profile",
  mc.DISMM AS "MRP Type",
  mc.DISPO AS "MRP Controller",
  mc.KZDIE AS "Indicator: MRP Controller Is Buyer",
  mc.PLIFZ AS "Planned Delivery Time in Days",
  mc.WEBAZ AS "Goods Receipt Processing Time in Days",
  mc.MDACH AS "Action Control: Planned Order Processing",
  mc.LFRHY AS "Planning Cycle",
  mc.BSTRF AS "Rounding Value for Purchase Order Quantity",
  mc.BSTMI AS "Minimum Lot Size",
  mc.BSTMA AS "Maximum Lot Size",
  mc.BSTFE AS "Fixed Lot Size",
  mc.BESKZ AS "Procurement Type",
  mc.SOBSL AS "Special Procurement Type",
  mc.LOSGR AS "Lot Size (MRP)",
  mc.DISLS AS "Lot Sizing Procedure (MRP)",
  mc.SBDKZ AS "Dependent Requirements Ind. for Individual and Coll. Reqmts",
  mc.LAGPR AS "Storage Costs Indicator",
  mc.ALTSL AS "Method for Selecting Alternative BOMs",
  mc.KZAUS AS "Discontinuation Indicator",
  mc.AUSDT AS "Effective-Out Date",
  mc.NFMAT AS "Follow-Up Material",
  mc.KZBED AS "Indicator for Requirements Grouping",
  mc.MISKZ AS "Mixed MRP Indicator",
  mc.FHORI AS "Scheduling Margin Key for Floats",
  mc.PFREI AS "Indicator for Automatic Fixing of Planned Orders",
  mc.FFREI AS "Release Indicator for Production Orders"
  -- … plus 48 more columns — full list in the Fields section above
FROM <catalog>.<schema>.marc mc
WHERE
  mc.MANDT = '<MANDT>'
  -- AND mc.MATNR = '<MATNR>'
  -- AND mc.WERKS = '<WERKS>'
ORDER BY mc.MATNR;

Verified August 2026

More query patterns: MM01 MM02 MM03

Relationships

Diagram of 1-hop neighbors — join details below.

Join details

MARAMARCforeign key · 1:N
ON mara.MATNR = marc.MATNR
MARCMARDforeign key · 1:N
ON marc.MATNR = mard.MATNR

Transaction Codes That Use This Table

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