S174E

S174 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
SRVPOS FK Activity Number
LIFNR FK Vendor's account number
MATKL FK Material Group
EKORG FK Purchasing organization
WERKS FK Plant
MEINS FK Base Unit of Measure
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
UBASME Conversion factor: quantities FLTP
UBSTWA Conversion factor: quantities FLTP
UHWAER 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
  • S174E.MANDT == T006.MANDT
  • S174E.BASME == T006.MSEHI
Purchase order currency
  • S174E.MANDT == TCURC.MANDT
  • S174E.BSTWA == TCURC.WAERS
Purchasing organization
  • S174E.MANDT == T024E.MANDT
  • S174E.EKORG == T024E.EKORG
Local Currency
  • S174E.MANDT == TCURC.MANDT
  • S174E.HWAER == TCURC.WAERS
Vendor's account number
  • S174E.MANDT == LFA1.MANDT
  • S174E.LIFNR == LFA1.LIFNR
Client S174E.MANDT == T000.MANDT
Material Group
  • S174E.MANDT == T023.MANDT
  • S174E.MATKL == T023.MATKL
Base Unit of Measure
  • S174E.MANDT == T006.MANDT
  • S174E.MEINS == T006.MSEHI
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S174E.PERIV == T009.PERIV
  • S174E.MANDT == T009.MANDT
Activity Number
  • S174E.MANDT == ASMD.MANDT
  • S174E.SRVPOS == ASMD.ASNUM
Plant
  • S174E.MANDT == T001W.MANDT
  • S174E.WERKS == T001W.WERKS