S200

Inventory Controlling Stores | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
INVNU Physical Inventory Number
WERKS FK Plant
LGORT Storage location
MATKL FK Material Group
MATNR FK Material Number
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
BSTAR FK Stock type
IVSTAT Statistical status of physical inventory Show values
Column Name Description
💲 Local Currency (HWAER):
IBUGEO Book inventory balance at cost
IBUGVO Book inventory balance at retail
IBUGVP Book inventory balance at retail with tax
IZLGEO Quantity of stock counted at cost
IZLGVO Quantity of stock counted at retail
IZLGVP Quantity of stock counted at retail with tax
IDMGEO Minus inventory difference at cost
IDMGVO Minus inventory difference at retail
IDMGVP Minus inventory difference at retail
IDPGEO Plus inventory difference at cost
IDPGVO Plus inventory difference at retail
IDPGVP Plus inventory difference at retail with tax
Column Name Description
📏 Base Unit of Measure (BASME):
IBUMNG Book inventory balance, quantity in base unit of measure
IZLMNG Quantity of stock, counted in base unit of measure
IDMMNG Minus inventory difference quantity in BUn
IDPMNG Plus inventory difference quantity in BUn
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
IVSTAT Statistical status of physical inventory Show values
BTRKZ Plant category Show values
KWART Indicates that the value-only material is to be inventoried Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
WGRU1 Material group hierarchy 1 KLASSE
WGRU2 Material group hierarchy 2 KLASSE
Master Data Relations Join Conditions
Department number
  • Department number
  • Client
  • S200.ABTNR == TSAB.ABTNR
  • S200.MANDT == TSAB.MANDT
Base Unit of Measure
  • S200.MANDT == T006.MANDT
  • S200.BASME == T006.MSEHI
Stock type S200.BSTAR == T064A.BSTAR
Batch Number
  • Material Number
  • Client
  • Batch Number
  • S200.MATNR == MCH1.MATNR
  • S200.MANDT == MCH1.MANDT
  • S200.CHARG == MCH1.CHARG
Local Currency
  • S200.MANDT == TCURC.MANDT
  • S200.HWAER == TCURC.WAERS
Client S200.MANDT == T000.MANDT
Material Group
  • S200.MANDT == T023.MANDT
  • S200.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S200.MATNR == MARA.MATNR
  • S200.MANDT == MARA.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • S200.SATNR == MARA.MATNR
  • S200.MANDT == MARA.MANDT
Special Stock Indicator
  • S200.MANDT == T148.MANDT
  • S200.SOBKZ == T148.SOBKZ
Plant
  • S200.MANDT == T001W.MANDT
  • S200.WERKS == T001W.WERKS