S003E

S003 - 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
BZIRK FK Sales District
KUNNR FK Sold-to Party
MATNR FK Material Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
USTWAE Conversion factor: quantities FLTP
UBASME 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
  • S003E.MANDT == T006.MANDT
  • S003E.BASME == T006.MSEHI
Sales District
  • S003E.MANDT == T171.MANDT
  • S003E.BZIRK == T171.BZIRK
Sold-to Party
  • S003E.MANDT == KNA1.MANDT
  • S003E.KUNNR == KNA1.KUNNR
Client S003E.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S003E.MATNR == MARA.MATNR
  • S003E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S003E.PERIV == T009.PERIV
  • S003E.MANDT == T009.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S003E.VKORG == TVTA.VKORG
  • S003E.VTWEG == TVTA.VTWEG
  • S003E.SPART == TVTA.SPART
  • S003E.MANDT == TVTA.MANDT
Statistics Currency
  • S003E.MANDT == TCURC.MANDT
  • S003E.STWAE == TCURC.WAERS
Sales organization in order header
  • S003E.MANDT == TVKO.MANDT
  • S003E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S003E.VKORG == TVKOV.VKORG
  • S003E.MANDT == TVKOV.MANDT
  • S003E.VTWEG == TVKOV.VTWEG