S129

Open Variants - Planning | #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
WERKS FK Plant
MATNR FK Material Number
ATINN Internal characteristic
ATWRT Characteristic Value
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
Master Data Relations Join Conditions
Base Unit of Measure
  • S129.MANDT == T006.MANDT
  • S129.BASME == T006.MSEHI
Class Type
  • S129.MANDT == TCLA.MANDT
  • S129.KLART == TCLA.KLART
Client S129.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S129.MATNR == MARA.MATNR
  • S129.MANDT == MARA.MANDT
Statistics Currency
  • S129.MANDT == TCURC.MANDT
  • S129.STWAE == TCURC.WAERS
Plant
  • S129.MANDT == T001W.MANDT
  • S129.WERKS == T001W.WERKS