SAP ABAP Table QPMKV (Logical data base QMM (QPMK and QPMT and QPMZ))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QA (Package) QM master data

Basic Data

Table Category	INTTAB	Structure
Structure	QPMKV	Table Relationship Diagram
Short Description	Logical data base QMM (QPMK and QPMT and QPMZ)

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	Inspection characteristic master
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ZAEHLER	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
4	MKMNR	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	*
5	VERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
8	SORTFELD	☐	QSORTFELD	CHAR40	CHAR	40	0	Search Field
9	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
10	LOEKZ	☐	QLOESCHKZ	QLOESCHKZ	CHAR	1	0	Status of Master Record
11	LSPER	☐	QVERW	QKZ	CHAR	1	0	Data Record is Being Used
12	KONSISTENT	☐	QVOLLST	QVOLLST	CHAR	1	0	Copy Model/Reference Characteristic
13	AUTOR	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
14	DATES	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
15	AEAUT	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
16	DATAE	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
17	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
18	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
19	PRFQL	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
20	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
21	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
22	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
23	QAUTH	☐	QMASTAUTH	QMASTAUTH	CHAR	8	0	Authorization Group QM Basic Data	TQ01D
24	TOLERANZSL	☐	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
25	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
26	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
27	.INCLUDE	☐				0	0	Quantitative data for the inspection characteristic
28	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
29	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
30	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
31	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
32	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
33	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
34	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
35	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
36	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
37	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
38	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
39	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
40	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
41	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
42	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
43	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
44	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
45	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
46	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
47	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
48	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
49	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
50	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
51	TOLERWEIOB	☐	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
52	TOLWOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
53	TOLERWEIUN	☐	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
54	TOLWUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
55	TOLERWAB	☐	QTOLWAB	DATUM	DATS	8	0	Date from Which the Tolerance Change Is Valid
56	TOLERWBIS	☐	QTOLWBIS	DATUM	DATS	8	0	Date Until Which the Tolerance Change Is Valid
57	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance	QPGR
58	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	QPCD
59	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
60	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance	QPGR
61	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	QPCD
62	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
63	ATINN	☐	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
64	EEANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72
65	CODEGRQUAL	☐	QCODEGRPQL	QCODEGRP	CHAR	8	0	Defect Code Group for General Rejection	QPGR
66	CODEQUAL	☐	QCODEQL	QCODE	CHAR	4	0	Defect Code for Rejection: General	QPCD
67	INPPROC	☐	QINPPROC	CHAR3	CHAR	3	0	Parameters for Input Processing in QM Results Recording	TQ71
68	SPEC_DET_RULE	☐	QASDR_SPEC_DET_RULE	QASDR_SPEC_DET_RULE	CHAR	3	0	Specification Determination Rule	QASDRI_SPECDET
69	SPEC_DET_ACTIVE	☐	QASDR_SDR_ACTIVE	QKZ	CHAR	1	0	Active Indicator for Specification Determination Rule
70	.INCLUDE	☐				0	0	Customer Fields for MIC for Specification Determination
71	PARAMETER1	☐	QASDR_SDR_PARAMETER	TEXT16	CHAR	16	0	Parameters for Specification Determination
72	PARAMETER2	☐	QASDR_SDR_PARAMETER	TEXT16	CHAR	16	0	Parameters for Specification Determination
73	SPRACHE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
74	KURZTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
75	GELOESCHT	☐	QGELOESCHT	QKZ	CHAR	1	0	Data Record Was Deleted
76	WERKPM	☐	QWERKPMT	WERKS	CHAR	4	0	Plant of the Inspection Method	*
77	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	*
78	VERSPM	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
79	ANONR	☐	QPOSNR	QPOSNR	CHAR	2	0	Position of a method for a char. within a list of methods
80	KATAB1	☐	QKTTAB1	QKTTAB	CHAR	1	0	Catalog Entry 1 Is a Selected Set
81	KATALGART1	☐	QKATAUSW1	QKATART	CHAR	1	0	Catalog Type 1 for the Characteristic Attributes	*
82	AUSWMENGE1	☐	QCGRAUSW1	QCGRAUSW	CHAR	8	0	First Assigned Code Group or Selected Set
83	VERSION1	☐	QVERSNR1	QVERSNR	CHAR	6	0	Version Number of the First Assigned Entry
84	AUSWMGWRK1	☐	QWERKAUSW1	WERKS	CHAR	4	0	Plant of the First Assigned Selected Set	*
85	KATAB2	☐	QKTTAB2	QKTTAB	CHAR	1	0	Catalog Entry 2 Is a Selected Set
86	KATALGART2	☐	QKATAUSW2	QKATART	CHAR	1	0	Catalog Type of the Second Assigned Catalog Entry	*
87	AUSWMENGE2	☐	QCGRAUSW2	QCGRAUSW	CHAR	8	0	Second Assigned Code Group or Selected Set
88	VERSION2	☐	QVERSNR2	QVERSNR	CHAR	6	0	Version Number of the Second Assigned Entry
89	AUSWMGWRK2	☐	QWERKAUSW2	WERKS	CHAR	4	0	Plant of the Second Assigned Selected Set	*
90	KATAB3	☐	QKTTAB3	QKTTAB	CHAR	1	0	Catalog Entry 3 Is a Selected Set
91	KATALGART3	☐	QKATAUSW3	QKATART	CHAR	1	0	Catalog Type of the Third Assigned Catalog Entry	*
92	AUSWMENGE3	☐	QCGRAUSW3	QCGRAUSW	CHAR	8	0	Third Assigned Code Group or Selected Set
93	VERSION3	☐	QVERSNR3	QVERSNR	CHAR	6	0	Version Number of the Third Assigned Entry
94	AUSWMGWRK3	☐	QWERKAUSW3	WERKS	CHAR	4	0	Plant of the Third Assigned Selected Set	*
95	KATAB4	☐	QKTTAB4	QKTTAB	CHAR	1	0	Catalog Entry 4 Is a Selected Set
96	KATALGART4	☐	QKATAUSW4	QKATART	CHAR	1	0	Catalog Type of the Fourth Assigned Catalog Entry	*
97	AUSWMENGE4	☐	QCGRAUSW4	QCGRAUSW	CHAR	8	0	Fourth Assigned Code Group or Selected Set
98	VERSION4	☐	QVERSNR4	QVERSNR	CHAR	6	0	Version Number of the Fourth Assigned Entry
99	AUSWMGWRK4	☐	QWERKAUSW4	WERKS	CHAR	4	0	Plant of the Fourth Assigned Selected Set	*
100	KATAB5	☐	QKTTAB5	QKTTAB	CHAR	1	0	Catalog Entry 5 Is a Selected Set
101	KATALGART5	☐	QKATAUSW5	QKATART	CHAR	1	0	Catalog Type of the Fifth Assigned Catalog Entry	*
102	AUSWMENGE5	☐	QCGRAUSW5	QCGRAUSW	CHAR	8	0	Fifth Assigned Code Group or Selected Set
103	VERSION5	☐	QVERSNR5	QVERSNR	CHAR	6	0	Version Number of the Fifth Assigned Entry
104	AUSWMGWRK5	☐	QWERKAUSW5	WERKS	CHAR	4	0	Plant of the Fifth Assigned Selected Set	*
105	LTEXTKZ	☐	QLTEXTMK	QKZ	CHAR	1	0	Long Text Exists for the Characteristic
106	LTEXTEKZ	☐	QLTEXTEKZ	QKZ	CHAR	1	0	Long Text for Physical-Sample Drawing of a Characteristic

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPMKV	CODE9O	QPCD	CODE	REF	C	CN
2	QPMKV	CODE9U	QPCD	CODE	REF	C	CN
3	QPMKV	CODEGR9O	QPGR	CODEGRUPPE	REF	C	CN
4	QPMKV	CODEGR9U	QPGR	CODEGRUPPE	REF	C	CN
5	QPMKV	CODEGRQUAL	QPGR	CODEGRUPPE	REF	C	CN
6	QPMKV	CODEQUAL	QPCD	CODE	REF	C	CN
7	QPMKV	EEANTVERF	TQ72	ANTVERF
8	QPMKV	INPPROC	TQ71	INPPROC
9	QPMKV	MANDT	T000	MANDT	KEY	1	CN
10	QPMKV	MASSEINHSW	T006	MSEHI
11	QPMKV	MERKGEW	TQ17A	MERKKLASSE
12	QPMKV	PRFQL	TQ11	PRFQL
13	QPMKV	QAUTH	TQ01D	QMASTAUTH
14	QPMKV	SPEC_DET_RULE	QASDRI_SPECDET	SPEC_DET_RULE
15	QPMKV	TOLERANZSL	TQ29	TOLERANZSL
16	QPMKV	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in