SAP ABAP Table S068 (Vendor statistics)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG02 (Package) QM quality information system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S068	Table Relationship Diagram
Short Description	Vendor statistics

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
9	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	ART	☑	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
11	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	BASME_QM	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
15	PROME	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
16	EHTAG	☐	QEINHTAG	MEINS	UNIT	3	0	Lead Time Unit (Day)	T006
17	ZHLSELECT	☐	QZHLSELECT	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots (Without Cancellation)
18	ZHLANGENS	☐	QZHLANGENS	QANZAHL4	INT4	10	0	Number of Accepted Inspection Lots (Including Skips)
19	ZHLRUECK	☐	QZHLRUECK	QANZAHL4	INT4	10	0	Number of Rejected Inspection Lots
20	ZHLSKIP	☐	QZHLSKIP	QANZAHL4	INT4	10	0	Number of Skipped Inspection Lots
21	ZHLABBR	☐	QZHLABBR	QANZAHL4	INT4	10	0	Number of Inspection Lots with Discontinued Inspections
22	ZHLOFFMK	☐	QZHLOFFMK	QANZAHL4	INT4	10	0	Number of Insp. Lots with Outstanding Long-Term Characs
23	SMGSELECT	☐	QSMGSELECT	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Summarized Inspection Lots
24	SMGANGENS	☐	QSMGANGENS	QKUMMENGE	QUAN	17	3	Accumulated Quantity of Accepted Inspection Lots (with Skip)
25	SMGRUECK	☐	QSMGRUECK	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Rejected Inspection Lots
26	SMGSKIP	☐	QSMGSKIP	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Skipped Inspection Lots
27	SMGGEPRFT	☐	QSMGGEPRFT	QKUMMENGE	QUAN	17	3	Cumulated Sample Quantity
28	SMGGEPRFTI	☐	QSMGGPRFTI	QKUMMENGE	QUAN	17	3	Cumulated Sample Quantity (Actual)
29	SMGDIFF	☐	QSMGDIFF	QKUMMENGE	QUAN	17	3	Accumulated Qty Difference Between Target Qty and Actual Qty
30	SMGZERSTR	☐	QSMGZERSTR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Destroyed During Inspection
31	SMGFREIBE	☐	QSMGFREIBE	QKUMMENGE	QUAN	17	3	Accumulated Qty that Was Posted to Unrestricted-Use Stock
32	SMGSCHRTT	☐	QSMGSCHRTT	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Scrap
33	SMGSTPR	☐	QSMGSTPR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Sample
34	SMGSPERR	☐	QSMGSPERR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Blocked Stock
35	SMGRUECKL	☐	QSMGRUECKL	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Reserves
36	SMGANDMAT	☐	QSMGANDMAT	QKUMMENGE	QUAN	17	3	Cumulated Quantity that Was Posted to Another Material
37	SMGRLIEF	☐	QSMGRLIEF	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted Back to the Vendor
38	QKZDEF	☐	QQKZDEF	QQKZDEF	CHAR	2	0	Definition of Quality Score Classes	TQ56
39	KLASSE_A	☐	QKLASSE_A	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class A
40	KLASSE_B	☐	QKLASSE_B	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class B
41	KLASSE_C	☐	QKLASSE_C	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class C
42	KLASSE_D	☐	QKLASSE_D	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class D
43	KLASSE_E	☐	QKLASSE_E	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class E
44	ZHLLOSQKZ	☐	QZHLLOSQKZ	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots for Quality Score
45	SUMQKZ	☐	QSUMQKZ	QSTATWERT	FLTP	16	16	Total of Quality Scores
46	SUM2QKZ	☐	QSUM2QKZ	QSTATWERT	FLTP	16	16	Square Total of Quality Score
47	ZHLLOSANTL	☐	QZHLLOSANT	QANZAHL4	INT4	10	0	Number of Summarized Lots (Including Share of Scrap)
48	SUMANTL	☐	QSUMANTL	QSTATWERT	FLTP	16	16	Total Share of Nonconforming Units
49	SUM2ANTL	☐	QSUM2ANTL	QSTATWERT	FLTP	16	16	Square Total of the Share of Nonconforming Units
50	ZHLLOSDR	☐	QZHLLOSDR	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots (Lead Time)
51	SUMDLZT	☐	QSUMDLZT	QSTATWERT	FLTP	16	16	Total Lead Time
52	SUM2DLZT	☐	QSUM2DLZT	QSTATWERT	FLTP	16	16	Square Total of Lead Time
53	SMGSCHL	☐	QSMGSCHL	QKUMMENGE	QUAN	17	3	Cumulated Inspected and Defective Quantity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S068	ART	TQ30	ART
2	S068	BASME_QM	T006	MSEHI
3	S068	EHTAG	T006	MSEHI
4	S068	LIFNR	LFA1	LIFNR
5	S068	MANDT	T000	MANDT
6	S068	MATNR	MARA	MATNR
7	S068	PROME	T006	MSEHI
8	S068	QKZDEF	TQ56	QKZDEF
9	S068	WERK	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in