SAP Reference

MARD

master Active · Proxy View

Proxy view: reads route through NSDM proxy/CDS views

Storage Location Data for Material

Identity

Module: MM · Materials ManagementType: transparent

S/4HANA

How proxy views work

Notes

Master data persists in MARD; stock quantities calculated via NSDM CDS/proxy views using MATDOC/MATDOC_EXTRACT

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

KPI definitions

K-05Inventory Turns

K-06Days of Supply (DOS / DIO)

K-10Excess & Obsolete (E&O)

Dashboard patterns

D-01Inventory Health

Cross-ERP guides

GuideERP Deletes & Change Tracking

GuideSource History & Ingestion Path

GuideInventory Snapshot Patterns

GuideERP Data Quality Checklist

Fields

34 fields · 4 key

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

34 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. 34 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
Primary key	LGORT	Storage Location	CHAR	4	T001L
	PSTAT	Maintenance Status	CHAR	15
	LVORM	Flag Material for Deletion at Storage Location Level	CHAR	1
	LFGJA	Fiscal Year of Current Period	NUMC	4
	LFMON	Current Period (Posting Period)	NUMC	2
	LABST	Valuated Unrestricted-Use Stock	QUAN	13,3
	UMLME	Stock in Transfer (Storage Location to Storage Location)	QUAN	13,3
	INSME	Stock in Quality Inspection	QUAN	13,3
	EINME	Total Stock of All Restricted Batches	QUAN	13,3
	SPEME	Blocked Stock	QUAN	13,3
	RETME	Blocked Stock Returns	QUAN	13,3
	VMLAB	Unrestricted-Use Stock in Previous Period	QUAN	13,3
	VMUML	Stock in Transfer in Previous Period	QUAN	13,3
	VMINS	Quality Inspection Stock in Previous Period	QUAN	13,3
	VMEIN	Restricted-Use Stock in Previous Period	QUAN	13,3
	VMSPE	Blocked Stock in Previous Period	QUAN	13,3
	VMRET	Blocked Stock Returns in Previous Period	QUAN	13,3
	KZILL	Physical Inventory Indicator for Whse Mgmt	CHAR	3
	KZILQ	Physical Inventory Ind. for Quality Inspection Stock	CHAR	3
	KZILE	Physical Inventory Indicator for Restricted-Use Stock	CHAR	3
	KZILS	Physical Inventory Indicator for Blocked Stock	CHAR	3
	KZVLL	Physical Inventory Indicator for Whse Mgmt in Previous Period	CHAR	3
	KZVLQ	Physical Inventory Indicator for Quality Inspection Stock in Previous Period	CHAR	3
	KZVLE	Physical Inventory Indicator for Restricted-Use Stock in Previous Period	CHAR	3
	KZVLS	Physical Inventory Indicator for Blocked Stock in Previous Period	CHAR	3
	DISKZ	Storage Location MRP Indicator	CHAR	1
	LSOBS	Storage Location Special Procurement Type	CHAR	2
	LMINB	Reorder Point for Storage Location MRP	QUAN	13,3
	LBSTF	Replenishment Quantity for Storage Location MRP	QUAN	13,3
	LWMKB	Picking Area for Lean WM	CHAR	3
	BSKRF	Inventory Correction Factor	FLTP	16,16

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 MARD 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  : MARD Storage Location Data for Material
-- Purpose: Column-selected read of MARD — auto-generated from field metadata
-- Grain  : One row per MATNR + WERKS + LGORT
-- 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
  md.MANDT AS "Client",
  md.MATNR AS "Material Number",
  md.WERKS AS "Plant",
  md.LGORT AS "Storage Location",
  md.PSTAT AS "Maintenance Status",
  md.LVORM AS "Flag Material for Deletion at Storage Location Level",
  md.LFGJA AS "Fiscal Year of Current Period",
  md.LFMON AS "Current Period (Posting Period)",
  md.LABST AS "Valuated Unrestricted-Use Stock",
  md.UMLME AS "Stock in Transfer (Storage Location to Storage Location)",
  md.INSME AS "Stock in Quality Inspection",
  md.EINME AS "Total Stock of All Restricted Batches",
  md.SPEME AS "Blocked Stock",
  md.RETME AS "Blocked Stock Returns",
  md.VMLAB AS "Unrestricted-Use Stock in Previous Period",
  md.VMUML AS "Stock in Transfer in Previous Period",
  md.VMINS AS "Quality Inspection Stock in Previous Period",
  md.VMEIN AS "Restricted-Use Stock in Previous Period",
  md.VMSPE AS "Blocked Stock in Previous Period",
  md.VMRET AS "Blocked Stock Returns in Previous Period",
  md.KZILL AS "Physical Inventory Indicator for Whse Mgmt",
  md.KZILQ AS "Physical Inventory Ind. for Quality Inspection Stock",
  md.KZILE AS "Physical Inventory Indicator for Restricted-Use Stock",
  md.KZILS AS "Physical Inventory Indicator for Blocked Stock",
  md.KZVLL AS "Physical Inventory Indicator for Whse Mgmt in Previous Period",
  md.KZVLQ AS "Physical Inventory Indicator for Quality Inspection Stock in Previous Period",
  md.KZVLE AS "Physical Inventory Indicator for Restricted-Use Stock in Previous Period",
  md.KZVLS AS "Physical Inventory Indicator for Blocked Stock in Previous Period",
  md.DISKZ AS "Storage Location MRP Indicator",
  md.LSOBS AS "Storage Location Special Procurement Type",
  md.LMINB AS "Reorder Point for Storage Location MRP",
  md.LBSTF AS "Replenishment Quantity for Storage Location MRP",
  md.LWMKB AS "Picking Area for Lean WM",
  md.BSKRF AS "Inventory Correction Factor"
FROM <catalog>.<schema>.mard md
WHERE
  md.MANDT = '<MANDT>'
  -- AND md.MATNR = '<MATNR>'
  -- AND md.WERKS = '<WERKS>'
ORDER BY md.MATNR;

Verified August 2026

More query patterns: MB52 MD04 MM01

Released CDS views over this table

Released SAP standard VDM views that read over MARD. Prefer these over classic-table reads on S/4HANA where available.

I_MaterialStock_2On-hand stock quantities by material, plant, and storage location, calculated from material documents.

MARD

Fields

Boilerplate SQL

Released CDS views over this table

Relationships

Join details

Transaction Codes That Use This Table

Primary t-codes

Secondary t-codes

More Materials Management tables