S138E

S138 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
WERKS FK Plant
KUNNR FK Sold-to Party
MATNR FK Material Number
CLINT Characteristics combination
LNPOS Combination value key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
UBASME Conversion factor: quantities FLTP
USTWAE Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Base Unit of Measure
  • S138E.MANDT == T006.MANDT
  • S138E.BASME == T006.MSEHI
Sold-to Party
  • S138E.MANDT == KNA1.MANDT
  • S138E.KUNNR == KNA1.KUNNR
Client S138E.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S138E.MATNR == MARA.MATNR
  • S138E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S138E.PERIV == T009.PERIV
  • S138E.MANDT == T009.MANDT
Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S138E.VKORG == TVTA.VKORG
  • S138E.VTWEG == TVTA.VTWEG
  • S138E.SPART == TVTA.SPART
  • S138E.MANDT == TVTA.MANDT
Statistics Currency
  • S138E.MANDT == TCURC.MANDT
  • S138E.STWAE == TCURC.WAERS
Sales Organization
  • S138E.MANDT == TVKO.MANDT
  • S138E.VKORG == TVKO.VKORG
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • S138E.VKORG == TVKOV.VKORG
  • S138E.MANDT == TVKOV.MANDT
  • S138E.VTWEG == TVKOV.VTWEG
Plant
  • S138E.MANDT == T001W.MANDT
  • S138E.WERKS == T001W.WERKS