S226

Material usage: repetitive manufacturing | #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
WERKS FK Plant
MATNR FK Material Number
MCOMP FK BOM component
VERID FK Production Version
KDAUF Sales Order
KDPOS Sales Order Item
PSPNR FK Production Lot (WBS Element)
Column Name Description
💲 Currency Key (WAERS):
ENWRT Issued Value
Column Name Description
📏 Base Unit of Measure (BASME):
BDMNG Requirement Quantity
ENMNG Quantity withdrawn
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
  • S226.MANDT == T006.MANDT
  • S226.BASME == T006.MSEHI
Client S226.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S226.MATNR == MARA.MATNR
  • S226.MANDT == MARA.MANDT
BOM component
  • BOM component
  • Client
  • S226.MCOMP == MARA.MATNR
  • S226.MANDT == MARA.MANDT
Production Version
  • Plant
  • BOM component
  • Production Version
  • Client
  • S226.WERKS == MKAL.WERKS
  • S226.MCOMP == MKAL.MATNR
  • S226.VERID == MKAL.VERID
  • S226.MANDT == MKAL.MANDT
Currency Key
  • S226.MANDT == TCURC.MANDT
  • S226.WAERS == TCURC.WAERS
Plant
  • S226.MANDT == T001W.MANDT
  • S226.WERKS == T001W.WERKS