S126

Open Variants - Basis 1 | #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
VBELN Sales Document
POSNR Sales Document Item
CUOBJ Configuration
Column Name Description
💲 Statistics Currency (STWAE):
AENETWR Net Value of Incoming Orders
AENETWR_D Net value of incoming orders - delta updating
AEKZWI1 Incoming orders: gross
AEKZWI1_D Gross incoming orders - delta updating
AEKZWI2 Incoming orders: net 1
AEKZWI2_D Net incoming orders 1 - delta updating
AEKZWI3 Incoming orders: net 2
AEKZWI3_D Net incoming orders 2 - delta updating
AEKZWI4 Incoming orders: freight
AEKZWI4_D Incoming orders (freight) - delta updating
AEKZWI5 Incoming orders: pricing subtotal 5
AEKZWI5_D Incoming orders PrSub 5 - delta updating
AEKZWI6 Incoming orders: pricing subtotal 6
AEKZWI6_D Incoming orders PrSub 6 - delta updating
OEIWEB Open order value based on confirmation date of sched. line
OEIWEB_D Open order val. based on conf. date of sched. line - delta
OEIWEW Open order value based on desired del. date of sched. line
OEIWEW_D Open ord. val. based on desired del. date sched.line - delta
UMNETWR Net Value of Invoiced Sales
UMNETWR_D Invoiced sales net value - Delta update
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
AEMENGE_D Quantity of incoming orders - delata updating
AEMENGB Qty. incoming orders based on confirm. date of sched. line
AEMENGB_D QtyIO based on confirmation date of sched. line - DeltaUpdat
OEIMEB Open order qty. based on confirmation date of sched. line
OEIMEB_D Open order quantity based on conf. date of sched. line-delta
OEIMEW Open order qty. based on desired del. date of sched. line
OEIMEW_D Open order qty. based on desired del.date of sch.line- delta
LGMNG Delivery quantity in base unit of measure
LGMNG_D Delivery qty in base unit of measure - Delta update
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
MCUPD Indicator whether statistical record was updated Show values
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
  • S126.MANDT == T006.MANDT
  • S126.BASME == T006.MSEHI
Sold-to Party
  • S126.MANDT == KNA1.MANDT
  • S126.KUNNR == KNA1.KUNNR
Client S126.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S126.MATNR == MARA.MATNR
  • S126.MANDT == MARA.MANDT
Division
  • S126.MANDT == TSPA.MANDT
  • S126.SPART == TSPA.SPART
Statistics Currency
  • S126.MANDT == TCURC.MANDT
  • S126.STWAE == TCURC.WAERS
Sales organization in order header
  • S126.MANDT == TVKO.MANDT
  • S126.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S126.VKORG == TVKOV.VKORG
  • S126.MANDT == TVKOV.MANDT
  • S126.VTWEG == TVKOV.VTWEG
Plant
  • S126.MANDT == T001W.MANDT
  • S126.WERKS == T001W.WERKS