PLMK SAP (Inspection plan characteristics) Table details
Dictionary Type: Table
Description: Inspection plan characteristics
Description: Inspection plan characteristics
Table field list including key, data, relationships and ABAP select examples
PLMK is a standard SAP Table which is used to store Inspection plan characteristics data and is available within R/3 SAP systems depending on the version and release level.
The PLMK table consists of various fields, each holding specific information or linking keys about Inspection plan characteristics data available in SAP. These include PLNTY (Task List Type), PLNNR (Key for Task List Group), PLNKN (Number of the task list node), KZEINSTELL (Characteristic Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PLMK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PLNTY | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
KZEINSTELL | Characteristic Type | QKZEINSTMK | CHAR | 1 | QKZEINSTMK | ||||
MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
SERNV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1 | XFELD | ||||
AENDERGNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
ERSTELLER | User who created record | ANNAM | CHAR | 12 | USNAM | ||||
ERSTELLDAT | Date record created on | ANDAT | DATS | 8 | DATUM | ||||
AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
STEUERKZ | Cntrl Indicator String for Insp. Char./Master Insp. Char. | QMKCONTROL | CHAR | 30 | QMKCONTROL | ||||
QMTB_WERKS | Plant for Inspection Method | Q_METH_PLANT | CHAR | 4 | T001W | WERKS | WRK | H_T001W | |
PMETHODE | Inspection Method | QPMETHODE | CHAR | 8 | QMTB | ALPHA | QPMETHODE | PMT | |
PMTVERSION | Version Number of the Inspection Method | QVERSNRPM | CHAR | 6 | ALPHA | QVERSNR | |||
QPMK_REF | Reference to Master Insp. Characteristic in Task List | QKZ_REF | CHAR | 1 | QKZ | ||||
QPMK_ZAEHL | Plant for the Master Inspection Characteristic | QZAEHLER | CHAR | 4 | QZAEHLER | WRK | |||
VERWMERKM | Master Inspection Characteristics | QMERKNR | CHAR | 8 | QPMK | ALPHA | QMERKNR | PMK | |
MKVERSION | Version Number of the Master Inspection Characteristic | QVERSNRMK | CHAR | 6 | ALPHA | QVERSNR | |||
MKVERSDAT | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
MERKGEW | Weighting of the Characteristic | QMERKGEW | CHAR | 2 | TQ17A | QMERKKLAS | |||
PROBENR | Partial Sample No. for Inspection Charac. in Task List | QPROBEPL | NUMC | 3 | QPROBEPL | ||||
PRUEFQUALI | Inspector Qualification | QPRQUALIF | CHAR | 5 | TQ11 | QPRQUALIF | |||
TOLERANZSL | Tolerance Key | QTOLERANZ | CHAR | 4 | TQ29 | QTOLERANZ | |||
KURZTEXT | Short Text for Inspection Characteristic | QTXT_CHA | CHAR | 40 | QKURZTEXT | ||||
LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 1 | QKZ | ||||
LTEXTSPR | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
LTEXTEKZ | Physical-Sample-Drawing Text Exists | QKZPRZIEH | CHAR | 1 | QKZWSP | ||||
LTXTENTSPR | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
STELLEN | Number of Places to the Right of a Decimal Point (Accuracy) | QSTELLEN | INT1 | 3 | QSTELLEN | ||||
MASSEINHSW | Unit of Measurement, in Which Quantitative Data Is Stored | QMASSEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOLLWERT | Target Value for a Quantitative Characteristic | QSOLLWERTE | FLTP | 16(16) | QSOLLWERTE | ||||
SOLLWNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
TOLERANZOB | Upper Specification Limit | QTOLOB | FLTP | 16(16) | QSOLLWERTE | ||||
TOLOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
TOLERANZUN | Lower Tolerance Limit | QTOLUN | FLTP | 16(16) | QSOLLWERTE | ||||
TOLUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
KLASANZAHL | Number of Value Classes for Inspection Results | QKLASSZAHL | INT1 | 3 | QKLASSZAHL | ||||
KLASBREITE | Class Width | QKLASSBR | FLTP | 16(16) | QSOLLWERTE | ||||
KLASBRNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
KLASMITTE | Class Midpoint | QKLASSMIT | FLTP | 16(16) | QSOLLWERTE | ||||
KLASMINI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
GRENZEOB1 | First Upper Specification Limit | QGRENZOB1 | FLTP | 16(16) | QSOLLWERTE | ||||
GRENZOB1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
GRENZEUN1 | First Lower Specification Limit | QGRENZUN1 | FLTP | 16(16) | QSOLLWERTE | ||||
GRENZUN1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
GRENZEOB2 | Second Upper Specification Limit | QGRENZOB2 | FLTP | 16(16) | QSOLLWERTE | ||||
GRENZOB2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
GRENZEUN2 | Second Lower Specification Limit | QGRENZUN2 | FLTP | 16(16) | QSOLLWERTE | ||||
GRENZUN2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
PLAUSIOBEN | Upper Plausibility Limit | QPLAUSIOB | FLTP | 16(16) | QSOLLWERTE | ||||
PLAUSIOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
PLAUSIUNTE | Lower Plausibility Limit | QPLAUSIUN | FLTP | 16(16) | QSOLLWERTE | ||||
PLAUSIUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
TOLERWEIOB | Change to Upper Specification Limit | QTOLWOB | FLTP | 16(16) | QSOLLWERTE | ||||
TOLWOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
TOLERWEIUN | Change to Lower Specification Limit | QTOLWUN | FLTP | 16(16) | QSOLLWERTE | ||||
TOLWUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
TOLERWAB | Date from Which the Tolerance Change Is Valid | QTOLWAB | DATS | 8 | DATUM | ||||
TOLERWBIS | Date Until Which the Tolerance Change Is Valid | QTOLWBIS | DATS | 8 | DATUM | ||||
STICHPRVER | Sampling Procedure in Inspection Characteristic | QSTICHVERF | CHAR | 8 | Assigned to domain | QSTPRVER | |||
FAKPLANME | Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure | QUMREN | FLTP | 16(16) | QUMRENFAK | ||||
FAKPROBME | Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure | QUMRENPME | FLTP | 16(16) | QUMRENFAK | ||||
PROBEMGEH | Sample Unit of Measure | QPROBME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRUEFEINH | Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) | QPROBEFAK | DEC | 5(2) | QPROBEFAK | ||||
DYNKRIT | String for Dynamic Modification Criteria (Database Relevant) | QDYNSTRING | CHAR | 10 | QDYNSTRING | ||||
FORMELSL | Check and Calculate Formula in QM | QFORMELSL | CHAR | 1 | QFORMELSL | ||||
FORMEL1 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
FORMEL2 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
CODEGR9U | Defect Code Group for Rejection at Lower Tolerance | QCODEGRPU | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE9U | Defect Code for Rejection at Lower Specification Limit | QCODEU | CHAR | 4 | Assigned to domain | QCODE | |||
CODEVR9U | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
CODEGR9O | Defect Code Group for Rejection at Upper Tolerance | QCODEGRPO | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE9O | Defect Code for Rejection at Upper Specification Limit | QCODEO | CHAR | 4 | Assigned to domain | QCODE | |||
CODEVR9O | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
KATAB1 | Catalog Entry Is a Selected Set | QKTTAB | CHAR | 1 | QKTTAB | ||||
KATALGART1 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
AUSWMENGE1 | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8 | QCGRAUSW | ||||
AUSWMGWRK1 | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4 | T001W | WERKS | WRK | ||
AUSWVERS1 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
AUSWDAT1 | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
KATAB2 | Catalog Entry Is a Selected Set | QKTTAB | CHAR | 1 | QKTTAB | ||||
KATALGART2 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
AUSWMENGE2 | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8 | QCGRAUSW | ||||
AUSWMGWRK2 | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4 | T001W | WERKS | WRK | ||
AUSWVERS2 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
AUSWDAT2 | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
KATAB3 | Catalog Entry Is a Selected Set | QKTTAB | CHAR | 1 | QKTTAB | ||||
KATALGART3 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
AUSWMENGE3 | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8 | QCGRAUSW | ||||
AUSWMGWRK3 | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4 | T001W | WERKS | WRK | ||
AUSWVERS3 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
AUSWDAT3 | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
KATAB4 | Catalog Entry Is a Selected Set | QKTTAB | CHAR | 1 | QKTTAB | ||||
KATALGART4 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
AUSWMENGE4 | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8 | QCGRAUSW | ||||
AUSWMGWRK4 | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4 | T001W | WERKS | WRK | ||
AUSWVERS4 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
AUSWDAT4 | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
KATAB5 | Catalog Entry Is a Selected Set | QKTTAB | CHAR | 1 | QKTTAB | ||||
KATALGART5 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
AUSWMENGE5 | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8 | QCGRAUSW | ||||
AUSWMGWRK5 | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4 | T001W | WERKS | WRK | ||
AUSWVERS5 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
AUSWDAT5 | Key Date for Version Selection | QVERSDAT | DATS | 8 | DATUM | ||||
DUMMY10 | Text Line for Additional Information | QTXT10 | CHAR | 10 | QTXT10 | ||||
DUMMY20 | Text Line for Additional Information | QTXT20 | CHAR | 20 | QTXT20 | ||||
DUMMY40 | Text Line for Additional Information | QTXT40 | CHAR | 40 | QTXT40 | ||||
CHARACT_ID1 | Characteristic Description for Quality Data Exchange | QCHARACT_ID1 | CHAR | 40 | ALPHA | QCHARACT_ID | |||
QERGDATH | Planned Results Data Origin | QERGDATHPL | CHAR | 2 | TQ73 | QERGDATH | |||
EEANTVERF | Fraction Calculation | QEANTVERF | CHAR | 2 | TQ72 | QEANTVERF | |||
QDYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3 | QDDR | QDYNREGEL | QDR | ||
DYNMERKREF | Characteristic (in Plan) whose Q-Level Will Be Copied | QMERKDYN | NUMC | 4 | QMERKNRP | ||||
PZLFH | Assigned Test Equipment | QPZLFH | NUMC | 8 | PZLFH | ||||
CODEGRQUAL | Defect Code Group for General Rejection | QCODEGRPQL | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODEQUAL | Defect Code for Rejection: General | QCODEQL | CHAR | 4 | Assigned to domain | QCODE | |||
SPCKRIT | SPC Criterion | QSPCKRIT | CHAR | 3 | QPSP | QSPCKRIT | |||
INPPROC | Parameters for Input Processing in QM Results Recording | QINPPROC | CHAR | 3 | TQ71 | CHAR3 | |||
RES_PLAN | Response Plan | QP_RESPLAN | CHAR | 3 | TQPC_RESPLAN | ALPHA | QP_RESPLAN | ||
CTRMETH | Control Method | QP_CTRMETH | CHAR | 3 | TQPC_CTRMETH | ALPHA | QP_CTRMETH | ||
CHAORIG | Inspection Characteristic Origin | QP_CHAORIG | CHAR | 3 | TQPC_CHAORIG | ALPHA | QP_CHAORIG | Q_IP_CHAORIG | |
CHAORIG_GUID | Reference to Characteristic That Was Adopted | QP_CHAORIG_GUID | RAW | 16 | PLMAM | PLM_AUDIT_GUID_AUD | |||
NO_INSPECTION | Do Not Copy Inspection Characteristic to Inspection Lot | QP_NO_INSPECTION | CHAR | 1 | QKZ | ||||
QP_CHAORIG_ID | Original Identification for Characteristic | QMIP_CHAORIG_ID | CHAR | 40 | QMIP_CHAORIG_ID |
Key field | Non-key field |
How do I retrieve data from SAP table PLMK using ABAP code
The following ABAP code Example will allow you to do a basic selection on PLMK to SELECT all data from the tableDATA: WA_PLMK TYPE PLMK.
SELECT SINGLE *
FROM PLMK
INTO CORRESPONDING FIELDS OF WA_PLMK
WHERE...
How to access SAP table PLMK
Within an ECC or HANA version of SAP you can also view further information about PLMK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects