S125

Forecast history for ex. system | #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
MATNR FK Material Number
WERKS FK Plant
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
MATKL FK Material Group
PRODH FK Product hierarchy
KUNNR FK Sold-to Party
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
LFIMG Actual quantity delivered (in sales units)
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
  • S125.MANDT == T006.MANDT
  • S125.BASME == T006.MSEHI
Sold-to Party
  • S125.MANDT == KNA1.MANDT
  • S125.KUNNR == KNA1.KUNNR
Client S125.MANDT == T000.MANDT
Material Group
  • S125.MANDT == T023.MANDT
  • S125.MATKL == T023.MATKL
Material: order item
  • Material Number
  • Client
  • S125.MATNR == MARA.MATNR
  • S125.MANDT == MARA.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • S125.PRODH == T179.PRODH
  • S125.MANDT == T179.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S125.VKORG == TVTA.VKORG
  • S125.VTWEG == TVTA.VTWEG
  • S125.SPART == TVTA.SPART
  • S125.MANDT == TVTA.MANDT
Sales organization in order header
  • S125.MANDT == TVKO.MANDT
  • S125.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S125.VKORG == TVKOV.VKORG
  • S125.MANDT == TVKOV.MANDT
  • S125.VTWEG == TVKOV.VTWEG
Plant
  • S125.MANDT == T001W.MANDT
  • S125.WERKS == T001W.WERKS