S116

Customer Analysis | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
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
📏 Unit for Breakdown Duration (SUNIT):
SGAUSZT Downtime entered
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
SMOFN No.of recorded notifications MCZAEHLER
SMMAB No. of completed notifications MCZAEHLER
SABTG No. processing days creation to completion MCZAEHLER
SGMSAUS Number of machine breakdowns reported MCZAEHLER
SSCODE PMIS: No.of damages MCZAEHLER
SACODE PMIS: number of activity codes MCZAEHLER
SUCODE PMIS: No. of cause of damage codes MCZAEHLER
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • S116.BAUTL == MARA.MATNR
  • S116.MANDT == MARA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • S116.EQUNR == EQUI.EQUNR
  • S116.MANDT == EQUI.MANDT
Customer Number
  • S116.MANDT == KNA1.MANDT
  • S116.KUNUM == KNA1.KUNNR
Client S116.MANDT == T000.MANDT
Notification Type
  • S116.MANDT == TQ80.MANDT
  • S116.QMART == TQ80.QMART
Division
  • S116.MANDT == TSPA.MANDT
  • S116.SPART == TSPA.SPART
Unit for Breakdown Duration
  • S116.MANDT == T006.MANDT
  • S116.SUNIT == T006.MSEHI
Functional Location
  • S116.MANDT == IFLOT.MANDT
  • S116.TPLNR == IFLOT.TPLNR
Sales Organization
  • S116.MANDT == TVKO.MANDT
  • S116.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S116.VTWEG == TVTW.VTWEG
  • S116.MANDT == TVTW.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • S116.IWERK == T399I.IWERK
  • S116.MANDT == T399I.MANDT