QAMV SAP (Characteristic specifications for inspection processing) Table details

Dictionary Type: Table
Description: Characteristic specifications for inspection processing




ABAP Code to SELECT data from QAMV
Related tables to QAMV
Access table QAMV




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
MANDANTClient MANDTCLNT3T000MANDT
PRUEFLOSInspection Lot Number QPLOSNUMC12QALSQPLOSQLSQALS
VORGLFNRCurrent Node Number from Order Counter APLZL QLFNKNNUMC8KNTNR
MERKNRInspection Characteristic Number QMERKNRPNUMC4QMERKNRP
ERSTELLERName of User Who Created the Data Record QERSTELLERCHAR12QAENDERER
ERSTELLDATDate on Which the Data Record Was Created QDATUMERSTDATS8DATUM
AENDERERName of User who Most Recently Changed the Data Record QAENDERERCHAR12QAENDERER
AENDERDATDate on Which Data Record Was Changed QDATUMAENDDATS8DATUM
PHYSPROBENumber of the Partial Sample QPHYSPROBENUMC6Assigned to domainQPROBENR
SATZSTATUSSpecification Record Status QSTATUSCHAR1TQ76QSTATUS
STEUERKZCntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROLCHAR30QMKCONTROL
TSTICHPRKZPartial Samples Possible QTSTICHPROCHAR1QKZUMFS
NOINPUTKZResults Are Calculated Internally QNOINPUTCHAR1QKZ
NIPLANMKKZUnplanned Characteristic QNIPLANMKCHAR1QKZ
AKTPPKTUse of Unplanned Characteristics (Inspection Pt. Processing) QAKTPPKTCHAR1QAKTPPKT
PPKTUNGEMKUnplanned Characteristic Was Created with this Sample No. QPKTUNGEMKNUMC6QASVQPROBENR
QMTB_WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PMETHODEInspection Method QPMETHODECHAR8QMTBALPHAQPMETHODEPMT
PMTVERSIONVersion Number of the Inspection Method QVERSNRPMCHAR6ALPHAQVERSNR
ATINNInternal characteristic ATINNNUMC10Assigned to domainATINNATINN
ABW_CODESDeviating Valuation of Codes QABW_CODESCHAR1QKZ
QPMK_REFType of Master Insp. Characteristic Ref. Results Recording QKZ_REF_EECHAR1QKZ_REF_EE
QPMK_WERKSPlant for the Master Inspection Characteristic QZAEHLERCHAR4QZAEHLERWRK
VERWMERKMMaster Inspection Characteristics QMERKNRCHAR8QPMKALPHAQMERKNRPMK
MKVERSIONVersion Number of the Master Inspection Characteristic QVERSNRMKCHAR6ALPHAQVERSNR
MERKGEWWeighting of the Characteristic QMERKGEWCHAR2TQ17AQMERKKLAS
KURZTEXTShort Text for the Inspection Characteristic QMKKURZTXTCHAR40QKURZTEXT
LTEXTKZInspection Characteristic Long Text Exists QLTEXTKZCHAR1QKZ
LTEXTSPRLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
LTEXTEKZPhysical-Sample-Drawing Text Exists QKZPRZIEHCHAR1QKZWSP
LTXTENTSPRLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
PRUEFQUALIInspector Qualification QPRQUALIFCHAR5TQ11QPRQUALIF
FORMEL1Formula Field QFORMELCHAR60QFORMEL
FORMEL2Formula Field QFORMELCHAR60QFORMEL
DUMMY10Text Line for Additional Information QTXT10CHAR10QTXT10
DUMMY20Text Line for Additional Information QTXT20CHAR20QTXT20
DUMMY40Text Line for Additional Information QTXT40CHAR40QTXT40
CODEGR9UDefect Code Group for Rejection at Lower Tolerance QCODEGRPUCHAR8Assigned to domainQCODEGRPCGP
CODE9UDefect Code for Rejection at Lower Specification Limit QCODEUCHAR4Assigned to domainQCODE
CODEVR9UVersion Number QVERSNRCHAR6ALPHAQVERSNR
CODEGR9ODefect Code Group for Rejection at Upper Tolerance QCODEGRPOCHAR8Assigned to domainQCODEGRPCGP
CODE9ODefect Code for Rejection at Upper Specification Limit QCODEOCHAR4Assigned to domainQCODE
CODEVR9OVersion Number QVERSNRCHAR6ALPHAQVERSNR
KATAB1Catalog Entry Is a Selected Set QKTTABCHAR1QKTTAB
KATALGART1Catalog Type of Assigned Code Group or Selected Set QKATAUSWCHAR1TQ15QKATARTQKT
AUSWMENGE1Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK1Plant of the Assigned Selected Set QWERKAUSWCHAR4T001WWERKSWRK
AUSWVERS1Version Number QVERSNRCHAR6ALPHAQVERSNR
AUSWDAT1Key Date for Version Selection QVERSDATDATS8DATUM
KATAB2Catalog Entry Is a Selected Set QKTTABCHAR1QKTTAB
KATALGART2Catalog Type of Assigned Code Group or Selected Set QKATAUSWCHAR1TQ15QKATARTQKT
AUSWMENGE2Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK2Plant of the Assigned Selected Set QWERKAUSWCHAR4T001WWERKSWRK
AUSWVERS2Version Number QVERSNRCHAR6ALPHAQVERSNR
AUSWDAT2Key Date for Version Selection QVERSDATDATS8DATUM
KATAB3Catalog Entry Is a Selected Set QKTTABCHAR1QKTTAB
KATALGART3Catalog Type of Assigned Code Group or Selected Set QKATAUSWCHAR1TQ15QKATARTQKT
AUSWMENGE3Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK3Plant of the Assigned Selected Set QWERKAUSWCHAR4T001WWERKSWRK
AUSWVERS3Version Number QVERSNRCHAR6ALPHAQVERSNR
AUSWDAT3Key Date for Version Selection QVERSDATDATS8DATUM
KATAB4Catalog Entry Is a Selected Set QKTTABCHAR1QKTTAB
KATALGART4Catalog Type of Assigned Code Group or Selected Set QKATAUSWCHAR1TQ15QKATARTQKT
AUSWMENGE4Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK4Plant of the Assigned Selected Set QWERKAUSWCHAR4T001WWERKSWRK
AUSWVERS4Version Number QVERSNRCHAR6ALPHAQVERSNR
AUSWDAT4Key Date for Version Selection QVERSDATDATS8DATUM
KATAB5Catalog Entry Is a Selected Set QKTTABCHAR1QKTTAB
KATALGART5Catalog Type of Assigned Code Group or Selected Set QKATAUSWCHAR1TQ15QKATARTQKT
AUSWMENGE5Assigned Code Group or Selected Set QCGRAUSWCHAR8QCGRAUSW
AUSWMGWRK5Plant of the Assigned Selected Set QWERKAUSWCHAR4T001WWERKSWRK
AUSWVERS5Version Number QVERSNRCHAR6ALPHAQVERSNR
AUSWDAT5Key Date for Version Selection QVERSDATDATS8DATUM
STELLENNumber of Places to the Right of a Decimal Point (Accuracy) QSTELLENINT13QSTELLEN
MASSEINHSWUnit of Measurement, in Which Quantitative Data Is Stored QMASSEHUNIT3T006CUNITMEINS
SOLLWERTTarget Value for a Quantitative Characteristic QSOLLWERTEFLTP16(16) QSOLLWERTE
SOLLWNIValue Not Initial if Set QNINITIALCHAR1QKZ
TOLERANZOBUpper Specification Limit QTOLOBFLTP16(16) QSOLLWERTE
TOLOBNIValue Not Initial if Set QNINITIALCHAR1QKZ
TOLERANZUNLower Tolerance Limit QTOLUNFLTP16(16) QSOLLWERTE
TOLUNNIValue Not Initial if Set QNINITIALCHAR1QKZ
TOLERWKZTolerance Change Is Active QTOLERWKZCHAR1QKZ
GRENZEOB1First Upper Specification Limit QGRENZOB1FLTP16(16) QSOLLWERTE
GRENZOB1NIValue Not Initial if Set QNINITIALCHAR1QKZ
GRENZEUN1First Lower Specification Limit QGRENZUN1FLTP16(16) QSOLLWERTE
GRENZUN1NIValue Not Initial if Set QNINITIALCHAR1QKZ
GRENZEOB2Second Upper Specification Limit QGRENZOB2FLTP16(16) QSOLLWERTE
GRENZOB2NIValue Not Initial if Set QNINITIALCHAR1QKZ
GRENZEUN2Second Lower Specification Limit QGRENZUN2FLTP16(16) QSOLLWERTE
GRENZUN2NIValue Not Initial if Set QNINITIALCHAR1QKZ
PLAUSIOBENUpper Plausibility Limit QPLAUSIOBFLTP16(16) QSOLLWERTE
PLAUSIOBNIValue Not Initial if Set QNINITIALCHAR1QKZ
PLAUSIUNTELower Plausibility Limit QPLAUSIUNFLTP16(16) QSOLLWERTE
PLAUSIUNNIValue Not Initial if Set QNINITIALCHAR1QKZ
KLASANZAHLNumber of Value Classes for Inspection Results QKLASSZAHLINT13QKLASSZAHL
KLASBREITEClass Width QKLASSBRFLTP16(16) QSOLLWERTE
KLASBRNIValue Not Initial if Set QNINITIALCHAR1QKZ
KLASMITTEClass Midpoint QKLASSMITFLTP16(16) QSOLLWERTE
KLASMINIValue Not Initial if Set QNINITIALCHAR1QKZ
PRZIEHVERFSample-Drawing Procedure QPRZIEHVERCHAR8QPRVPQPRZIEHVERQPV
VERSIONVersion No. of the Sample-Drawing Procedure QVERSNPRZVCHAR6ALPHAQVERSNR
POSNRPRZVItem Number in Sample-Drawing Procedure QZAEHLPRZVNUMC4NUM4
LOSGEBEHLot Container QGEBEHUNIT3T006CUNITMEINS
PROBNRPLHighest Partial Sample No. Valid for Instruction QPROBNRBISNUMC3QPROBEPL
STICHPRVERSampling Procedure in Inspection Characteristic QSTICHVERFCHAR8QDSVQSTPRVER
FAKPLANMEFactor for Converting MatUnitOfMeasure to SampUnitOfMeasure QUMRENFLTP16(16) QUMRENFAK
FAKPROBMEFactor for Converting SampUnitOfMeasure to MatUnitOfMeasure QUMRENPMEFLTP16(16) QUMRENFAK
ANTVERFFraction Calculation QEANTVERFCHAR2TQ72QEANTVERF
BEWREGELValuation Rule QBEWERTCHAR2QDFMQKEY1
PROBMGFAKSample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAKDEC5(2) QPROBEFAK
PROBEMGEHSample Unit of Measure QPROBMEUNIT3T006CUNITMEINS
SOLLSTPUMFSample Size that Has to Be Inspected for a Characteristic QGESUMFINT410QANZAHL4
PRUEFUMFQuantity to Be Inspected QPRUEFUMFQUAN13(3) QMENGEPLOS
MENGENEINHBase Unit of Measure for the Sample Unit QPROBEMGEHUNIT3T006CUNITMEINS
HPZ100% Inspection QHPZCHAR1QKZ
SOLLSTPANZNumber of Planned Partial Samples QSOSTPANZINT25QANZAHL2
ANTEILKZTake Share Estimate into Account QANTEILKZCHAR1QKZ
RUECKMELNRConfirmation Number for Inspection Characteristic QRUECKNRNUMC8QRUECKNRQRU
KZEINSTELLCharacteristic Type QKZEINSTMKCHAR1QKZEINSTMK
ZAEHLInternal counter CIM_COUNTNUMC8CIM_COUNT
QDYNREGELDynamic Modification Rule QDYNREGELCHAR3QDDRQDYNREGELQDR
KZDYNAUTTime of Dynamic Modification in Inspection Lot QDYNTIMECHAR1QDYNTIME
DYNKRITString for Dynamic Modification Criteria (Database Relevant) QDYNSTRINGCHAR10QDYNSTRING
DYNMERKREFCharacteristic (in Plan) whose Q-Level Will Be Copied QMERKDYNNUMC4QMERKNRP
KZDYNRDynamic Modification Rule Available QKZDYNRCHAR1QKZ
ZAEHLERQLSequential Counter for Different Quality Levels QZAEHLERQLINT410QDYNANZ4
FORMELSLCheck and Calculate Formula in QM QFORMELSLCHAR1QFORMELSL
PZLFHAssigned Test Equipment QPZLFHNUMC8PZLFH
CODEGRQUALDefect Code Group for General Rejection QCODEGRPQLCHAR8Assigned to domainQCODEGRPCGP
CODEQUALDefect Code for Rejection: General QCODEQLCHAR4Assigned to domainQCODE
KZRASTIndicator: Sampling Procedure for Inspection Points QKZRASTCHAR1QKZRAST
RASTERInspection Frequency (Only for Inspection with Insp. Points) QRASTERNUMC3QRASTER
PPANZPRUENumber of Insp. Point Inspections Without Characteristic QPPANZPRUEINT410QDYNANZ4
SPCKRITSPC Criterion QSPCKRITCHAR3QPSPQSPCKRIT
CHARACT_ID1Characteristic Description for Quality Data Exchange QCHARACT_ID1CHAR40ALPHAQCHARACT_ID
QERGDATHPlanned Results Data Origin QERGDATHPLCHAR2TQ73QERGDATH
INPPROCParameters for Input Processing in QM Results Recording QINPPROCCHAR3CHAR3

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!