S125E

S125 - Structural information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
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
Column Name Description
Column Name Description
Column Name Description Domain name
UBASME Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Factor (%) for disaggregation of planning level quantity CHAR10
Master Data Relations Join Conditions
Base Unit of Measure
  • S125E.MANDT == T006.MANDT
  • S125E.BASME == T006.MSEHI
Sold-to Party
  • S125E.MANDT == KNA1.MANDT
  • S125E.KUNNR == KNA1.KUNNR
Client S125E.MANDT == T000.MANDT
Material Group
  • S125E.MANDT == T023.MANDT
  • S125E.MATKL == T023.MATKL
Material: order item
  • Material Number
  • Client
  • S125E.MATNR == MARA.MATNR
  • S125E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S125E.PERIV == T009.PERIV
  • S125E.MANDT == T009.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • S125E.PRODH == T179.PRODH
  • S125E.MANDT == T179.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S125E.VKORG == TVTA.VKORG
  • S125E.VTWEG == TVTA.VTWEG
  • S125E.SPART == TVTA.SPART
  • S125E.MANDT == TVTA.MANDT
Sales organization in order header
  • S125E.MANDT == TVKO.MANDT
  • S125E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S125E.VKORG == TVKOV.VKORG
  • S125E.MANDT == TVKOV.MANDT
  • S125E.VTWEG == TVKOV.VTWEG
Plant
  • S125E.MANDT == T001W.MANDT
  • S125E.WERKS == T001W.WERKS