SAP table QPMK (Inspection characteristic master)

SAP table QPMK has 4 primary key fields being MANDT,ZAEHLER,MKMNR,VERSION.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ZAEHLER Plant for the Master Inspection Characteristic CHAR 4 0 QZAEHLER
MKMNR Master Inspection Characteristic CHAR 8 0 QMERKNR
VERSION Version Number of Master Inspection Characteristic CHAR 6 0 QVERSNRMK
WERKS Plant CHAR 4 0 T001W WERKS_D
GUELTIGAB Valid-From Date DATS 8 0 DATUV
SORTFELD Search Field CHAR 40 0 QSORTFELD
CHARACT_ID1 Characteristic Description for Quality Data Exchange CHAR 40 0 QCHARACT_ID1
LOEKZ Status of Master Record CHAR 1 0 QLOESCHKZ
1 Being Created
2 Released
3 Can No Longer Be Used
4 Deletion Flag
5 Archived
LSPER Data Record Is Used CHAR 1 0 QVERW
KONSISTENT Copy Model/Reference Characteristic CHAR 1 0 QVOLLST
Incomplete Copy Model
1 Complete Copy Model
X Reference Characteristic
AUTOR Name of User Who Created the Data Record CHAR 12 0 QERSTELLER
DATES System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
AEAUT Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
DATAE System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. CHAR 30 0 QMKCONTROL
MERKGEW Weighting of Characteristic CHAR 2 0 TQ17A QMERKGEW
PRFQL Inspector Qualification CHAR 5 0 TQ11 QPRQUALIF
DUMMY10 Text Line for Additional Information CHAR 10 0 QTXT10
DUMMY20 Text Line for Additional Information CHAR 20 0 QTXT20
DUMMY40 Text Line for Additional Information CHAR 40 0 QTXT40
QAUTH Authorization Group QM Master Data CHAR 8 0 TQ01D QMASTAUTH
TOLERANZSL Tolerance Key CHAR 4 0 TQ29 QTOLERANZ
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
MASSEINHSW Unit of Measurement in Which Quantitative Data Is Stored UNIT 3 0 T006 QMASSEH
SOLLWERT Target Value for a Quantitative Characteristic FLTP 16 16 QSOLLWERTE
SOLLWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZOB Upper Specification Limit FLTP 16 16 QTOLOB
TOLOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZUN Lower Specification Limit FLTP 16 16 QTOLUN
TOLUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASANZAHL Number of Value Classes for Inspection Results INT1 3 0 QKLASSZAHL
KLASBREITE Class Width FLTP 16 16 QKLASSBR
KLASBRNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASMITTE Class Midpoint FLTP 16 16 QKLASSMIT
KLASMINI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEOB1 First Upper Specification Limit FLTP 16 16 QGRENZOB1
GRENZOB1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN1 First Lower Specification Limit FLTP 16 16 QGRENZUN1
GRENZUN1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEOB2 Second Upper Specification Limit FLTP 16 16 QGRENZOB2
GRENZOB2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN2 Second Lower Specification Limit FLTP 16 16 QGRENZUN2
GRENZUN2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIOBEN Upper Plausibility Limit FLTP 16 16 QPLAUSIOB
PLAUSIOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIUNTE Lower Plausibility Limit FLTP 16 16 QPLAUSIUN
PLAUSIUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWEIOB Change to Upper Specification Limit FLTP 16 16 QTOLWOB
TOLWOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWEIUN Change to Lower Specification Limit FLTP 16 16 QTOLWUN
TOLWUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWAB Date from Which the Tolerance Change Is Valid DATS 8 0 QTOLWAB
TOLERWBIS Date Until Which the Tolerance Change Is Valid DATS 8 0 QTOLWBIS
CODEGR9U Defect Code Group for Rejection at Lower Tolerance CHAR 8 0 QPGR QCODEGRPU
CODE9U Defect Code for Rejection at Lower Specification Limit CHAR 4 0 QPCD QCODEU
CODEVR9U Version Number CHAR 6 0 QVERSNR
CODEGR9O Defect Code Group for Rejection at Upper Tolerance CHAR 8 0 QPGR QCODEGRPO
CODE9O Defect Code for Rejection at Upper Specification Limit CHAR 4 0 QPCD QCODEO
CODEVR9O Version Number CHAR 6 0 QVERSNR
ATINN Internal characteristic NUMC 10 0 ATINN
EEANTVERF Fraction Calculation CHAR 2 0 TQ72 QEANTVERF
CODEGRQUAL Defect Code Group for General Rejection CHAR 8 0 QPGR QCODEGRPQL
CODEQUAL Defect Code for Rejection: General CHAR 4 0 QPCD QCODEQL
INPPROC Parameters for Input Processing in QM Results Recording CHAR 3 0 TQ71 QINPPROC
SPEC_DET_RULE Specification Determination Rule CHAR 3 0 QASDRI_SPECDET QASDR_SPEC_DET_RULE
SPEC_DET_ACTIVE Active Indicator for Specification Determination Rule CHAR 1 0 QASDR_SDR_ACTIVE
PARAMETER1 Parameters for Specification Determination CHAR 16 0 QASDR_SDR_PARAMETER
PARAMETER2 Parameters for Specification Determination CHAR 16 0 QASDR_SDR_PARAMETER
DUMMY_QPMK_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QPMK foreign key relationships

Table Field Check Table Check Field
0 QPMK CODE9O QPCD Inspection catalog codes MANDT
0 QPMK CODE9O QPCD Inspection catalog codes KATALOGART
0 QPMK CODE9O QPCD Inspection catalog codes CODEGRUPPE
0 QPMK CODE9O QPCD Inspection catalog codes CODE
0 QPMK CODE9O QPCD Inspection catalog codes VERSION
1 QPMK CODE9U QPCD Inspection catalog codes MANDT
1 QPMK CODE9U QPCD Inspection catalog codes KATALOGART
1 QPMK CODE9U QPCD Inspection catalog codes CODEGRUPPE
1 QPMK CODE9U QPCD Inspection catalog codes CODE
1 QPMK CODE9U QPCD Inspection catalog codes VERSION
0 QPMK CODEGR9O QPGR Inspection catalog code groups MANDT
0 QPMK CODEGR9O QPGR Inspection catalog code groups KATALOGART
1 QPMK CODEGR9U QPGR Inspection catalog code groups MANDT
1 QPMK CODEGR9U QPGR Inspection catalog code groups KATALOGART
0 QPMK CODEGRQUAL QPGR Inspection catalog code groups MANDT
0 QPMK CODEGRQUAL QPGR Inspection catalog code groups KATALOGART
1 QPMK CODEQUAL QPCD Inspection catalog codes MANDT
1 QPMK CODEQUAL QPCD Inspection catalog codes KATALOGART
1 QPMK CODEQUAL QPCD Inspection catalog codes CODEGRUPPE
1 QPMK CODEQUAL QPCD Inspection catalog codes CODE
1 QPMK CODEQUAL QPCD Inspection catalog codes VERSION
0 QPMK EEANTVERF TQ72 Type of share calculation ANTVERF
1 QPMK INPPROC TQ71 Input Processing in Results Recording QM MANDT
1 QPMK INPPROC TQ71 Input Processing in Results Recording QM INPPROC
0 QPMK MASSEINHSW T006 Units of Measurement MANDT
1 QPMK MERKGEW TQ17A Characteristic weightings MANDT
0 QPMK PRFQL TQ11 Inspector qualification MANDT
1 QPMK QAUTH TQ01D Authorization groups for QM master data MANDT
0 QPMK TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics MANDT
0 QPMK TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics TOLERANZSL
1 QPMK WERKS T001W Plants/Branches MANDT
1 QPMK WERKS T001W Plants/Branches WERKS