SAP ABAP Table S069 (Material Statistics)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S069	Table Relationship Diagram
Short Description	Material 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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	ART	☑	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
10	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	BASME_QM	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
14	PROME	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
15	EHTAG	☐	QEINHTAG	MEINS	UNIT	3	0	Lead Time Unit (Day)	T006
16	ZHLSELECT	☐	QZHLSELECT	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots (Without Cancellation)
17	ZHLANGENS	☐	QZHLANGENS	QANZAHL4	INT4	10	0	Number of Accepted Inspection Lots (Including Skips)
18	ZHLRUECK	☐	QZHLRUECK	QANZAHL4	INT4	10	0	Number of Rejected Inspection Lots
19	ZHLSKIP	☐	QZHLSKIP	QANZAHL4	INT4	10	0	Number of Skipped Inspection Lots
20	ZHLABBR	☐	QZHLABBR	QANZAHL4	INT4	10	0	Number of Inspection Lots with Discontinued Inspections
21	ZHLOFFMK	☐	QZHLOFFMK	QANZAHL4	INT4	10	0	Number of Insp. Lots with Outstanding Long-Term Characs
22	SMGSELECT	☐	QSMGSELECT	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Summarized Inspection Lots
23	SMGANGENS	☐	QSMGANGENS	QKUMMENGE	QUAN	17	3	Accumulated Quantity of Accepted Inspection Lots (with Skip)
24	SMGRUECK	☐	QSMGRUECK	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Rejected Inspection Lots
25	SMGSKIP	☐	QSMGSKIP	QKUMMENGE	QUAN	17	3	Cumulated Quantity of Skipped Inspection Lots
26	SMGGEPRFT	☐	QSMGGEPRFT	QKUMMENGE	QUAN	17	3	Cumulated Sample Quantity
27	SMGGEPRFTI	☐	QSMGGPRFTI	QKUMMENGE	QUAN	17	3	Cumulated Sample Quantity (Actual)
28	SMGDIFF	☐	QSMGDIFF	QKUMMENGE	QUAN	17	3	Accumulated Qty Difference Between Target Qty and Actual Qty
29	SMGZERSTR	☐	QSMGZERSTR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Destroyed During Inspection
30	SMGFREIBE	☐	QSMGFREIBE	QKUMMENGE	QUAN	17	3	Accumulated Qty that Was Posted to Unrestricted-Use Stock
31	SMGSCHRTT	☐	QSMGSCHRTT	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Scrap
32	SMGSTPR	☐	QSMGSTPR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Sample
33	SMGSPERR	☐	QSMGSPERR	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Blocked Stock
34	SMGRUECKL	☐	QSMGRUECKL	QKUMMENGE	QUAN	17	3	Cumulated Quantity Posted to Reserves
35	SMGANDMAT	☐	QSMGANDMAT	QKUMMENGE	QUAN	17	3	Cumulated Quantity that Was Posted to Another Material
36	QKZDEF	☐	QQKZDEF	QQKZDEF	CHAR	2	0	Definition of Quality Score Classes	TQ56
37	KLASSE_A	☐	QKLASSE_A	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class A
38	KLASSE_B	☐	QKLASSE_B	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class B
39	KLASSE_C	☐	QKLASSE_C	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class C
40	KLASSE_D	☐	QKLASSE_D	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class D
41	KLASSE_E	☐	QKLASSE_E	QANZAHL4	INT4	10	0	Absolute Frequency of Quality Score Class E
42	ZHLLOSQKZ	☐	QZHLLOSQKZ	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots for Quality Score
43	SUMQKZ	☐	QSUMQKZ	QSTATWERT	FLTP	16	16	Total of Quality Scores
44	SUM2QKZ	☐	QSUM2QKZ	QSTATWERT	FLTP	16	16	Square Total of Quality Score
45	ZHLLOSANTL	☐	QZHLLOSANT	QANZAHL4	INT4	10	0	Number of Summarized Lots (Including Share of Scrap)
46	SUMANTL	☐	QSUMANTL	QSTATWERT	FLTP	16	16	Total Share of Nonconforming Units
47	SUM2ANTL	☐	QSUM2ANTL	QSTATWERT	FLTP	16	16	Square Total of the Share of Nonconforming Units
48	ZHLLOSDR	☐	QZHLLOSDR	QANZAHL4	INT4	10	0	Number of Summarized Inspection Lots (Lead Time)
49	SUMDLZT	☐	QSUMDLZT	QSTATWERT	FLTP	16	16	Total Lead Time
50	SUM2DLZT	☐	QSUM2DLZT	QSTATWERT	FLTP	16	16	Square Total of Lead Time
51	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	S069	ART	TQ30	ART
2	S069	BASME_QM	T006	MSEHI
3	S069	EHTAG	T006	MSEHI
4	S069	MANDT	T000	MANDT
5	S069	MATNR	MARA	MATNR
6	S069	PROME	T006	MSEHI
7	S069	QKZDEF	TQ56	QKZDEF
8	S069	WERK	T001W	WERKS

History

Last changed by/on	SAP	20040210
SAP Release Created in