SAP Table PLMK

Inspection plan characteristics

PLMK (Inspection plan characteristics) 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 PLMK to other SAP tables.

PLMK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PLNTY Task List Type PLNTY CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNKN Number of the task list node PLNKN NUMC 8 0
KZEINSTELL Characteristic Type QKZEINSTMK CHAR 1 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
GUELTIGAB Valid-From Date DATUV DATS 8 0
SERNV Technical status from TECHV CHAR 12 0
LOEKZ Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
PARKZ Indicator: inactive changes PARKZ CHAR 1 0
X Yes
NULL No
AENDERGNR Change Number AENNR CHAR 12 0
ERSTELLER User who created record ANNAM CHAR 12 0
ERSTELLDAT Date record created on ANDAT DATS 8 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDAT 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
QMTB_WERKS Plant for Inspection Method Q_METH_PLANT T001W CHAR 4 0
PMETHODE Inspection Method QPMETHODE QMTB CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
QPMK_REF Reference to Master Insp. Characteristic in Task List QKZ_REF CHAR 1 0
NULL Indicator is not set
X Indicator is set
QPMK_ZAEHL Plant for the Master Inspection Characteristic QZAEHLER CHAR 4 0
VERWMERKM Master Inspection Characteristics QMERKNR QPMK CHAR 8 0
MKVERSION Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 0
MKVERSDAT Key Date for Version Selection QVERSDAT DATS 8 0
MERKGEW Weighting of the Characteristic QMERKGEW TQ17A CHAR 2 0
PROBENR Partial Sample No. for Inspection Charac. in Task List QPROBEPL NUMC 3 0
PRUEFQUALI Inspector Qualification QPRQUALIF TQ11 CHAR 5 0
TOLERANZSL Tolerance Key QTOLERANZ TQ29 CHAR 4 0
KURZTEXT Short Text for Inspection Characteristic QTXT_CHA CHAR 40 0
LTEXTKZ Inspection Characteristic Long Text Exists QLTEXTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
LTEXTSPR Language Key SPRAS LANG 1 0
LTEXTEKZ Physical-Sample-Drawing Text Exists QKZPRZIEH CHAR 1 0
LTXTENTSPR Language Key SPRAS LANG 1 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
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF CHAR 8 0
FAKPLANME Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure QUMREN FLTP 16 16
FAKPROBME Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure QUMRENPME FLTP 16 16
PROBEMGEH Sample Unit of Measure QPROBME T006 UNIT 3 0
PRUEFEINH Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK DEC 5 2
DYNKRIT String for Dynamic Modification Criteria (Database Relevant) QDYNSTRING CHAR 10 0
FORMELSL Check and Calculate Formula in QM QFORMELSL CHAR 1 0
FORMEL1 Formula Field QFORMEL CHAR 60 0
FORMEL2 Formula Field QFORMEL CHAR 60 0
CODEGR9U Defect Code Group for Rejection at Lower Tolerance QCODEGRPU CHAR 8 0
CODE9U Defect Code for Rejection at Lower Specification Limit QCODEU CHAR 4 0
CODEVR9U Version Number QVERSNR CHAR 6 0
CODEGR9O Defect Code Group for Rejection at Upper Tolerance QCODEGRPO CHAR 8 0
CODE9O Defect Code for Rejection at Upper Specification Limit QCODEO CHAR 4 0
CODEVR9O Version Number QVERSNR CHAR 6 0
KATAB1 Catalog Entry Is a Selected Set QKTTAB CHAR 1 0
KATALGART1 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
AUSWMENGE1 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK1 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWVERS1 Version Number QVERSNR CHAR 6 0
AUSWDAT1 Key Date for Version Selection QVERSDAT DATS 8 0
KATAB2 Catalog Entry Is a Selected Set QKTTAB CHAR 1 0
KATALGART2 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
AUSWMENGE2 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK2 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWVERS2 Version Number QVERSNR CHAR 6 0
AUSWDAT2 Key Date for Version Selection QVERSDAT DATS 8 0
KATAB3 Catalog Entry Is a Selected Set QKTTAB CHAR 1 0
KATALGART3 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
AUSWMENGE3 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK3 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWVERS3 Version Number QVERSNR CHAR 6 0
AUSWDAT3 Key Date for Version Selection QVERSDAT DATS 8 0
KATAB4 Catalog Entry Is a Selected Set QKTTAB CHAR 1 0
KATALGART4 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
AUSWMENGE4 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK4 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWVERS4 Version Number QVERSNR CHAR 6 0
AUSWDAT4 Key Date for Version Selection QVERSDAT DATS 8 0
KATAB5 Catalog Entry Is a Selected Set QKTTAB CHAR 1 0
KATALGART5 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
AUSWMENGE5 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK5 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWVERS5 Version Number QVERSNR CHAR 6 0
AUSWDAT5 Key Date for Version Selection QVERSDAT DATS 8 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
CHARACT_ID1 Characteristic Description for Quality Data Exchange QCHARACT_ID1 CHAR 40 0
QERGDATH Planned Results Data Origin QERGDATHPL TQ73 CHAR 2 0
EEANTVERF Fraction Calculation QEANTVERF TQ72 CHAR 2 0
QDYNREGEL Dynamic Modification Rule QDYNREGEL QDDR CHAR 3 0
DYNMERKREF Characteristic (in Plan) whose Q-Level Will Be Copied QMERKDYN NUMC 4 0
PZLFH Assigned Test Equipment QPZLFH NUMC 8 0
CODEGRQUAL Defect Code Group for General Rejection QCODEGRPQL CHAR 8 0
CODEQUAL Defect Code for Rejection: General QCODEQL CHAR 4 0
SPCKRIT SPC Criterion QSPCKRIT QPSP CHAR 3 0
INPPROC Parameters for Input Processing in QM Results Recording QINPPROC TQ71 CHAR 3 0
RES_PLAN Response Plan QP_RESPLAN TQPC_RESPLAN CHAR 3 0
CTRMETH Control Method QP_CTRMETH TQPC_CTRMETH CHAR 3 0
CHAORIG Inspection Characteristic Origin QP_CHAORIG TQPC_CHAORIG CHAR 3 0
CHAORIG_GUID Reference to Characteristic That Was Adopted QP_CHAORIG_GUID RAW 16 0
NO_INSPECTION Do Not Copy Inspection Characteristic to Inspection Lot QP_NO_INSPECTION CHAR 1 0
NULL Indicator is not set
X Indicator is set
QP_CHAORIG_ID Original Identification for Characteristic QMIP_CHAORIG_ID CHAR 40 0

PLMK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PLMK AUSWMGWRK1 PLMK MANDT T001W Plants/Branches MANDT
PLMK AUSWMGWRK1 PLMK AUSWMGWRK1 T001W Plants/Branches WERKS
PLMK AUSWMGWRK2 PLMK MANDT T001W Plants/Branches MANDT
PLMK AUSWMGWRK2 PLMK AUSWMGWRK2 T001W Plants/Branches WERKS
PLMK AUSWMGWRK3 PLMK MANDT T001W Plants/Branches MANDT
PLMK AUSWMGWRK3 PLMK AUSWMGWRK3 T001W Plants/Branches WERKS
PLMK AUSWMGWRK4 PLMK MANDT T001W Plants/Branches MANDT
PLMK AUSWMGWRK4 PLMK AUSWMGWRK4 T001W Plants/Branches WERKS
PLMK AUSWMGWRK5 PLMK MANDT T001W Plants/Branches MANDT
PLMK AUSWMGWRK5 PLMK AUSWMGWRK5 T001W Plants/Branches WERKS
PLMK CHAORIG PLMK MANDT TQPC_CHAORIG Inspection-Characteristic Origin CLIENT
PLMK CHAORIG PLMK CHAORIG TQPC_CHAORIG Inspection-Characteristic Origin CHAORIG
PLMK CTRMETH PLMK CTRMETH TQPC_CTRMETH Control Methods CTRMETH
PLMK CTRMETH PLMK MANDT TQPC_CTRMETH Control Methods CLIENT
PLMK EEANTVERF PLMK MANDT TQ72 Type of share calculation MANDT
PLMK EEANTVERF PLMK EEANTVERF TQ72 Type of share calculation ANTVERF
PLMK INPPROC PLMK MANDT TQ71 Input Processing in Results Recording QM MANDT
PLMK INPPROC PLMK INPPROC TQ71 Input Processing in Results Recording QM INPPROC
PLMK KATALGART1 PLMK MANDT TQ15 Inspection catalog type index MANDT
PLMK KATALGART1 PLMK KATALGART1 TQ15 Inspection catalog type index KATALOGART
PLMK KATALGART2 PLMK MANDT TQ15 Inspection catalog type index MANDT
PLMK KATALGART2 PLMK KATALGART2 TQ15 Inspection catalog type index KATALOGART
PLMK KATALGART3 PLMK MANDT TQ15 Inspection catalog type index MANDT
PLMK KATALGART3 PLMK KATALGART3 TQ15 Inspection catalog type index KATALOGART
PLMK KATALGART4 PLMK KATALGART4 TQ15 Inspection catalog type index KATALOGART
PLMK KATALGART4 PLMK MANDT TQ15 Inspection catalog type index MANDT
PLMK KATALGART5 PLMK MANDT TQ15 Inspection catalog type index MANDT
PLMK KATALGART5 PLMK KATALGART5 TQ15 Inspection catalog type index KATALOGART
PLMK MASSEINHSW PLMK MANDT T006 Units of Measurement MANDT
PLMK MASSEINHSW PLMK MASSEINHSW T006 Units of Measurement MSEHI
PLMK MERKGEW PLMK MANDT TQ17A Characteristic weightings MANDT
PLMK MERKGEW PLMK MERKGEW TQ17A Characteristic weightings MERKKLASSE
PLMK PMETHODE PLMK MANDT QMTB Inspection method master record MANDT
PLMK PMETHODE PLMK QMTB_WERKS QMTB Inspection method master record WERKS
PLMK PMETHODE PLMK PMETHODE QMTB Inspection method master record PMTNR
PLMK PMETHODE PLMK PMTVERSION QMTB Inspection method master record VERSION
PLMK PROBEMGEH PLMK MANDT T006 Units of Measurement MANDT
PLMK PROBEMGEH PLMK PROBEMGEH T006 Units of Measurement MSEHI
PLMK PRUEFQUALI PLMK MANDT TQ11 Inspector qualification MANDT
PLMK PRUEFQUALI PLMK PRUEFQUALI TQ11 Inspector qualification PRFQL
PLMK QDYNREGEL PLMK MANDT QDDR Dynamic modification rule (header) MANDT
PLMK QDYNREGEL PLMK QDYNREGEL QDDR Dynamic modification rule (header) DYNREGEL
PLMK QERGDATH PLMK MANDT TQ73 Origin of results data MANDT
PLMK QERGDATH PLMK QERGDATH TQ73 Origin of results data QERGDATH
PLMK QMTB_WERKS PLMK QMTB_WERKS T001W Plants/Branches WERKS
PLMK QMTB_WERKS PLMK MANDT T001W Plants/Branches MANDT
PLMK RES_PLAN PLMK MANDT TQPC_RESPLAN Response Plans CLIENT
PLMK RES_PLAN PLMK RES_PLAN TQPC_RESPLAN Response Plans RES_PLAN
PLMK SPCKRIT PLMK MANDT QPSP SPC criterion MANDT
PLMK SPCKRIT PLMK SPCKRIT QPSP SPC criterion SPCKRIT
PLMK TOLERANZSL PLMK MANDT TQ29 Defaults for target value and tolerances for characteristics MANDT
PLMK TOLERANZSL PLMK TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics TOLERANZSL
PLMK VERWMERKM PLMK QPMK_ZAEHL QPMK Inspection characteristic master ZAEHLER
PLMK VERWMERKM PLMK VERWMERKM QPMK Inspection characteristic master MKMNR
PLMK VERWMERKM PLMK MKVERSION QPMK Inspection characteristic master VERSION
PLMK VERWMERKM PLMK MANDT QPMK Inspection characteristic master MANDT
PLMK ZZMKEINH SYST MANDT TCURC Currency Codes MANDT
PLMK ZZMKEINH PLMK ZZMKEINH TCURC Currency Codes WAERS