SAP ABAP Table QCRES (Certificates: Characteristic values)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QC (Package) QM quality certificate

Basic Data

Table Category	INTTAB	Structure
Structure	QCRES	Table Relationship Diagram
Short Description	Certificates: Characteristic values

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	LEVEL_RESULT	☐	QKZESEL	QKZESEL	CHAR	1	0	Level for Result Selection
2	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
3	TEILLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	*
4	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
5	MERKNR	☐	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
6	PROBENR	☐	QPROBENR	QPROBENR	NUMC	6	0	Sample Number	*
7	DETAILERG	☐	QDETAILERG	QDETAILERG	NUMC	8	0	Number of the Individual Result
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
10	.INCLUDE	☐				0	0	Quality Certificate: Result Output
11	MVALUE	☐	QCOUTMVAL	TDSTXLLINE	CHAR	132	0	Certificates: Output Field for Mean Value
12	ATTRIBUTE_QDI	☐	QCATTRIBUT	QCATTRIBUT	CHAR	3	0	Attribute for Results Record (Greater, Smaller,..)
13	VALUE1_QDI	☐	QC_VALUE	QSTATWERTC	CHAR	16	0	Value or Part of Value Range on Certificate
14	VALUE2_QDI	☐	QC_VALUE	QSTATWERTC	CHAR	16	0	Value or Part of Value Range on Certificate
15	KZSPEC	☐	QCKZSPEC	QCKZSPEC	CHAR	2	0	Relationship of Value to Specifications
16	STAT07	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
17	SLWBEZ	☐	QSLWBEZ	QSLWBEZ	CHAR	3	0	Identification for the Inspection Point Field Combination	*
18	STAT13	☐	QPPKTTYP	QPPKTTYP	CHAR	1	0	Inspection Point Type
19	PHYSPROBE	☐	QPHYSPROBE	QPROBENR	NUMC	6	0	Number of the Partial Sample	*
20	STATUSR	☐	QBEASTATUS	QSTATUS	CHAR	1	0	Results Record Status	TQ76
21	STATUSTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
22	QUANTITAT	☐	QKZQUNMK	QKZ	CHAR	1	0	Quantitative Characteristic
23	MESSWERTE	☐	QKZQUMK	QKZ	CHAR	1	0	Measured Values Must Be Recorded
24	PRUEFKAT	☐	QKZPKAT	QKZ	CHAR	1	0	Reference to Characteristic Attribute Required
25	TOLEROBEN	☐	QKZTOLOB	QKZ	CHAR	1	0	Upper Specification Limit
26	TOLERUNTEN	☐	QKZTOLUN	QKZ	CHAR	1	0	Lower Specification Limit
27	SOLLPRUEF	☐	QKZSOLLPR	QKZ	CHAR	1	0	Check Target Value
28	PUMFKZ	☐	QPUMFKZ	QPUMFKZ	CHAR	1	0	Inspection Scope
29	LZEITKZ	☐	QLZEITKZ	QKZ	CHAR	1	0	Long-Term Inspection
30	ESTUKZ	☐	QESTUKZ	QESTUKZ	CHAR	1	0	Recording Type
31	DOKUKZ	☐	QDOKUKZ	QDOKUKZ	CHAR	1	0	Documentation Required for Inspection Results
32	RZWANG	☐	QRZWANG	QRZWANG	CHAR	1	0	Characteristic Category
33	SYNCRO	☐	QSYNCRO	QKZ	CHAR	1	0	Synchronization is Active
34	ZERSTPRF	☐	QKZDESTROY	QKZ	CHAR	1	0	Destructive Inspection
35	FORMELMK	☐	QKZFORMEL	QKZFORMEL	CHAR	1	0	Calculated Characteristic
36	STICHPR	☐	QSTICHPR	QKZ	CHAR	1	0	Sampling Procedure is Required
37	AUSSLOS	☐	QAUSSLOS	QKZ	CHAR	1	0	Characteristic Relevant for Qual. Score and Scrap Share
38	BEWFHLZHL	☐	QBFHLZHL	QKZ	CHAR	1	0	Recording the Number of Defects
39	FEHLREC	☐	QFEHLREC	QKZ	CHAR	1	0	Defects Recording Automatically Called Up
40	AENDBELEG	☐	QKZAENBEL	QKZ	CHAR	1	0	Create Change Documents During Results Recording
41	WERKS	☐	QWERKS	WERKS	CHAR	4	0	Plant	T001W
42	MKMNR	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	*
43	VERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
44	KURZTEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
45	ATNAM	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
46	ATWTB	☐	ATWTB	TEXT30	CHAR	30	0	Characteristic value description
47	ATTRIBUT	☐	QATTRIBUT	QATTRIBUT	CHAR	1	0	Attribute of the Results Record (Valid, Invalid,...)
48	ATTRTEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
49	QERGDATH	☐	QERGDATH	QERGDATH	CHAR	2	0	Origin of Results Data	*
50	ERDATHETXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
51	MBEWERTG	☐	QMBEWERTG	QEEBEWERTG	CHAR	1	0	Inspection Result Valuation
52	MBEWTEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
53	PRUEFBEMKT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
54	PRLTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
55	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
56	ANZFEHLEH	☐	QANZFEHEH4	QANZAHL4	INT4	10	0	Number of Nonconforming Sample Units
57	ANTEIL	☐	QANTEILC	QSOLLWERTC	CHAR	16	0	Estimated Fraction of Nonconforming Units
58	ANZFEHLER	☐	QANZFEHL4	QANZAHL4	INT4	10	0	Number of Defects Found
59	ANZWERTO	☐	QANZWERTO4	QANZAHL4	INT4	10	0	Number of Measured Values Above the Tolerance Range
60	ANZWERTU	☐	QANZWERTU4	QANZAHL4	INT4	10	0	Number of Measured Values Below the Tolerance Range
61	ANZWERTG	☐	QANZWERTG4	QANZAHL4	INT4	10	0	Number of Inspected Sample Units
62	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
63	MASSEINHSW	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
64	MAXWERT	☐	QMAXWERTC	QSTATWERTC	CHAR	16	0	Maximum Value of the Valid Measured Values
65	MINWERT	☐	QMINWERTC	QSTATWERTC	CHAR	16	0	Minimum Value of the Valid Measured Values
66	MITTELWERT	☐	QMITTEWRTC	QSTATWERTC	CHAR	16	0	Arithmetic Mean of Valid Measured Values
67	VARIANZ	☐	QVARIANZC	QSTATWERTC	CHAR	16	0	Dispersion (Variance) of Valid Measured Values
68	MOMENT3	☐	QMOMENT3C	QSTATWERTC	CHAR	16	0	Third Central Moment of Valid Measured Values
69	MOMENT4	☐	QMOMENT4C	QSTATWERTC	CHAR	16	0	Fourth Central Moment of Valid Measured Values
70	ANTEILO	☐	QANTEILOC	QSTATWERTC	CHAR	16	0	Estimated Fraction Above the Tolerance Range
71	ANTEILU	☐	QANTEILUC	QSTATWERTC	CHAR	16	0	Estimated Fraction Below the Tolerance Range
72	IVARIANZ	☐	QIVARIANZC	QSTATWERTC	CHAR	16	0	Internal Dispersion of Valid Measured Values
73	GRUPPE1	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
74	CODE1	☐	QCODE	QCODE	CHAR	4	0	Code	*
75	CODEKTXT1	☐	QTXT_CODE	QKURZTEXT	CHAR	40	0	Short Text for Code
76	STDABW	☐	QSTDAWC	QSTATWERTC	CHAR	16	0	Standard Deviation of Valid Measured Values
77	SPANNWEITE	☐	QSPANNWEIC	QSTATWERTC	CHAR	16	0	Range of Valid Measured Values
78	FEHLKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17
79	FEHLKLTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
80	PPSORTKEY	☐	QPPSORTKEY	QPPSORT	CHAR	70	0	Key Field (Sort Field) for Inspection Point
81	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
82	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
83	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
84	STUECKNR	☐	QSTUECKNR	QZAEHL	NUMC	4	0	Counter for Inspection Unit Number
85	SERIALNR	☐	QPRUEFLINR	QSERIALNR	CHAR	18	0	Single-Unit Number for the Unit to Be Inspected
86	MASCHINE	☐	QMASCHINE	QEQUNR	CHAR	18	0	General Information
87	INSP_POSITION	☐	QPRPOS	QPRPOS	NUMC	4	0	Test Position
88	GRPTXT1	☐	QGRPTEXT	QKURZTEXT	CHAR	40	0	Short Text for Code Group
89	UNIT_CHARACT	☐	QMGEH6	MSEC6	CHAR	6	0	Measurement Unit in Which Quantitative Data Is Maintained	*
90	UNIT_CHARACT_10	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
91	UNIT_CHARACT_30	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QCRES	FEHLKLAS	TQ17	FEHLKLASSE
2	QCRES	LTEXTSPR	T002	SPRAS
3	QCRES	STATUSR	TQ76	STATUS
4	QCRES	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in