S069

Material Statistics | #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
ART FK Inspection Type
WERK FK Plant
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (BASME_QM):
SMGSELECT Cumulated Quantity of Summarized Inspection Lots
SMGANGENS Accumulated Quantity of Accepted Inspection Lots (with Skip)
SMGRUECK Cumulated Quantity of Rejected Inspection Lots
SMGSKIP Cumulated Quantity of Skipped Inspection Lots
SMGDIFF Accumulated Qty Difference Between Target Qty and Actual Qty
SMGFREIBE Accumulated Qty that Was Posted to Unrestricted-Use Stock
SMGSCHRTT Cumulated Quantity Posted to Scrap
SMGSTPR Cumulated Quantity Posted to Sample
SMGSPERR Cumulated Quantity Posted to Blocked Stock
SMGRUECKL Cumulated Quantity Posted to Reserves
SMGANDMAT Cumulated Quantity that Was Posted to Another Material
SMGSCHL Cumulated Inspected and Defective Quantity
📏 Base Unit of Measure for Sample Unit (PROME):
SMGGEPRFT Cumulated Sample Quantity
SMGGEPRFTI Cumulated Sample Quantity (Actual)
SMGZERSTR Cumulated Quantity Destroyed During Inspection
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
ZHLSELECT Number of Summarized Inspection Lots (Without Cancellation) QANZAHL4
ZHLANGENS Number of Accepted Inspection Lots (Including Skips) QANZAHL4
ZHLRUECK Number of Rejected Inspection Lots QANZAHL4
ZHLSKIP Number of Skipped Inspection Lots QANZAHL4
ZHLABBR Number of Inspection Lots with Discontinued Inspections QANZAHL4
ZHLOFFMK Number of Insp. Lots with Outstanding Long-Term Characs QANZAHL4
KLASSE_A Absolute Frequency of Quality Score Class A QANZAHL4
KLASSE_B Absolute Frequency of Quality Score Class B QANZAHL4
KLASSE_C Absolute Frequency of Quality Score Class C QANZAHL4
KLASSE_D Absolute Frequency of Quality Score Class D QANZAHL4
KLASSE_E Absolute Frequency of Quality Score Class E QANZAHL4
ZHLLOSQKZ Number of Summarized Inspection Lots for Quality Score QANZAHL4
SUMQKZ Total of Quality Scores QSTATWERT
SUM2QKZ Square Total of Quality Score QSTATWERT
ZHLLOSANTL Number of Summarized Lots (Including Share of Scrap) QANZAHL4
SUMANTL Total Share of Nonconforming Units QSTATWERT
SUM2ANTL Square Total of the Share of Nonconforming Units QSTATWERT
ZHLLOSDR Number of Summarized Inspection Lots (Lead Time) QANZAHL4
SUMDLZT Total Lead Time QSTATWERT
SUM2DLZT Square Total of Lead Time QSTATWERT
Master Data Relations Join Conditions
Inspection Type
  • S069.MANDT == TQ30.MANDT
  • S069.ART == TQ30.ART
Base Unit of Measure for Inspection Lot Quantity
  • S069.MANDT == T006.MANDT
  • S069.BASME_QM == T006.MSEHI
Lead Time Unit (Day)
  • S069.MANDT == T006.MANDT
  • S069.EHTAG == T006.MSEHI
Client S069.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S069.MATNR == MARA.MATNR
  • S069.MANDT == MARA.MANDT
Base Unit of Measure for Sample Unit
  • S069.MANDT == T006.MANDT
  • S069.PROME == T006.MSEHI
Definition of Quality Score Classes
  • Definition of Quality Score Classes
  • Client
  • S069.QKZDEF == TQ56.QKZDEF
  • S069.MANDT == TQ56.MANDT
Plant
  • S069.MANDT == T001W.MANDT
  • S069.WERK == T001W.WERKS