SAP Table MARD

Storage Location Data for Material

MARD (Storage Location Data for Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MARD to other SAP tables.

MARD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
LVORM Flag Material for Deletion at Storage Location Level LVOLG CHAR 1 0
X Yes
NULL No
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
SPERR Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
LABST Valuated Unrestricted-Use Stock LABST QUAN 13 3
UMLME Stock in transfer (from one storage location to another) UMLMD QUAN 13 3
INSME Stock in Quality Inspection INSME QUAN 13 3
EINME Total Stock of All Restricted Batches EINME QUAN 13 3
SPEME Blocked Stock SPEME QUAN 13 3
RETME Blocked Stock Returns RETME QUAN 13 3
VMLAB Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
VMUML Stock in Transfer in Previous Period VMUML QUAN 13 3
VMINS Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
VMEIN Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
VMSPE Blocked stock of previous period VMSPE QUAN 13 3
VMRET Blocked Stock Returns in Previous Period VMRET QUAN 13 3
KZILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZILE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
KZILS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KZVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
KZVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
KZVLE Physical inventory ind. for restricted-use stock, prev.pd KZVLE CHAR 3 0
KZVLS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
DISKZ Storage location MRP indicator DISKZ CHAR 1 0
NULL Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
LSOBS Special procurement type at storage location level LSOBS T460A CHAR 2 0
LMINB Reorder point for storage location MRP LMINB QUAN 13 3
LBSTF Replenishment quantity for storage location MRP LBSTF QUAN 13 3
HERKL Country of origin of the material HERKL T005 CHAR 3 0
EXPPG Preference indicator (deactivated) EXPPG CHAR 1 0
EXVER Export indicator (deactivated) EXVER CHAR 2 0
LGPBE Storage Bin LGPBE CHAR 10 0
KLABS Unrestricted-Use Consignment Stock KLABS QUAN 13 3
KINSM Consignment Stock in Quality Inspection KINSM QUAN 13 3
KEINM Restricted-Use Consignment Stock KEINM QUAN 13 3
KSPEM Blocked Consignment Stock KSPEM QUAN 13 3
DLINL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
PRCTL Profit Center PRCTR CHAR 10 0
ERSDA Created On ERSDA DATS 8 0
VKLAB Stock value of a value-only material at sales price VKLAB CURR 13 2
VKUML Sales value in stock transfer (SLOc to SLoc) VKUML CURR 13 2
LWMKB Picking area for lean WM MARD_KOBER CHAR 3 0
BSKRF Inventory correction factor BSKRF FLTP 16 16
MDRUE MARDH rec. already exists for per. before last of MARD per. MDRUE CHAR 1 0
X Yes
NULL No
MDJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0

MARD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MARD HERKL MARD MANDT T005 Countries MANDT
MARD HERKL MARD HERKL T005 Countries LAND1
MARD LGORT MARD WERKS T001L Storage Locations WERKS
MARD LGORT MARD LGORT T001L Storage Locations LGORT
MARD LGORT MARD MANDT T001L Storage Locations MANDT
MARD LSOBS MARD WERKS T460A Special procurement key WERKS
MARD LSOBS MARD LSOBS T460A Special procurement key SOBSL
MARD LSOBS MARD MANDT T460A Special procurement key MANDT
MARD MANDT MARD MANDT T000 Clients MANDT
MARD MATNR MARD MANDT MARA General Material Data MANDT
MARD MATNR MARD MATNR MARA General Material Data MATNR
MARD WERKS MARD MANDT MARC Plant Data for Material MANDT
MARD WERKS MARD MATNR MARC Plant Data for Material MATNR
MARD WERKS MARD WERKS MARC Plant Data for Material WERKS