S197BIW1

Periodic storage location stock | #other | Component: Data Collection
Column Name Description
MANDT FK Client
SPMON Period to analyze - month
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
VRSIO Version number in the information structure
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
Column Name Description
📏 Base Unit of Measure (S197.BASME):
MBWBEST Quantity of valuated stock
MKOBEST Quantity of consignment stock
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S197BIW1.MANDT == T006.MANDT
  • S197BIW1.BASME == T006.MSEHI
Storage location
  • Storage location
  • Client
  • Plant
  • S197BIW1.LGORT == T001L.LGORT
  • S197BIW1.MANDT == T001L.MANDT
  • S197BIW1.WERKS == T001L.WERKS
Client S197BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S197BIW1.MATNR == MARA.MATNR
  • S197BIW1.MANDT == MARA.MANDT
Plant
  • S197BIW1.MANDT == T001W.MANDT
  • S197BIW1.WERKS == T001W.WERKS