S002E

S002 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VKORG FK Sales Organization
VKGRP FK Sales group
VKBUR FK Sales office
VTWEG FK Distribution Channel
SPART FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
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
Client S002E.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S002E.PERIV == T009.PERIV
  • S002E.MANDT == T009.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S002E.VKORG == TVTA.VKORG
  • S002E.VTWEG == TVTA.VTWEG
  • S002E.SPART == TVTA.SPART
  • S002E.MANDT == TVTA.MANDT
Statistics Currency
  • S002E.MANDT == TCURC.MANDT
  • S002E.STWAE == TCURC.WAERS
Sales group
  • Sales group
  • Sales office
  • S002E.MANDT == TVBVK.MANDT
  • S002E.VKGRP == TVBVK.VKGRP
  • S002E.VKBUR == TVBVK.VKBUR
Sales organization in order header
  • S002E.MANDT == TVKO.MANDT
  • S002E.VKORG == TVKO.VKORG
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • S002E.VKORG == TVKOV.VKORG
  • S002E.MANDT == TVKOV.MANDT
  • S002E.VTWEG == TVKOV.VTWEG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • S002E.VKORG == TVKBZ.VKORG
  • S002E.MANDT == TVKBZ.MANDT
  • S002E.VTWEG == TVKBZ.VTWEG
  • S002E.SPART == TVKBZ.SPART
  • S002E.VKBUR == TVKBZ.VKBUR