S120E

S120 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
WERKS FK Plant
KSKRS POS controller
KASNR POS number
BONNR Transaction number (till receipt)
MATNR FK Material Number
EANNR International Article Number (EAN/UPC)
KSCHL FK Condition type, sales
KVORG FK Transact. type
CONDNR Consecutive condition number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
UVRKME Conversion factor: quantities FLTP
UBASME Conversion factor: quantities FLTP
UWAERK 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
  • S120E.MANDT == T006.MANDT
  • S120E.BASME == T006.MSEHI
Condition type, sales
  • Condition type, sales
  • Client
  • ?
  • ?
  • S120E.KSCHL == T685.KSCHL
  • S120E.MANDT == T685.MANDT
  • S120E.[column in domain "KVEWE"] == T685.KVEWE
  • S120E.[column in domain "KAPPL"] == T685.KAPPL
Transact. type
  • S120E.MANDT == TWPPB.MANDT
  • S120E.KVORG == TWPPB.UVORG
Client S120E.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S120E.MATNR == MARA.MATNR
  • S120E.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S120E.PERIV == T009.PERIV
  • S120E.MANDT == T009.MANDT
Sales unit
  • S120E.MANDT == T006.MANDT
  • S120E.VRKME == T006.MSEHI
SD Document Currency
  • S120E.MANDT == TCURC.MANDT
  • S120E.WAERK == TCURC.WAERS
Plant
  • S120E.MANDT == T001W.MANDT
  • S120E.WERKS == T001W.WERKS