SAP Table QPMK
Inspection characteristic master
QPMK (Inspection characteristic master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QPMK to other SAP tables.
QPMK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
ZAEHLER
Plant for the Master Inspection Characteristic
|
QZAEHLER |
CHAR
|
4 | 0 | ||||||||||||||
|
MKMNR
Master Inspection Characteristics
|
QMERKNR |
CHAR
|
8 | 0 | ||||||||||||||
|
VERSION
Version Number of the Master Inspection Characteristic
|
QVERSNRMK |
CHAR
|
6 | 0 | ||||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||
|
GUELTIGAB
Valid-From Date
|
DATUV |
DATS
|
8 | 0 | ||||||||||||||
|
SORTFELD
Search Field
|
QSORTFELD |
CHAR
|
40 | 0 | ||||||||||||||
|
CHARACT_ID1
Characteristic Description for Quality Data Exchange
|
QCHARACT_ID1 |
CHAR
|
40 | 0 | ||||||||||||||
|
LOEKZ
Status of Master Record
|
QLOESCHKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LSPER
Data Record Is Used
|
QVERW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KONSISTENT
Copy Model/Reference Characteristic
|
QVOLLST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AUTOR
Name of User Who Created the Data Record
|
QERSTELLER |
CHAR
|
12 | 0 | ||||||||||||||
|
DATES
Date on Which the Data Record Was Created
|
QDATUMERST |
DATS
|
8 | 0 | ||||||||||||||
|
AEAUT
Name of User who Most Recently Changed the Data Record
|
QAENDERER |
CHAR
|
12 | 0 | ||||||||||||||
|
DATAE
Date on Which Data Record Was Changed
|
QDATUMAEND |
DATS
|
8 | 0 | ||||||||||||||
|
STEUERKZ
Cntrl Indicator String for Insp. Char./Master Insp. Char.
|
QMKCONTROL |
CHAR
|
30 | 0 | ||||||||||||||
|
MERKGEW
Weighting of the Characteristic
|
QMERKGEW | TQ17A |
CHAR
|
2 | 0 | |||||||||||||
|
PRFQL
Inspector Qualification
|
QPRQUALIF | TQ11 |
CHAR
|
5 | 0 | |||||||||||||
|
DUMMY10
Text Line for Additional Information
|
QTXT10 |
CHAR
|
10 | 0 | ||||||||||||||
|
DUMMY20
Text Line for Additional Information
|
QTXT20 |
CHAR
|
20 | 0 | ||||||||||||||
|
DUMMY40
Text Line for Additional Information
|
QTXT40 |
CHAR
|
40 | 0 | ||||||||||||||
|
QAUTH
Authorization Group QM Basic Data
|
QMASTAUTH | TQ01D |
CHAR
|
8 | 0 | |||||||||||||
|
TOLERANZSL
Tolerance Key
|
QTOLERANZ | TQ29 |
CHAR
|
4 | 0 | |||||||||||||
|
STELLEN
Number of Places to the Right of a Decimal Point (Accuracy)
|
QSTELLEN |
INT1
|
3 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MASSEINHSW
Unit of Measurement, in Which Quantitative Data Is Stored
|
QMASSEH | T006 |
UNIT
|
3 | 0 | |||||||||||||
|
SOLLWERT
Target Value for a Quantitative Characteristic
|
QSOLLWERTE |
FLTP
|
16 | 16 | ||||||||||||||
|
SOLLWNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TOLERANZOB
Upper Specification Limit
|
QTOLOB |
FLTP
|
16 | 16 | ||||||||||||||
|
TOLOBNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TOLERANZUN
Lower Tolerance Limit
|
QTOLUN |
FLTP
|
16 | 16 | ||||||||||||||
|
TOLUNNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KLASANZAHL
Number of Value Classes for Inspection Results
|
QKLASSZAHL |
INT1
|
3 | 0 | ||||||||||||||
|
KLASBREITE
Class Width
|
QKLASSBR |
FLTP
|
16 | 16 | ||||||||||||||
|
KLASBRNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KLASMITTE
Class Midpoint
|
QKLASSMIT |
FLTP
|
16 | 16 | ||||||||||||||
|
KLASMINI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GRENZEOB1
First Upper Specification Limit
|
QGRENZOB1 |
FLTP
|
16 | 16 | ||||||||||||||
|
GRENZOB1NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GRENZEUN1
First Lower Specification Limit
|
QGRENZUN1 |
FLTP
|
16 | 16 | ||||||||||||||
|
GRENZUN1NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GRENZEOB2
Second Upper Specification Limit
|
QGRENZOB2 |
FLTP
|
16 | 16 | ||||||||||||||
|
GRENZOB2NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
GRENZEUN2
Second Lower Specification Limit
|
QGRENZUN2 |
FLTP
|
16 | 16 | ||||||||||||||
|
GRENZUN2NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PLAUSIOBEN
Upper Plausibility Limit
|
QPLAUSIOB |
FLTP
|
16 | 16 | ||||||||||||||
|
PLAUSIOBNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PLAUSIUNTE
Lower Plausibility Limit
|
QPLAUSIUN |
FLTP
|
16 | 16 | ||||||||||||||
|
PLAUSIUNNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TOLERWEIOB
Change to Upper Specification Limit
|
QTOLWOB |
FLTP
|
16 | 16 | ||||||||||||||
|
TOLWOBNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TOLERWEIUN
Change to Lower Specification Limit
|
QTOLWUN |
FLTP
|
16 | 16 | ||||||||||||||
|
TOLWUNNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TOLERWAB
Date from Which the Tolerance Change Is Valid
|
QTOLWAB |
DATS
|
8 | 0 | ||||||||||||||
|
TOLERWBIS
Date Until Which the Tolerance Change Is Valid
|
QTOLWBIS |
DATS
|
8 | 0 | ||||||||||||||
|
CODEGR9U
Defect Code Group for Rejection at Lower Tolerance
|
QCODEGRPU | QPGR |
CHAR
|
8 | 0 | |||||||||||||
|
CODE9U
Defect Code for Rejection at Lower Specification Limit
|
QCODEU | QPCD |
CHAR
|
4 | 0 | |||||||||||||
|
CODEVR9U
Version Number
|
QVERSNR |
CHAR
|
6 | 0 | ||||||||||||||
|
CODEGR9O
Defect Code Group for Rejection at Upper Tolerance
|
QCODEGRPO | QPGR |
CHAR
|
8 | 0 | |||||||||||||
|
CODE9O
Defect Code for Rejection at Upper Specification Limit
|
QCODEO | QPCD |
CHAR
|
4 | 0 | |||||||||||||
|
CODEVR9O
Version Number
|
QVERSNR |
CHAR
|
6 | 0 | ||||||||||||||
|
ATINN
Internal characteristic
|
ATINN |
NUMC
|
10 | 0 | ||||||||||||||
|
EEANTVERF
Fraction Calculation
|
QEANTVERF | TQ72 |
CHAR
|
2 | 0 | |||||||||||||
|
CODEGRQUAL
Defect Code Group for General Rejection
|
QCODEGRPQL | QPGR |
CHAR
|
8 | 0 | |||||||||||||
|
CODEQUAL
Defect Code for Rejection: General
|
QCODEQL | QPCD |
CHAR
|
4 | 0 | |||||||||||||
|
INPPROC
Parameters for Input Processing in QM Results Recording
|
QINPPROC | TQ71 |
CHAR
|
3 | 0 | |||||||||||||
|
SPEC_DET_RULE
Specification Determination Rule
|
QASDR_SPEC_DET_RULE | QASDRI_SPECDET |
CHAR
|
3 | 0 | |||||||||||||
|
SPEC_DET_ACTIVE
Active Indicator for Specification Determination Rule
|
QASDR_SDR_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PARAMETER1
Parameters for Specification Determination
|
QASDR_SDR_PARAMETER |
CHAR
|
16 | 0 | ||||||||||||||
|
PARAMETER2
Parameters for Specification Determination
|
QASDR_SDR_PARAMETER |
CHAR
|
16 | 0 | ||||||||||||||
QPMK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QPMK | CODE9O | QPMK | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| QPMK | CODE9O | '9' |
QPCD
Inspection catalog codes
|
KATALOGART | |
| QPMK | CODE9O | QPMK | CODEGR9U |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| QPMK | CODE9O | QPMK | CODE9O |
QPCD
Inspection catalog codes
|
CODE |
| QPMK | CODE9O | QPMK | VERSION |
QPCD
Inspection catalog codes
|
VERSION |
| QPMK | CODE9U | QPMK | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| QPMK | CODE9U | '9' |
QPCD
Inspection catalog codes
|
KATALOGART | |
| QPMK | CODE9U | QPMK | CODEGR9U |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| QPMK | CODE9U | QPMK | CODE9U |
QPCD
Inspection catalog codes
|
CODE |
| QPMK | CODE9U | QPMK | VERSION |
QPCD
Inspection catalog codes
|
VERSION |
| QPMK | CODEGR9O | QPMK | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QPMK | CODEGR9O | '9' |
QPGR
Inspection catalog code groups
|
KATALOGART | |
| QPMK | CODEGR9O | QPMK | CODEGR9O |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QPMK | CODEGR9U | QPMK | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QPMK | CODEGR9U | '9' |
QPGR
Inspection catalog code groups
|
KATALOGART | |
| QPMK | CODEGR9U | QPMK | CODEGR9U |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QPMK | CODEGRQUAL | QPMK | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QPMK | CODEGRQUAL | '9' |
QPGR
Inspection catalog code groups
|
KATALOGART | |
| QPMK | CODEGRQUAL | QPMK | CODEGRQUAL |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QPMK | CODEQUAL | QPMK | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| QPMK | CODEQUAL | '9' |
QPCD
Inspection catalog codes
|
KATALOGART | |
| QPMK | CODEQUAL | QPMK | CODEGR9U |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| QPMK | CODEQUAL | QPMK | CODEQUAL |
QPCD
Inspection catalog codes
|
CODE |
| QPMK | CODEQUAL | QPMK | VERSION |
QPCD
Inspection catalog codes
|
VERSION |
| QPMK | EEANTVERF | QPMK | MANDT |
TQ72
Type of share calculation
|
MANDT |
| QPMK | EEANTVERF | QPMK | EEANTVERF |
TQ72
Type of share calculation
|
ANTVERF |
| QPMK | INPPROC | SY | MANDT |
TQ71
Input Processing in Results Recording QM
|
MANDT |
| QPMK | INPPROC | QPMK | INPPROC |
TQ71
Input Processing in Results Recording QM
|
INPPROC |
| QPMK | MANDT | QPMK | MANDT |
T000
Clients
|
MANDT |
| QPMK | MASSEINHSW | QPMK | MANDT |
T006
Units of Measurement
|
MANDT |
| QPMK | MASSEINHSW | QPMK | MASSEINHSW |
T006
Units of Measurement
|
MSEHI |
| QPMK | MERKGEW | QPMK | MANDT |
TQ17A
Characteristic weightings
|
MANDT |
| QPMK | MERKGEW | QPMK | MERKGEW |
TQ17A
Characteristic weightings
|
MERKKLASSE |
| QPMK | PRFQL | QPMK | MANDT |
TQ11
Inspector qualification
|
MANDT |
| QPMK | PRFQL | QPMK | PRFQL |
TQ11
Inspector qualification
|
PRFQL |
| QPMK | QAUTH | SY | MANDT |
TQ01D
Authorization groups for QM master data
|
MANDT |
| QPMK | QAUTH | QPMK | QAUTH |
TQ01D
Authorization groups for QM master data
|
QMASTAUTH |
| QPMK | SPEC_DET_RULE | QPMK | SPEC_DET_RULE |
QASDRI_SPECDET
Specification Determination Rule
|
SPEC_DET_RULE |
| QPMK | TOLERANZSL | QPMK | MANDT |
TQ29
Defaults for target value and tolerances for characteristics
|
MANDT |
| QPMK | TOLERANZSL | QPMK | TOLERANZSL |
TQ29
Defaults for target value and tolerances for characteristics
|
TOLERANZSL |
| QPMK | WERKS | QPMK | WERKS |
T001W
Plants/Branches
|
WERKS |
| QPMK | WERKS | QPMK | MANDT |
T001W
Plants/Branches
|
MANDT |