S097

QM notifications: 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
MAWERK FK Plant for Material
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
SMMGEIG Total Defective Quantity (Internal)
SMMGFRD Total Defective Quantity (External)
SMRKMNG Total Complaint Quantity
SMRGMNG Total Quantity Returned
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
ZHLMELD No. of Notifications INT4
ZHLMOFN No. of Notifications with Status Outstanding INT4
ZHLMIAR No. of Notifications with Status Being Processed INT4
ZHLMMAB No. of Notifications with Status Completed INT4
ZHLMRST No. of Notifications with Stauts Reset INT4
ZHLMAOF Number of Tasks with Status 'Outstanding' or 'Released' INT4
ZHLMASS No. of Tasks INT4
ZHLMAER No. of Tasks with Status Completed INT4
ZHLMERF No. of Tasks with Status Successful INT4
Master Data Relations Join Conditions
Client S097.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S097.MATNR == MARA.MATNR
  • S097.MANDT == MARA.MANDT
Plant for Material
  • S097.MANDT == T001W.MANDT
  • S097.MAWERK == T001W.WERKS
Notification Type
  • S097.MANDT == TQ80.MANDT
  • S097.QMART == TQ80.QMART