S128

Open Variants - SIS | #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
KLART FK Class Type
MATNR FK Material Number
ATINN Internal characteristic
ATWRT Characteristic Value
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNNR FK Sold-to Party
WERKS FK Plant
Column Name Description
💲 Statistics Currency (STWAE):
AENETWR Net Value of Incoming Orders
AEKZWI1 Incoming orders: gross
AEKZWI2 Incoming orders: net 1
AEKZWI3 Incoming orders: net 2
AEKZWI4 Incoming orders: freight
AEKZWI5 Incoming orders: pricing subtotal 5
AEKZWI6 Incoming orders: pricing subtotal 6
OEIWEB Open order value based on confirmation date of sched. line
OEIWEW Open order value based on desired del. date of sched. line
UMNETWR Net Value of Invoiced Sales
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
AEMENGB Qty. incoming orders based on confirm. date of sched. line
OEIMEB Open order qty. based on confirmation date of sched. line
OEIMEW Open order qty. based on desired del. date of sched. line
LGMNG Delivery quantity in base unit of measure
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
AEFREQ Incoming orders: frequency DECV15_3
AEFREQB Incoming orders: frequency acc. to conf. date of sched. line DECV15_3
OEFREQB Open incoming orders: freq acc. to conf. date of sched. line DECV15_3
OEFREQW Open incoming orders: freq acc. to desired dlv. date of SL DECV15_3
LGFREQ Delivery frequency in base unit of measure DECV15_3
Master Data Relations Join Conditions
Base Unit of Measure
  • S128.MANDT == T006.MANDT
  • S128.BASME == T006.MSEHI
Class Type
  • S128.MANDT == TCLA.MANDT
  • S128.KLART == TCLA.KLART
Sold-to Party
  • S128.MANDT == KNA1.MANDT
  • S128.KUNNR == KNA1.KUNNR
Client S128.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S128.MATNR == MARA.MATNR
  • S128.MANDT == MARA.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S128.VKORG == TVTA.VKORG
  • S128.VTWEG == TVTA.VTWEG
  • S128.SPART == TVTA.SPART
  • S128.MANDT == TVTA.MANDT
Statistics Currency
  • S128.MANDT == TCURC.MANDT
  • S128.STWAE == TCURC.WAERS
Sales organization in order header
  • S128.MANDT == TVKO.MANDT
  • S128.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S128.VKORG == TVKOV.VKORG
  • S128.MANDT == TVKOV.MANDT
  • S128.VTWEG == TVKOV.VTWEG
Plant
  • S128.MANDT == T001W.MANDT
  • S128.WERKS == T001W.WERKS