S128E

S128 - Structural information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
KLART FK Class Type
MATNR FK Material Number
ATINN Internal characteristic
ATWRT Characteristic Value
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNNR FK Sold-to Party
WERKS FK Plant
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 Factor (%) for disaggregation of planning level quantity CHAR10
Master Data Relations Join Conditions
Base Unit of Measure
  • S128E.MANDT == T006.MANDT
  • S128E.BASME == T006.MSEHI
Class Type
  • S128E.MANDT == TCLA.MANDT
  • S128E.KLART == TCLA.KLART
Sold-to Party
  • S128E.MANDT == KNA1.MANDT
  • S128E.KUNNR == KNA1.KUNNR
Client S128E.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S128E.MATNR == MARA.MATNR
  • S128E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S128E.PERIV == T009.PERIV
  • S128E.MANDT == T009.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S128E.VKORG == TVTA.VKORG
  • S128E.VTWEG == TVTA.VTWEG
  • S128E.SPART == TVTA.SPART
  • S128E.MANDT == TVTA.MANDT
Statistics Currency
  • S128E.MANDT == TCURC.MANDT
  • S128E.STWAE == TCURC.WAERS
Sales organization in order header
  • S128E.MANDT == TVKO.MANDT
  • S128E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S128E.VKORG == TVKOV.VKORG
  • S128E.MANDT == TVKOV.MANDT
  • S128E.VTWEG == TVKOV.VTWEG
Plant
  • S128E.MANDT == T001W.MANDT
  • S128E.WERKS == T001W.WERKS