S137

Variants: Basis 2 | #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
CLINT Characteristics combination
LNPOS Combination value key
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
  • S137.MANDT == T006.MANDT
  • S137.BASME == T006.MSEHI
Sold-to Party
  • S137.MANDT == KNA1.MANDT
  • S137.KUNNR == KNA1.KUNNR
Client S137.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S137.MATNR == MARA.MATNR
  • S137.MANDT == MARA.MANDT
Division
  • S137.MANDT == TSPA.MANDT
  • S137.SPART == TSPA.SPART
Statistics Currency
  • S137.MANDT == TCURC.MANDT
  • S137.STWAE == TCURC.WAERS
Sales Organization
  • S137.MANDT == TVKO.MANDT
  • S137.VKORG == TVKO.VKORG
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • S137.VKORG == TVKOV.VKORG
  • S137.MANDT == TVKOV.MANDT
  • S137.VTWEG == TVKOV.VTWEG
Plant
  • S137.MANDT == T001W.MANDT
  • S137.WERKS == T001W.WERKS