S171E

S171 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
EKORG FK Purchasing organization
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
MATKL FK Material Group
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
  • S171E.MANDT == T001.MANDT
  • S171E.BUKRS == T001.BUKRS
Purchasing organization
  • S171E.MANDT == T024E.MANDT
  • S171E.EKORG == T024E.EKORG
Payer
  • S171E.MANDT == KNA1.MANDT
  • S171E.KUNRG == KNA1.KUNNR
Payee
  • S171E.MANDT == LFA1.MANDT
  • S171E.LNRZB == LFA1.LIFNR
Client S171E.MANDT == T000.MANDT
Material Group
  • S171E.MANDT == T023.MANDT
  • S171E.MATKL == T023.MATKL
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S171E.PERIV == T009.PERIV
  • S171E.MANDT == T009.MANDT
Division
  • S171E.MANDT == TSPA.MANDT
  • S171E.SPART == TSPA.SPART
Sales Organization
  • S171E.MANDT == TVKO.MANDT
  • S171E.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S171E.VTWEG == TVTW.VTWEG
  • S171E.MANDT == TVTW.MANDT
Statistics Currency
  • S171E.MANDT == TCURC.MANDT
  • S171E.WSTWAE == TCURC.WAERS