1. Home
  2. Resources
  3. SAP Tables
  4. QPMK - Inspection characteristic master

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
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
1 Being created
2 Released
3 Can no longer be used
4 Deletion flag
5 Archived
LSPER Data Record Is Used QVERW CHAR 1 0
NULL Indicator is not set
X Indicator is set
KONSISTENT Copy Model/Reference Characteristic QVOLLST CHAR 1 0
NULL Incomplete copy model
1 Complete copy model
X Reference characteristic
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
0 To a maximum of 10 decimal places
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
NULL Indicator is not set
X Indicator is set
TOLERANZOB Upper Specification Limit QTOLOB FLTP 16 16
TOLOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERANZUN Lower Tolerance Limit QTOLUN FLTP 16 16
TOLUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
KLASMITTE Class Midpoint QKLASSMIT FLTP 16 16
KLASMINI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZEOB1 First Upper Specification Limit QGRENZOB1 FLTP 16 16
GRENZOB1NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZEUN1 First Lower Specification Limit QGRENZUN1 FLTP 16 16
GRENZUN1NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZEOB2 Second Upper Specification Limit QGRENZOB2 FLTP 16 16
GRENZOB2NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZEUN2 Second Lower Specification Limit QGRENZUN2 FLTP 16 16
GRENZUN2NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
PLAUSIOBEN Upper Plausibility Limit QPLAUSIOB FLTP 16 16
PLAUSIOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
PLAUSIUNTE Lower Plausibility Limit QPLAUSIUN FLTP 16 16
PLAUSIUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERWEIOB Change to Upper Specification Limit QTOLWOB FLTP 16 16
TOLWOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERWEIUN Change to Lower Specification Limit QTOLWUN FLTP 16 16
TOLWUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
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 '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 CODE9O 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 CODE9U QPMK MANDT QPCD Inspection catalog codes MANDT
QPMK CODEGR9O QPMK CODEGR9O QPGR Inspection catalog code groups CODEGRUPPE
QPMK CODEGR9O QPMK MANDT QPGR Inspection catalog code groups MANDT
QPMK CODEGR9O '9' QPGR Inspection catalog code groups KATALOGART
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 '9' QPGR Inspection catalog code groups KATALOGART
QPMK CODEGRQUAL QPMK CODEGRQUAL QPGR Inspection catalog code groups CODEGRUPPE
QPMK CODEGRQUAL QPMK MANDT QPGR Inspection catalog code groups 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 CODEQUAL QPMK MANDT QPCD Inspection catalog codes MANDT
QPMK EEANTVERF QPMK MANDT TQ72 Type of share calculation MANDT
QPMK EEANTVERF QPMK EEANTVERF TQ72 Type of share calculation ANTVERF
QPMK INPPROC QPMK INPPROC TQ71 Input Processing in Results Recording QM INPPROC
QPMK INPPROC SY MANDT TQ71 Input Processing in Results Recording QM MANDT
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 MANDT T001W Plants/Branches MANDT
QPMK WERKS QPMK WERKS T001W Plants/Branches WERKS