SAP ABAP Table QAMV (Characteristic specifications for inspection processing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QE (Package) QM results recording

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QAMV	Table Relationship Diagram
Short Description	Characteristic specifications for inspection processing

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	VORGLFNR	☑	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
4	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
5	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
6	ERSTELLDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
7	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
8	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
9	PHYSPROBE	☐	QPHYSPROBE	QPROBENR	NUMC	6	0	Number of the Partial Sample	*
10	SATZSTATUS	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
11	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
12	TSTICHPRKZ	☐	QTSTICHPRO	QKZUMFS	CHAR	1	0	Partial Samples Possible
13	NOINPUTKZ	☐	QNOINPUT	QKZ	CHAR	1	0	Results Are Calculated Internally
14	NIPLANMKKZ	☐	QNIPLANMK	QKZ	CHAR	1	0	Unplanned Characteristic
15	AKTPPKT	☐	QAKTPPKT	QAKTPPKT	CHAR	1	0	Use of Unplanned Characteristics (Inspection Pt. Processing)
16	PPKTUNGEMK	☐	QPKTUNGEMK	QPROBENR	NUMC	6	0	Unplanned Characteristic Was Created with this Sample No.	QASV
17	QMTB_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	QMTB
19	PMTVERSION	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
20	ATINN	☐	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
21	ABW_CODES	☐	QABW_CODES	QKZ	CHAR	1	0	Deviating Valuation of Codes
22	QPMK_REF	☐	QKZ_REF_EE	QKZ_REF_EE	CHAR	1	0	Type of Master Insp. Characteristic Ref. Results Recording
23	QPMK_WERKS	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
24	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	QPMK
25	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
26	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
27	KURZTEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
28	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
29	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
30	LTEXTEKZ	☐	QKZPRZIEH	QKZWSP	CHAR	1	0	Physical-Sample-Drawing Text Exists
31	LTXTENTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
32	PRUEFQUALI	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
33	FORMEL1	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
34	FORMEL2	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
35	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
36	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
37	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
38	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance	*
39	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	*
40	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
41	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance	*
42	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	*
43	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
44	KATAB1	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
45	KATALGART1	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
46	AUSWMENGE1	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
47	AUSWMGWRK1	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
48	AUSWVERS1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
49	AUSWDAT1	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
50	KATAB2	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
51	KATALGART2	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
52	AUSWMENGE2	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
53	AUSWMGWRK2	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
54	AUSWVERS2	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
55	AUSWDAT2	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
56	KATAB3	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
57	KATALGART3	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
58	AUSWMENGE3	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
59	AUSWMGWRK3	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
60	AUSWVERS3	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
61	AUSWDAT3	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
62	KATAB4	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
63	KATALGART4	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
64	AUSWMENGE4	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
65	AUSWMGWRK4	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
66	AUSWVERS4	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
67	AUSWDAT4	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
68	KATAB5	☐	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
69	KATALGART5	☐	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
70	AUSWMENGE5	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
71	AUSWMGWRK5	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
72	AUSWVERS5	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
73	AUSWDAT5	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
74	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
75	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
76	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
77	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
78	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
79	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
80	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
81	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
82	TOLERWKZ	☐	QTOLERWKZ	QKZ	CHAR	1	0	Tolerance Change Is Active
83	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
84	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
85	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
86	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
87	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
88	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
89	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
90	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
91	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
92	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
93	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
94	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
95	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
96	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
97	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
98	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
99	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
100	PRZIEHVERF	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVP
101	VERSION	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure
102	POSNRPRZV	☐	QZAEHLPRZV	NUM4	NUMC	4	0	Item Number in Sample-Drawing Procedure
103	LOSGEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
104	PROBNRPL	☐	QPROBNRBIS	QPROBEPL	NUMC	3	0	Highest Partial Sample No. Valid for Instruction
105	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	QDSV
106	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
107	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
108	ANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72
109	BEWREGEL	☐	QBEWERT	QKEY1	CHAR	2	0	Valuation Rule	QDFM
110	PROBMGFAK	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
111	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
112	SOLLSTPUMF	☐	QGESUMF	QANZAHL4	INT4	10	0	Sample Size that Has to Be Inspected for a Characteristic
113	PRUEFUMF	☐	QPRUEFUMF	QMENGEPLOS	QUAN	13	3	Quantity to Be Inspected
114	MENGENEINH	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
115	HPZ	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
116	SOLLSTPANZ	☐	QSOSTPANZ	QANZAHL2	INT2	5	0	Number of Planned Partial Samples
117	ANTEILKZ	☐	QANTEILKZ	QKZ	CHAR	1	0	Take Share Estimate into Account
118	RUECKMELNR	☐	QRUECKNR	QRUECKNR	NUMC	8	0	Confirmation Number for Inspection Characteristic
119	KZEINSTELL	☐	QKZEINSTMK	QKZEINSTMK	CHAR	1	0	Characteristic Type
120	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
121	QDYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
122	KZDYNAUT	☐	QDYNTIME	QDYNTIME	CHAR	1	0	Time of Dynamic Modification in Inspection Lot
123	DYNKRIT	☐	QDYNSTRING	QDYNSTRING	CHAR	10	0	String for Dynamic Modification Criteria (Database Relevant)
124	DYNMERKREF	☐	QMERKDYN	QMERKNRP	NUMC	4	0	Characteristic (in Plan) whose Q-Level Will Be Copied
125	KZDYNR	☐	QKZDYNR	QKZ	CHAR	1	0	Dynamic Modification Rule Available
126	ZAEHLERQL	☐	QZAEHLERQL	QDYNANZ4	INT4	10	0	Sequential Counter for Different Quality Levels
127	FORMELSL	☐	QFORMELSL	QFORMELSL	CHAR	1	0	Check and Calculate Formula in QM
128	PZLFH	☐	QPZLFH	PZLFH	NUMC	8	0	Assigned Test Equipment
129	CODEGRQUAL	☐	QCODEGRPQL	QCODEGRP	CHAR	8	0	Defect Code Group for General Rejection	*
130	CODEQUAL	☐	QCODEQL	QCODE	CHAR	4	0	Defect Code for Rejection: General	*
131	KZRAST	☐	QKZRAST	QKZRAST	CHAR	1	0	Indicator: Sampling Procedure for Inspection Points
132	.INCLUDE	☐				0	0	Inspection point: inspection interval control
133	RASTER	☐	QRASTER	QRASTER	NUMC	3	0	Inspection Frequency (Only for Inspection with Insp. Points)
134	PPANZPRUE	☐	QPPANZPRUE	QDYNANZ4	INT4	10	0	Number of Insp. Point Inspections Without Characteristic
135	SPCKRIT	☐	QSPCKRIT	QSPCKRIT	CHAR	3	0	SPC Criterion	QPSP
136	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
137	QERGDATH	☐	QERGDATHPL	QERGDATH	CHAR	2	0	Planned Results Data Origin	TQ73
138	INPPROC	☐	QINPPROC	CHAR3	CHAR	3	0	Parameters for Input Processing in QM Results Recording

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAMV	ANTVERF	TQ72	ANTVERF	REF	C	CN
2	QAMV	AUSWMGWRK1	T001W	WERKS	REF	C	N
3	QAMV	AUSWMGWRK2	T001W	WERKS	REF	C	N
4	QAMV	AUSWMGWRK3	T001W	WERKS	REF	C	N
5	QAMV	AUSWMGWRK4	T001W	WERKS	REF	C	N
6	QAMV	AUSWMGWRK5	T001W	WERKS	REF	C	N
7	QAMV	BEWREGEL	QDFM	FBKEY	REF	C	N
8	QAMV	KATALGART1	TQ15	KATALOGART	REF	C	N
9	QAMV	KATALGART2	TQ15	KATALOGART	REF	C	N
10	QAMV	KATALGART3	TQ15	KATALOGART	REF	C	N
11	QAMV	KATALGART4	TQ15	KATALOGART	REF	C	N
12	QAMV	KATALGART5	TQ15	KATALOGART	REF	C	N
13	QAMV	LOSGEBEH	T006	MSEHI	REF	C	CN
14	QAMV	LTEXTSPR	T002	SPRAS	REF	C	N
15	QAMV	LTXTENTSPR	T002	SPRAS	REF	C	N
16	QAMV	MANDANT	T000	MANDT	KEY	1	CN
17	QAMV	MASSEINHSW	T006	MSEHI	REF	C	N
18	QAMV	MENGENEINH	T006	MSEHI	REF	C	N
19	QAMV	MERKGEW	TQ17A	MERKKLASSE	REF	C	N
20	QAMV	PMETHODE	QMTB	PMTNR	REF	C	CN
21	QAMV	PPKTUNGEMK	QASV	PROBENR		C	CN
22	QAMV	PROBEMGEH	T006	MSEHI	REF	C	N
23	QAMV	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
24	QAMV	PRUEFQUALI	TQ11	PRFQL	REF	C	N
25	QAMV	PRZIEHVERF	QPRVP	PRZIEHVERF	REF	C	CN
26	QAMV	QDYNREGEL	QDDR	DYNREGEL	REF	C	CN
27	QAMV	QERGDATH	TQ73	QERGDATH
28	QAMV	QMTB_WERKS	T001W	WERKS	REF	C	N
29	QAMV	SATZSTATUS	TQ76	STATUS	REF	C	CN
30	QAMV	SPCKRIT	QPSP	SPCKRIT	KEY	1	CN
31	QAMV	STICHPRVER	QDSV	STICHPRVER	REF	C	CN
32	QAMV	VERWMERKM	QPMK	MKMNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in