SAP table MARD (Storage Location Data for Material)

SAP table MARD has 4 primary key fields being MANDT,MATNR,WERKS,LGORT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

MARD foreign key relationships

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