SAP ABAP Table QGEVAL_INSPECTION_LOTS (Aggregate Structure for Inspections with Inspection Lots)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ QM-QC-AQC (Application Component) Active Quality Control
     ⤷ QG_EVAL (Package) QM: Online Evaluations

Basic Data

Table Category	INTTAB	Structure
Structure	QGEVAL_INSPECTION_LOTS	Table Relationship Diagram
Short Description	Aggregate Structure for Inspections with Inspection Lots

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Compulsory Key(s) for Aggregate Structure
2	NODE_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
3	RELAT_NODE_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
4	STRUC	☐	QG_EVAL_TREE_STRUC	AS4TAB	CHAR	30	0	DDIC Structure for Aggregated Hierarchical View in Tree	*
5	LIGHT	☐	QG_EVAL_LIGHT	QG_EVAL_LIGHT	CHAR	1	0	Symbols for Appraising Aggregated Data
6	LIGHT_TOOLTIP	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
7	INVISIBLE	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)
8	.INCLUDE	☐				0	0	Shared Grouping Characteristics
9	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
12	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
13	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
14	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
15	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	*
16	.INCLUDE	☐				0	0	Grouping Characteristics for Inspection Lots
17	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
18	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
19	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
20	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
21	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
22	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
23	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
24	VCODE	☐	QVCODE	QCODE	CHAR	4	0	Usage Decision Code	*
25	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
26	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
27	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
28	USERC1	☐	QGEVAL_USERC1		CHAR	18	0	User Field for 18 Characters
29	USERC2	☐	QGEVAL_USERC2	QUSRCHAR10	CHAR	10	0	User Field for 10 Characters
30	USERN1	☐	QGEVAL_USERN1	QUSRNUMC10	NUMC	10	0	User Field for 10 Digits
31	USERN2	☐	QGEVAL_USERN2	QUSRNUMC3	NUMC	3	0	User Field for 3 Digits
32	STABICON	☐	QSTABICON	QSTABICON	CHAR	8	0	Storage Condition
33	.INCLUDE	☐				0	0	Grouping Characteristics for Master Inspection Charac.
34	.INCLUDE	☐				0	0	General Grouping Charac. for Master Inspection Charac.
35	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
36	.INCLUDE	☐				0	0	Special Grouping Charac. for Master Inspection Charac.
37	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	*
38	QPMK_WERKS	☐	QGEVAL_QPMK_WERKS	QZAEHLER	CHAR	4	0	Plant for Master Inspection Characteristic
39	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
40	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
41	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
42	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	*
43	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
44	MASCHINE	☐	QMASCHINE	QEQUNR	CHAR	18	0	General Information
45	.INCLUDE	☐				0	0	Grouping Characteristics for Defects/Items
46	FEKAT	☐	FEKAT	QKATART	CHAR	1	0	Catalog Type - Problems	*
47	FEGRP	☐	QGEVAL_FEGRP		CHAR	8	0	Code Group - Defect
48	FECOD	☐	FECOD	QCODE	CHAR	4	0	Problem	*
49	OTKAT	☐	OTKAT	QKATART	CHAR	1	0	Catalog Type - Object Parts	*
50	OTGRP	☐	OTGRP	QCODEGRP	CHAR	8	0	Code Group - Object Parts	*
51	OTEIL	☐	OTEIL	QCODE	CHAR	4	0	Part of Object	*
52	FEQKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	*
53	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	*
54	KZSYSFE	☐	QKZSYSFE	QKZ	CHAR	1	0	Systematic Defect
55	.INCLUDE	☐				0	0	Key Figures for Aggregated Inspection Lots
56	.INCLUDE	☐				0	0	Shared Indicators
57	ENTRIES	☐	QG_EVAL_ENTRIES		INT4	10	0	Number of Data Records in Aggregate
58	RATIO	☐	QG_EVAL_RATIO	QG_EVAL_RATIO	DEC	7	4	Ratio Between Two Values
59	MENGE	☐	QG_EVAL_MENGE	QG_EVAL_MENGE	QUAN	13	0	Quantity
60	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
61	.INCLUDE	☐				0	0	Key Figures for an Aggregate in the Inspection Lot Hierarchy
62	CP	☐	QQRKCPC	QSTATWERTC	CHAR	16	0	Process Capability Index (cp)
63	CPK	☐	QQRKCPKC	QSTATWERTC	CHAR	16	0	Process Capability Index (cpk)
64	STDDEV	☐	QSTDAWC	QSTATWERTC	CHAR	16	0	Standard Deviation of Valid Measured Values
65	MEAN	☐	QMITTEWRTC	QSTATWERTC	CHAR	16	0	Arithmetic Mean of Valid Measured Values
66	ANZWERTG	☐	QANZWERTG4	QANZAHL4	INT4	10	0	Number of Inspected Sample Units
67	MAXWERT	☐	QMAXWERTC	QSTATWERTC	CHAR	16	0	Maximum Value of the Valid Measured Values
68	MINWERT	☐	QMINWERTC	QSTATWERTC	CHAR	16	0	Minimum Value of the Valid Measured Values
69	ANZWERTO	☐	QANZWERTO4	QANZAHL4	INT4	10	0	Number of Measured Values Above the Tolerance Range
70	ANZWERTU	☐	QANZWERTU4	QANZAHL4	INT4	10	0	Number of Measured Values Below the Tolerance Range
71	STDABW	☐	QG_EVAL_STDABW	QSTATWERTC	CHAR	16	0	Standard Deviation from Overall Dispersion
72	SKIP_RATE	☐	QG_EVAL_SKIP_RATE		DEC	4	1	Percentage of Skips
73	PIPC133	☐	QG_EVAL_PIPC133		DEC	4	1	Percentage of Characteristics with CpK > 1.33
74	PIPC167	☐	QG_EVAL_PIPC167		DEC	4	1	Percentage of Characteristics with CpK > 1.67
75	PIST	☐	QG_EVAL_PIST		DEC	7	4	Percentage Within Specification
76	QKENNZAHL	☐	QKENNZAHL	QKENNZAHL	DEC	3	0	Quality Score
77	.INCLUDE	☐				0	0	Key Figures for Aggregated Defects or Items
78	MEAN_VALUATION	☐	QGEVAL_FEHLERBEW_MEAN	QGEVAL_FEHLERBEW	CHAR	16	0	Average Defect-Valuation
79	CUMUL_VALUATION	☐	QGEVAL_FEHLERBEW_CUMUL	QGEVAL_FEHLERBEW	CHAR	16	0	Cumulative Defect-Valuation
80	ANZFEHLER	☐	QANZFEHL4	QANZAHL4	INT4	10	0	Number of Defects Found
81	.INCLUDE	☐				0	0	Additional Information for Aggregated Inspection Lots
82	.INCLUDE	☐				0	0	Shared Additional Information
83	QTXT	☐	QTXT_CODE	QKURZTEXT	CHAR	40	0	Short Text for Code
84	.INCLUDE	☐				0	0	Structure for Informal Fields for Aggregate for Insp. Lots
85	QSPCMK	☐	QSPCMK	QKZ	CHAR	1	0	SPC Characteristic
86	ANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	*
87	.INCLUDE	☐				0	0	Additional Information for Inspection Characteristics
88	CHAR_TEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
89	.INCLUDE	☐				0	0	Additional Information for Defects or Items
90	UNITFLBEW	☐	QGEVAL_UNITFLBEW	MEINS	UNIT	3	0	Unit for Defect Valuation	*
91	LOCATION_TEXT	☐	QGEVAL_LOCATION_TXT	QKURZTEXT	CHAR	40	0	Short Text for Defect-Location Code
92	QUANTITAT	☐	QKZQUNMK	QKZ	CHAR	1	0	Quantitative Characteristic

History

Last changed by/on	SAP	20130529
SAP Release Created in	600