S100

Problems: Material 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
MATNR FK Material Number
QMART FK Notification Type
QMISKEYGRP Combination of Catalog Type and Code Group for Problem
QFECOD Problem Code
FEART FK Report Type for Defects Recording
MAWERK FK Plant for Material
Column Name Description
Column Name Description
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
ZHLPROBL Problem Frequency INT4
ZHLPROPOS No. of Problem Items INT4
SUMFBEW Total of Defect Valuations QSTATWERT
Master Data Relations Join Conditions
Report Type for Defects Recording
  • S100.MANDT == TQ86.MANDT
  • S100.FEART == TQ86.FEART
Client S100.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S100.MATNR == MARA.MATNR
  • S100.MANDT == MARA.MANDT
Plant for Material
  • S100.MANDT == T001W.MANDT
  • S100.MAWERK == T001W.WERKS
Notification Type
  • S100.MANDT == TQ80.MANDT
  • S100.QMART == TQ80.QMART