QAMV SAP (Characteristic specifications for inspection processing) Table details
Description: Characteristic specifications for inspection processing
Table field list including key, data, relationships and ABAP select examples
QAMV is a standard SAP Table which is used to store Characteristic specifications for inspection processing data and is available within R/3 SAP systems depending on the version and release level.
The QAMV table consists of various fields, each holding specific information or linking keys about Characteristic specifications for inspection processing data available in SAP. These include PRUEFLOS (Inspection Lot Number), VORGLFNR (Current Node Number from Order Counter APLZL), MERKNR (Inspection Characteristic Number), ERSTELLER (Name of User Who Created the Data Record).. 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 QAMV 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 |
MANDANT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
VORGLFNR | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
ERSTELLDAT | Date on Which the Data Record Was Created | QDATUMERST | 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 | ||||
PHYSPROBE | Number of the Partial Sample | QPHYSPROBE | NUMC | 6 | Assigned to domain | QPROBENR | |||
SATZSTATUS | Specification Record Status | QSTATUS | CHAR | 1 | TQ76 | QSTATUS | |||
STEUERKZ | Cntrl Indicator String for Insp. Char./Master Insp. Char. | QMKCONTROL | CHAR | 30 | QMKCONTROL | ||||
TSTICHPRKZ | Partial Samples Possible | QTSTICHPRO | CHAR | 1 | QKZUMFS | ||||
NOINPUTKZ | Results Are Calculated Internally | QNOINPUT | CHAR | 1 | QKZ | ||||
NIPLANMKKZ | Unplanned Characteristic | QNIPLANMK | CHAR | 1 | QKZ | ||||
AKTPPKT | Use of Unplanned Characteristics (Inspection Pt. Processing) | QAKTPPKT | CHAR | 1 | QAKTPPKT | ||||
PPKTUNGEMK | Unplanned Characteristic Was Created with this Sample No. | QPKTUNGEMK | NUMC | 6 | QASV | QPROBENR | |||
QMTB_WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PMETHODE | Inspection Method | QPMETHODE | CHAR | 8 | QMTB | ALPHA | QPMETHODE | PMT | |
PMTVERSION | Version Number of the Inspection Method | QVERSNRPM | CHAR | 6 | ALPHA | QVERSNR | |||
ATINN | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
ABW_CODES | Deviating Valuation of Codes | QABW_CODES | CHAR | 1 | QKZ | ||||
QPMK_REF | Type of Master Insp. Characteristic Ref. Results Recording | QKZ_REF_EE | CHAR | 1 | QKZ_REF_EE | ||||
QPMK_WERKS | 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 | |||
MERKGEW | Weighting of the Characteristic | QMERKGEW | CHAR | 2 | TQ17A | QMERKKLAS | |||
KURZTEXT | Short Text for the Inspection Characteristic | QMKKURZTXT | CHAR | 40 | QKURZTEXT | ||||
LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 1 | QKZ | ||||
LTEXTSPR | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
LTEXTEKZ | Physical-Sample-Drawing Text Exists | QKZPRZIEH | CHAR | 1 | QKZWSP | ||||
LTXTENTSPR | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
PRUEFQUALI | Inspector Qualification | QPRQUALIF | CHAR | 5 | TQ11 | QPRQUALIF | |||
FORMEL1 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
FORMEL2 | Formula Field | QFORMEL | CHAR | 60 | QFORMEL | ||||
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 | ||||
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 | ||||
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 | ||||
TOLERWKZ | Tolerance Change Is Active | QTOLERWKZ | 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 | ||||
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 | ||||
PRZIEHVERF | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8 | QPRVP | QPRZIEHVER | QPV | ||
VERSION | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6 | ALPHA | QVERSNR | |||
POSNRPRZV | Item Number in Sample-Drawing Procedure | QZAEHLPRZV | NUMC | 4 | NUM4 | ||||
LOSGEBEH | Lot Container | QGEBEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
PROBNRPL | Highest Partial Sample No. Valid for Instruction | QPROBNRBIS | NUMC | 3 | QPROBEPL | ||||
STICHPRVER | Sampling Procedure in Inspection Characteristic | QSTICHVERF | CHAR | 8 | QDSV | 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 | ||||
ANTVERF | Fraction Calculation | QEANTVERF | CHAR | 2 | TQ72 | QEANTVERF | |||
BEWREGEL | Valuation Rule | QBEWERT | CHAR | 2 | QDFM | QKEY1 | |||
PROBMGFAK | Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) | QPROBEFAK | DEC | 5(2) | QPROBEFAK | ||||
PROBEMGEH | Sample Unit of Measure | QPROBME | UNIT | 3 | T006 | CUNIT | MEINS | ||
SOLLSTPUMF | Sample Size that Has to Be Inspected for a Characteristic | QGESUMF | INT4 | 10 | QANZAHL4 | ||||
PRUEFUMF | Quantity to Be Inspected | QPRUEFUMF | QUAN | 13(3) | QMENGEPLOS | ||||
MENGENEINH | Base Unit of Measure for the Sample Unit | QPROBEMGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
HPZ | 100% Inspection | QHPZ | CHAR | 1 | QKZ | ||||
SOLLSTPANZ | Number of Planned Partial Samples | QSOSTPANZ | INT2 | 5 | QANZAHL2 | ||||
ANTEILKZ | Take Share Estimate into Account | QANTEILKZ | CHAR | 1 | QKZ | ||||
RUECKMELNR | Confirmation Number for Inspection Characteristic | QRUECKNR | NUMC | 8 | QRUECKNR | QRU | |||
KZEINSTELL | Characteristic Type | QKZEINSTMK | CHAR | 1 | QKZEINSTMK | ||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
QDYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3 | QDDR | QDYNREGEL | QDR | ||
KZDYNAUT | Time of Dynamic Modification in Inspection Lot | QDYNTIME | CHAR | 1 | QDYNTIME | ||||
DYNKRIT | String for Dynamic Modification Criteria (Database Relevant) | QDYNSTRING | CHAR | 10 | QDYNSTRING | ||||
DYNMERKREF | Characteristic (in Plan) whose Q-Level Will Be Copied | QMERKDYN | NUMC | 4 | QMERKNRP | ||||
KZDYNR | Dynamic Modification Rule Available | QKZDYNR | CHAR | 1 | QKZ | ||||
ZAEHLERQL | Sequential Counter for Different Quality Levels | QZAEHLERQL | INT4 | 10 | QDYNANZ4 | ||||
FORMELSL | Check and Calculate Formula in QM | QFORMELSL | CHAR | 1 | QFORMELSL | ||||
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 | |||
KZRAST | Indicator: Sampling Procedure for Inspection Points | QKZRAST | CHAR | 1 | QKZRAST | ||||
RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | QRASTER | NUMC | 3 | QRASTER | ||||
PPANZPRUE | Number of Insp. Point Inspections Without Characteristic | QPPANZPRUE | INT4 | 10 | QDYNANZ4 | ||||
SPCKRIT | SPC Criterion | QSPCKRIT | CHAR | 3 | QPSP | QSPCKRIT | |||
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 | |||
INPPROC | Parameters for Input Processing in QM Results Recording | QINPPROC | CHAR | 3 | CHAR3 |
Key field | Non-key field |
How do I retrieve data from SAP table QAMV using ABAP code
The following ABAP code Example will allow you to do a basic selection on QAMV to SELECT all data from the tableDATA: WA_QAMV TYPE QAMV.
SELECT SINGLE *
FROM QAMV
INTO CORRESPONDING FIELDS OF WA_QAMV
WHERE...
How to access SAP table QAMV
Within an ECC or HANA version of SAP you can also view further information about QAMV 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