SAP table PLMK (Inspection plan characteristics)

SAP table PLMK has 7 primary key fields being MANDT,PLNTY,PLNNR,PLNKN,KZEINSTELL,MERKNR,ZAEHL.

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

PLMK foreign key relationships

Table Field Check Table Check Field
0 PLMK AUSWMGWRK1 T001W Plants/Branches MANDT
0 PLMK AUSWMGWRK1 T001W Plants/Branches WERKS
1 PLMK AUSWMGWRK2 T001W Plants/Branches MANDT
1 PLMK AUSWMGWRK2 T001W Plants/Branches WERKS
0 PLMK AUSWMGWRK3 T001W Plants/Branches MANDT
0 PLMK AUSWMGWRK3 T001W Plants/Branches WERKS
1 PLMK AUSWMGWRK4 T001W Plants/Branches MANDT
1 PLMK AUSWMGWRK4 T001W Plants/Branches WERKS
0 PLMK AUSWMGWRK5 T001W Plants/Branches MANDT
0 PLMK AUSWMGWRK5 T001W Plants/Branches WERKS
1 PLMK EEANTVERF TQ72 Type of share calculation ANTVERF
0 PLMK INPPROC TQ71 Input Processing in Results Recording QM MANDT
0 PLMK INPPROC TQ71 Input Processing in Results Recording QM INPPROC
1 PLMK KATALGART1 TQ15 Inspection catalog type index KATALOGART
0 PLMK KATALGART2 TQ15 Inspection catalog type index KATALOGART
1 PLMK KATALGART3 TQ15 Inspection catalog type index KATALOGART
0 PLMK KATALGART4 TQ15 Inspection catalog type index KATALOGART
1 PLMK KATALGART5 TQ15 Inspection catalog type index KATALOGART
0 PLMK MASSEINHSW T006 Units of Measurement MANDT
1 PLMK MERKGEW TQ17A Characteristic weightings MANDT
0 PLMK PMETHODE QMTB Inspection method master record MANDT
0 PLMK PMETHODE QMTB Inspection method master record WERKS
0 PLMK PMETHODE QMTB Inspection method master record VERSION
1 PLMK PROBEMGEH T006 Units of Measurement MANDT
0 PLMK PRUEFQUALI TQ11 Inspector qualification MANDT
1 PLMK QDYNREGEL QDDR Dynamic modification rule (header) MANDT
0 PLMK QERGDATH TQ73 Origin of results data MANDT
0 PLMK QERGDATH TQ73 Origin of results data QERGDATH
1 PLMK QMTB_WERKS T001W Plants/Branches MANDT
1 PLMK QMTB_WERKS T001W Plants/Branches WERKS
0 PLMK SPCKRIT QPSP SPC criterion MANDT
0 PLMK SPCKRIT QPSP SPC criterion SPCKRIT
1 PLMK TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics MANDT
1 PLMK TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics TOLERANZSL
0 PLMK VERWMERKM QPMK Inspection characteristic master MANDT
0 PLMK VERWMERKM QPMK Inspection characteristic master ZAEHLER
0 PLMK VERWMERKM QPMK Inspection characteristic master VERSION