S096

Distribution Scenario | #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
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
MATNR FK Material Number
WERKS FK Plant
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
PRODV Production: prescribed value
PRODR Production feedback
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
Client S096.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S096.MATNR == MARA.MATNR
  • S096.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S096.VKORG == TVTA.VKORG
  • S096.VTWEG == TVTA.VTWEG
  • S096.SPART == TVTA.SPART
  • S096.MANDT == TVTA.MANDT
Sales organization in order header
  • S096.MANDT == TVKO.MANDT
  • S096.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S096.VKORG == TVKOV.VKORG
  • S096.MANDT == TVKOV.MANDT
  • S096.VTWEG == TVKOV.VTWEG
Plant
  • S096.MANDT == T001W.MANDT
  • S096.WERKS == T001W.WERKS