MARD

Storage Location Data for Material | view | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
Column Name Description
💲 Currency Key (T001.WAERS):
VKLAB Stock value of a value-only material at sales price
VKUML Sales value in stock transfer (SLOc to SLoc)
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
LABST Valuated Unrestricted-Use Stock
UMLME Stock in transfer (from one storage location to another)
INSME Stock in Quality Inspection
EINME Total Stock of All Restricted Batches
SPEME Blocked Stock
RETME Blocked Stock Returns
VMLAB Valuated unrestricted-use stock in previous period
VMUML Stock in Transfer in Previous Period
VMINS Stock in Quality Inspection in Previous Period
VMEIN Restricted-Use Stock in Previous Period
VMSPE Blocked stock of previous period
VMRET Blocked Stock Returns in Previous Period
LMINB Reorder point for storage location MRP
LBSTF Replenishment quantity for storage location MRP
KLABS Unrestricted-Use Consignment Stock
KINSM Consignment Stock in Quality Inspection
KEINM Restricted-Use Consignment Stock
KSPEM Blocked Consignment Stock
FSH_SALLOC_QTY_S Allocated Stock Quantity
/CWM/LABST Valuated Unrestricted-Use Stock
/CWM/INSME Stock in Quality Inspection
/CWM/EINME Total Stock of All Restricted Batches
/CWM/SPEME Blocked Stock
/CWM/RETME Blocked Stock Returns
/CWM/UMLME Stock in transfer (from one storage location to another)
/CWM/KLABS Unrestricted-Use Consignment Stock
/CWM/KINSM Consignment Stock in Quality Inspection
/CWM/KEINM Restricted-Use Consignment Stock
/CWM/KSPEM Blocked Consignment Stock
/CWM/VMLAB Valuated unrestricted-use stock in previous period
/CWM/VMINS Stock in Quality Inspection in Previous Period
/CWM/VMEIN Restricted-Use Stock in Previous Period
/CWM/VMSPE Blocked stock of previous period
/CWM/VMRET Blocked Stock Returns in Previous Period
/CWM/VMUML Stock in Transfer in Previous Period
Column Name Description
DLINL Date of Last Posted Count
ERSDA Created On
Column Name Description
LVORM Flag Material for Deletion at Storage Location Level Show values
SPERR Physical Inventory Blocking Indicator Show values
DISKZ Storage location MRP indicator Show values
MDRUE MARDH rec. already exists for per. before last of MARD per. Show values
Column Name Description Domain name
PSTAT Maintenance status PSTAT
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
KZILL Physical inventory indicator for whse stock in current year INVKZ
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
KZILE Physical inventory indicator for restricted-use stock INVKZ
KZILS Physical inventory indicator for blocked stock INVKZ
KZVLL Physical inventory indicator for stock in previous year INVKZ
KZVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
KZVLE Physical inventory ind. for restricted-use stock, prev.pd INVKZ
KZVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
EXPPG Preference indicator (deactivated) EXPPG
EXVER Export indicator (deactivated) EXVER
LGPBE Storage Bin CHAR10
PRCTL Profit Center PRCTR
LWMKB Picking area for lean WM KOBER
BSKRF Inventory Correction Factor FLTP
MDJIN Fiscal year of current physical inventory indicator GJAHR
DUMMY_STL_INCL_EEW_PS MD PRODUCT Storage location STL_INCL_EEW
Master Data Relations Join Conditions
Country of origin
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • MARD.HERKL == T005.LAND1
  • MARD.MANDT == T005.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • MARD.LGORT == T001L.LGORT
  • MARD.MANDT == T001L.MANDT
  • MARD.WERKS == T001L.WERKS
Special procurement type
  • Plant
  • Special procurement type at storage location level
  • MARD.MANDT == T460A.MANDT
  • MARD.WERKS == T460A.WERKS
  • MARD.LSOBS == T460A.SOBSL
Client MARD.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MARD.MATNR == MARA.MATNR
  • MARD.MANDT == MARA.MANDT
Material number/plant
  • Material Number
  • Client
  • Plant
  • MARD.MATNR == MARC.MATNR
  • MARD.MANDT == MARC.MANDT
  • MARD.WERKS == MARC.WERKS