SAP Table S068
Vendor statistics
S068 (Vendor statistics) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S068 to other SAP tables.
Source: S068 (Vendor statistics)
S068 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| ART | Inspection Type | QPART | TQ30 | CHAR | 8 | 0 | ||
| WERK | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| BASME_QM | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | T006 | UNIT | 3 | 0 | ||
| PROME | Base Unit of Measure for the Sample Unit | QPROBEMGEH | T006 | UNIT | 3 | 0 | ||
| EHTAG | Lead Time Unit (Day) | QEINHTAG | T006 | UNIT | 3 | 0 | ||
| ZHLSELECT | Number of Summarized Inspection Lots (Without Cancellation) | QZHLSELECT | INT4 | 10 | 0 | |||
| ZHLANGENS | Number of Accepted Inspection Lots (Including Skips) | QZHLANGENS | INT4 | 10 | 0 | |||
| ZHLRUECK | Number of Rejected Inspection Lots | QZHLRUECK | INT4 | 10 | 0 | |||
| ZHLSKIP | Number of Skipped Inspection Lots | QZHLSKIP | INT4 | 10 | 0 | |||
| ZHLABBR | Number of Inspection Lots with Discontinued Inspections | QZHLABBR | INT4 | 10 | 0 | |||
| ZHLOFFMK | Number of Insp. Lots with Outstanding Long-Term Characs | QZHLOFFMK | INT4 | 10 | 0 | |||
| SMGSELECT | Cumulated Quantity of Summarized Inspection Lots | QSMGSELECT | QUAN | 17 | 3 | |||
| SMGANGENS | Accumulated Quantity of Accepted Inspection Lots (with Skip) | QSMGANGENS | QUAN | 17 | 3 | |||
| SMGRUECK | Cumulated Quantity of Rejected Inspection Lots | QSMGRUECK | QUAN | 17 | 3 | |||
| SMGSKIP | Cumulated Quantity of Skipped Inspection Lots | QSMGSKIP | QUAN | 17 | 3 | |||
| SMGGEPRFT | Cumulated Sample Quantity | QSMGGEPRFT | QUAN | 17 | 3 | |||
| SMGGEPRFTI | Cumulated Sample Quantity (Actual) | QSMGGPRFTI | QUAN | 17 | 3 | |||
| SMGDIFF | Accumulated Qty Difference Between Target Qty and Actual Qty | QSMGDIFF | QUAN | 17 | 3 | |||
| SMGZERSTR | Cumulated Quantity Destroyed During Inspection | QSMGZERSTR | QUAN | 17 | 3 | |||
| SMGFREIBE | Accumulated Qty that Was Posted to Unrestricted-Use Stock | QSMGFREIBE | QUAN | 17 | 3 | |||
| SMGSCHRTT | Cumulated Quantity Posted to Scrap | QSMGSCHRTT | QUAN | 17 | 3 | |||
| SMGSTPR | Cumulated Quantity Posted to Sample | QSMGSTPR | QUAN | 17 | 3 | |||
| SMGSPERR | Cumulated Quantity Posted to Blocked Stock | QSMGSPERR | QUAN | 17 | 3 | |||
| SMGRUECKL | Cumulated Quantity Posted to Reserves | QSMGRUECKL | QUAN | 17 | 3 | |||
| SMGANDMAT | Cumulated Quantity that Was Posted to Another Material | QSMGANDMAT | QUAN | 17 | 3 | |||
| SMGRLIEF | Cumulated Quantity Posted Back to the Vendor | QSMGRLIEF | QUAN | 17 | 3 | |||
| QKZDEF | Definition of Quality Score Classes | QQKZDEF | TQ56 | CHAR | 2 | 0 | ||
| KLASSE_A | Absolute Frequency of Quality Score Class A | QKLASSE_A | INT4 | 10 | 0 | |||
| KLASSE_B | Absolute Frequency of Quality Score Class B | QKLASSE_B | INT4 | 10 | 0 | |||
| KLASSE_C | Absolute Frequency of Quality Score Class C | QKLASSE_C | INT4 | 10 | 0 | |||
| KLASSE_D | Absolute Frequency of Quality Score Class D | QKLASSE_D | INT4 | 10 | 0 | |||
| KLASSE_E | Absolute Frequency of Quality Score Class E | QKLASSE_E | INT4 | 10 | 0 | |||
| ZHLLOSQKZ | Number of Summarized Inspection Lots for Quality Score | QZHLLOSQKZ | INT4 | 10 | 0 | |||
| SUMQKZ | Total of Quality Scores | QSUMQKZ | FLTP | 16 | 16 | |||
| SUM2QKZ | Square Total of Quality Score | QSUM2QKZ | FLTP | 16 | 16 | |||
| ZHLLOSANTL | Number of Summarized Lots (Including Share of Scrap) | QZHLLOSANT | INT4 | 10 | 0 | |||
| SUMANTL | Total Share of Nonconforming Units | QSUMANTL | FLTP | 16 | 16 | |||
| SUM2ANTL | Square Total of the Share of Nonconforming Units | QSUM2ANTL | FLTP | 16 | 16 | |||
| ZHLLOSDR | Number of Summarized Inspection Lots (Lead Time) | QZHLLOSDR | INT4 | 10 | 0 | |||
| SUMDLZT | Total Lead Time | QSUMDLZT | FLTP | 16 | 16 | |||
| SUM2DLZT | Square Total of Lead Time | QSUM2DLZT | FLTP | 16 | 16 | |||
| SMGSCHL | Cumulated Inspected and Defective Quantity | QSMGSCHL | QUAN | 17 | 3 | |||
S068 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S068 | ART | S068 | MANDT | TQ30 | Inspection types | MANDT |
| S068 | ART | S068 | ART | TQ30 | Inspection types | ART |
| S068 | BASME_QM | S068 | MANDT | T006 | Units of Measurement | MANDT |
| S068 | BASME_QM | S068 | BASME_QM | T006 | Units of Measurement | MSEHI |
| S068 | EHTAG | S068 | EHTAG | T006 | Units of Measurement | MSEHI |
| S068 | EHTAG | S068 | MANDT | T006 | Units of Measurement | MANDT |
| S068 | LIFNR | S068 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| S068 | LIFNR | S068 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| S068 | MANDT | S068 | MANDT | T000 | Clients | MANDT |
| S068 | MATNR | S068 | MANDT | MARA | General Material Data | MANDT |
| S068 | MATNR | S068 | MATNR | MARA | General Material Data | MATNR |
| S068 | PROME | S068 | PROME | T006 | Units of Measurement | MSEHI |
| S068 | PROME | S068 | MANDT | T006 | Units of Measurement | MANDT |
| S068 | QKZDEF | S068 | QKZDEF | TQ56 | Definition of quality score classes | QKZDEF |
| S068 | QKZDEF | S068 | MANDT | TQ56 | Definition of quality score classes | MANDT |
| S068 | WERK | S068 | WERK | T001W | Plants/Branches | WERKS |
| S068 | WERK | S068 | MANDT | T001W | Plants/Branches | MANDT |
