SAP Table S069
Material Statistics (QM)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S069 (Material Statistics (QM)) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S069 |
| Short Text | Material Statistics (QM) |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S069
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| ART | ✔ | Inspection Type | QPART | CHAR | 8 | TQ30 |
| WERK | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME_QM | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | UNIT | 3 | T006 | |
| PROME | Base Unit of Measure for the Sample Unit | QPROBEMGEH | UNIT | 3 | T006 | |
| EHTAG | Lead Time Unit (Day) | QEINHTAG | UNIT | 3 | T006 | |
| ZHLSELECT | Number of Summarized Inspection Lots (Without Cancellation) | QZHLSELECT | INT4 | 10 | ||
| ZHLANGENS | Number of Accepted Inspection Lots (Including Skips) | QZHLANGENS | INT4 | 10 | ||
| ZHLRUECK | Number of Rejected Inspection Lots | QZHLRUECK | INT4 | 10 | ||
| ZHLSKIP | Number of Skipped Inspection Lots | QZHLSKIP | INT4 | 10 | ||
| ZHLABBR | Number of Inspection Lots with Discontinued Inspections | QZHLABBR | INT4 | 10 | ||
| ZHLOFFMK | Number of Insp. Lots with Outstanding Long-Term Characs | QZHLOFFMK | INT4 | 10 | ||
| SMGSELECT | Cumulated Quantity of Summarized Inspection Lots | QSMGSELECT | QUAN | 17 | ||
| SMGANGENS | Accumulated Quantity of Accepted Inspection Lots (with Skip) | QSMGANGENS | QUAN | 17 | ||
| SMGRUECK | Cumulated Quantity of Rejected Inspection Lots | QSMGRUECK | QUAN | 17 | ||
| SMGSKIP | Cumulated Quantity of Skipped Inspection Lots | QSMGSKIP | QUAN | 17 | ||
| SMGGEPRFT | Cumulated Sample Quantity | QSMGGEPRFT | QUAN | 17 | ||
| SMGGEPRFTI | Cumulated Sample Quantity (Actual) | QSMGGPRFTI | QUAN | 17 | ||
| SMGDIFF | Accumulated Qty Difference Between Target Qty and Actual Qty | QSMGDIFF | QUAN | 17 | ||
| SMGZERSTR | Cumulated Quantity Destroyed During Inspection | QSMGZERSTR | QUAN | 17 | ||
| SMGFREIBE | Accumulated Qty that Was Posted to Unrestricted-Use Stock | QSMGFREIBE | QUAN | 17 | ||
| SMGSCHRTT | Cumulated Quantity Posted to Scrap | QSMGSCHRTT | QUAN | 17 | ||
| SMGSTPR | Cumulated Quantity Posted to Sample | QSMGSTPR | QUAN | 17 | ||
| SMGSPERR | Cumulated Quantity Posted to Blocked Stock | QSMGSPERR | QUAN | 17 | ||
| SMGRUECKL | Cumulated Quantity Posted to Reserves | QSMGRUECKL | QUAN | 17 | ||
| SMGANDMAT | Cumulated Quantity that Was Posted to Another Material | QSMGANDMAT | QUAN | 17 | ||
| QKZDEF | Definition of Quality Score Classes | QQKZDEF | CHAR | 2 | TQ56 | |
| KLASSE_A | Absolute Frequency of Quality Score Class A | QKLASSE_A | INT4 | 10 | ||
| KLASSE_B | Absolute Frequency of Quality Score Class B | QKLASSE_B | INT4 | 10 | ||
| KLASSE_C | Absolute Frequency of Quality Score Class C | QKLASSE_C | INT4 | 10 | ||
| KLASSE_D | Absolute Frequency of Quality Score Class D | QKLASSE_D | INT4 | 10 | ||
| KLASSE_E | Absolute Frequency of Quality Score Class E | QKLASSE_E | INT4 | 10 | ||
| ZHLLOSQKZ | Number of Summarized Inspection Lots for Quality Score | QZHLLOSQKZ | INT4 | 10 | ||
| SUMQKZ | Total of Quality Scores | QSUMQKZ | FLTP | 16 | ||
| SUM2QKZ | Square Total of Quality Score | QSUM2QKZ | FLTP | 16 | ||
| ZHLLOSANTL | Number of Summarized Lots (Including Share of Scrap) | QZHLLOSANT | INT4 | 10 | ||
| SUMANTL | Total Share of Nonconforming Units | QSUMANTL | FLTP | 16 | ||
| SUM2ANTL | Square Total of the Share of Nonconforming Units | QSUM2ANTL | FLTP | 16 | ||
| ZHLLOSDR | Number of Summarized Inspection Lots (Lead Time) | QZHLLOSDR | INT4 | 10 | ||
| SUMDLZT | Total Lead Time | QSUMDLZT | FLTP | 16 | ||
| SUM2DLZT | Square Total of Lead Time | QSUM2DLZT | FLTP | 16 | ||
| SMGSCHL | Cumulated Inspected and Defective Quantity | QSMGSCHL | QUAN | 17 |