S116E

S116 - Structural information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
IWERK FK Maintenance Planning Plant
QMART FK Notification Type
KUNUM FK Customer Number
TPLNR FK Functional Location
EQUNR FK Equipment Number
BAUTL FK Assembly
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
USUNIT Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Factor (%) for disaggregation of planning level quantity CHAR10
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • S116E.BAUTL == MARA.MATNR
  • S116E.MANDT == MARA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • S116E.EQUNR == EQUI.EQUNR
  • S116E.MANDT == EQUI.MANDT
Customer Number
  • S116E.MANDT == KNA1.MANDT
  • S116E.KUNUM == KNA1.KUNNR
Client S116E.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S116E.PERIV == T009.PERIV
  • S116E.MANDT == T009.MANDT
Notification Type
  • S116E.MANDT == TQ80.MANDT
  • S116E.QMART == TQ80.QMART
Division
  • S116E.MANDT == TSPA.MANDT
  • S116E.SPART == TSPA.SPART
Unit for Breakdown Duration
  • S116E.MANDT == T006.MANDT
  • S116E.SUNIT == T006.MSEHI
Functional Location
  • S116E.MANDT == IFLOT.MANDT
  • S116E.TPLNR == IFLOT.TPLNR
Sales Organization
  • S116E.MANDT == TVKO.MANDT
  • S116E.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S116E.VTWEG == TVTW.VTWEG
  • S116E.MANDT == TVTW.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • S116E.IWERK == T399I.IWERK
  • S116E.MANDT == T399I.MANDT