S006E

S006 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRTNR Sales employee
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
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
  • S006E.MANDT == T006.MANDT
  • S006E.BASME == T006.MSEHI
Sold-to Party
  • S006E.MANDT == KNA1.MANDT
  • S006E.KUNNR == KNA1.KUNNR
Client S006E.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S006E.MATNR == MARA.MATNR
  • S006E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S006E.PERIV == T009.PERIV
  • S006E.MANDT == T009.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S006E.VKORG == TVTA.VKORG
  • S006E.VTWEG == TVTA.VTWEG
  • S006E.SPART == TVTA.SPART
  • S006E.MANDT == TVTA.MANDT
Statistics Currency
  • S006E.MANDT == TCURC.MANDT
  • S006E.STWAE == TCURC.WAERS
Sales organization in order header
  • S006E.MANDT == TVKO.MANDT
  • S006E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S006E.VKORG == TVKOV.VKORG
  • S006E.MANDT == TVKOV.MANDT
  • S006E.VTWEG == TVKOV.VTWEG