S069 - Material Statistics
Material Statistics information is stored in SAP table S069.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S069
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| ART | Inspection Type | X | QPART | CHAR | 16 | TQ30 |
| WERK | Plant | X | WERKS_D | CHAR | 8 | T001W |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| BASME_QM | Base Unit of Measure for Inspection Lot Quantity | QLOSMENGEH | UNIT | 6 | T006 | |
| PROME | Base Unit of Measure for Sample Unit | QPROBEMGEH | UNIT | 6 | T006 | |
| EHTAG | Lead Time Unit (Day) | QEINHTAG | UNIT | 6 | T006 | |
| SMGSELECT | Cumulated Quantity of Summarized Inspection Lots | QSMGSELECT | QUAN | 9 | ||
| SMGANGENS | Accumulated Quantity of Accepted Inspection Lots (with Skip) | QSMGANGENS | QUAN | 9 | ||
| SMGRUECK | Cumulated Quantity of Rejected Inspection Lots | QSMGRUECK | QUAN | 9 | ||
| SMGSKIP | Cumulated Quantity of Skipped Inspection Lots | QSMGSKIP | QUAN | 9 | ||
| SMGGEPRFT | Cumulated Sample Quantity | QSMGGEPRFT | QUAN | 9 | ||
| SMGGEPRFTI | Cumulated Sample Quantity (Actual) | QSMGGPRFTI | QUAN | 9 | ||
| SMGDIFF | Accumulated Qty Difference Between Target Qty and Actual Qty | QSMGDIFF | QUAN | 9 | ||
| SMGZERSTR | Cumulated Quantity Destroyed During Inspection | QSMGZERSTR | QUAN | 9 | ||
| SMGFREIBE | Accumulated Qty that Was Posted to Unrestricted-Use Stock | QSMGFREIBE | QUAN | 9 | ||
| SMGSCHRTT | Cumulated Quantity Posted to Scrap | QSMGSCHRTT | QUAN | 9 | ||
| SMGSTPR | Cumulated Quantity Posted to Sample | QSMGSTPR | QUAN | 9 | ||
| SMGSPERR | Cumulated Quantity Posted to Blocked Stock | QSMGSPERR | QUAN | 9 | ||
| SMGRUECKL | Cumulated Quantity Posted to Reserves | QSMGRUECKL | QUAN | 9 | ||
| SMGANDMAT | Cumulated Quantity that Was Posted to Another Material | QSMGANDMAT | QUAN | 9 | ||
| QKZDEF | Definition of Quality Score Classes | QQKZDEF | CHAR | 4 | TQ56 | |
| KLASSE_A | Absolute Frequency of Quality Score Class A | QKLASSE_A | INT4 | 4 | ||
| KLASSE_B | Absolute Frequency of Quality Score Class B | QKLASSE_B | INT4 | 4 | ||
| KLASSE_C | Absolute Frequency of Quality Score Class C | QKLASSE_C | INT4 | 4 | ||
| KLASSE_D | Absolute Frequency of Quality Score Class D | QKLASSE_D | INT4 | 4 | ||
| KLASSE_E | Absolute Frequency of Quality Score Class E | QKLASSE_E | INT4 | 4 | ||
| SUMQKZ | Total of Quality Scores | QSUMQKZ | FLTP | 8 | ||
| SUM2QKZ | Square Total of Quality Score | QSUM2QKZ | FLTP | 8 | ||
| SUMANTL | Total Share of Nonconforming Units | QSUMANTL | FLTP | 8 | ||
| SUM2ANTL | Square Total of the Share of Nonconforming Units | QSUM2ANTL | FLTP | 8 | ||
| SUMDLZT | Total Lead Time | QSUMDLZT | FLTP | 8 | ||
| SUM2DLZT | Square Total of Lead Time | QSUM2DLZT | FLTP | 8 | ||
| SMGSCHL | Cumulated Inspected and Defective Quantity | QSMGSCHL | QUAN | 9 |