SAP ABAP Table QAPMV (Characteristic specifications for inspection point)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG01 (Package) QM quality inspection analysis

Basic Data

Table Category	INTTAB	Structure
Structure	QAPMV	Table Relationship Diagram
Short Description	Characteristic specifications for inspection point

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

History

Last changed by/on	SAP	20130529
SAP Release Created in