SAP ABAP Table QPMK (Inspection characteristic master)

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	TRANSP	Transparent table
Transparent table	QPMK	Table Relationship Diagram
Short Description	Inspection characteristic master

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ZAEHLER	☑	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
3	MKMNR	☑	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics
4	VERSION	☑	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
7	SORTFELD	☐	QSORTFELD	CHAR40	CHAR	40	0	Search Field
8	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange
9	LOEKZ	☐	QLOESCHKZ	QLOESCHKZ	CHAR	1	0	Status of Master Record
10	LSPER	☐	QVERW	QKZ	CHAR	1	0	Data Record is Being Used
11	KONSISTENT	☐	QVOLLST	QVOLLST	CHAR	1	0	Copy Model/Reference Characteristic
12	AUTOR	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
13	DATES	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
14	AEAUT	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
15	DATAE	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
16	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
17	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
18	PRFQL	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
19	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
20	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
21	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
22	QAUTH	☐	QMASTAUTH	QMASTAUTH	CHAR	8	0	Authorization Group QM Basic Data	TQ01D
23	TOLERANZSL	☐	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
24	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
25	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
26	.INCLUDE	☐				0	0	Quantitative data for the inspection characteristic
27	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
28	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
29	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
30	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
31	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
32	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
33	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
34	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
35	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
36	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
37	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
38	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
39	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
40	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
41	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
42	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
43	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
44	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
45	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
46	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
47	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
48	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
49	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
50	TOLERWEIOB	☐	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
51	TOLWOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
52	TOLERWEIUN	☐	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
53	TOLWUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
54	TOLERWAB	☐	QTOLWAB	DATUM	DATS	8	0	Date from Which the Tolerance Change Is Valid
55	TOLERWBIS	☐	QTOLWBIS	DATUM	DATS	8	0	Date Until Which the Tolerance Change Is Valid
56	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance	QPGR
57	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	QPCD
58	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
59	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance	QPGR
60	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	QPCD
61	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
62	ATINN	☐	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
63	EEANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72
64	CODEGRQUAL	☐	QCODEGRPQL	QCODEGRP	CHAR	8	0	Defect Code Group for General Rejection	QPGR
65	CODEQUAL	☐	QCODEQL	QCODE	CHAR	4	0	Defect Code for Rejection: General	QPCD
66	INPPROC	☐	QINPPROC	CHAR3	CHAR	3	0	Parameters for Input Processing in QM Results Recording	TQ71
67	SPEC_DET_RULE	☐	QASDR_SPEC_DET_RULE	QASDR_SPEC_DET_RULE	CHAR	3	0	Specification Determination Rule	QASDRI_SPECDET
68	SPEC_DET_ACTIVE	☐	QASDR_SDR_ACTIVE	QKZ	CHAR	1	0	Active Indicator for Specification Determination Rule
69	.INCLUDE	☐				0	0	Customer Fields for MIC for Specification Determination
70	PARAMETER1	☐	QASDR_SDR_PARAMETER	TEXT16	CHAR	16	0	Parameters for Specification Determination
71	PARAMETER2	☐	QASDR_SDR_PARAMETER	TEXT16	CHAR	16	0	Parameters for Specification Determination

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in