S068 - Vendor statistics
Vendor statistics information is stored in SAP table S068.
It is part of development package QG02 in software component QM-QC-IS. This development package consists of objects that can be grouped under "QM quality information system".
It is part of development package QG02 in software component QM-QC-IS. This development package consists of objects that can be grouped under "QM quality information system".
Fields for table S068
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 | |
LIFNR | Vendor's account number | X | ELIFN | CHAR | 20 | LFA1 |
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 | ||
SMGRLIEF | Cumulated Quantity Posted Back to Supplier | QSMGRLIEF | 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 |