S170E

S170 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
EKORG FK Purchasing organization
EKGRP FK Purchasing Group
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
BUKRS FK Company Code
LNRZB FK Payee
KUNRG FK Payer
LFTYP Settlement Document Category Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
LFTYP Settlement Document Category Show values
Column Name Description Domain name
UWSTWAE 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
Company Code
  • S170E.MANDT == T001.MANDT
  • S170E.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • S170E.EKGRP == T024.EKGRP
  • S170E.MANDT == T024.MANDT
Purchasing organization
  • S170E.MANDT == T024E.MANDT
  • S170E.EKORG == T024E.EKORG
Payer
  • S170E.MANDT == KNA1.MANDT
  • S170E.KUNRG == KNA1.KUNNR
Payee
  • S170E.MANDT == LFA1.MANDT
  • S170E.LNRZB == LFA1.LIFNR
Client S170E.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S170E.PERIV == T009.PERIV
  • S170E.MANDT == T009.MANDT
Division
  • S170E.MANDT == TSPA.MANDT
  • S170E.SPART == TSPA.SPART
Sales Organization
  • S170E.MANDT == TVKO.MANDT
  • S170E.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S170E.VTWEG == TVTW.VTWEG
  • S170E.MANDT == TVTW.MANDT
Statistics Currency
  • S170E.MANDT == TCURC.MANDT
  • S170E.WSTWAE == TCURC.WAERS