0MAT_ST_LOC_ATTR

Material Number Compounded to Plant and Storage Location | #ATTR | Extraction method: F1 | Delta: NEWE | Component: Logistics Master Data
Tables used: MARDMARCMARAT001LKNA1 ... +12 more
Column Name Description
MANDT FK Client
MATNR Material Number
WERKS Plant
LGORT Storage location
Column Name Description
VKLAB Stock value of a value-only material at sales price
VKUML Sales value in stock transfer (SLOc to SLoc)
Column Name Description
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
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
LSOBS Special procurement type at storage location level SOBSL
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
Master Data Relations Join Conditions
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • 0MAT_ST_LOC_ATTR.HERKL == T005.LAND1
  • 0MAT_ST_LOC_ATTR.MANDT == T005.MANDT
Client 0MAT_ST_LOC_ATTR.MANDT == T000.MANDT