1. Home
  2. Resources
  3. SAP Tables
  4. QAMV - Characteristic specifications for inspection processing

SAP Table QAMV

Characteristic specifications for inspection processing

QAMV (Characteristic specifications for inspection processing) 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 QAMV to other SAP tables.

Source: QAMV (Characteristic specifications for inspection processing)

QAMV table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
PRUEFLOS Inspection Lot Number QPLOS QALS NUMC 12 0
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELLDAT Date on Which the Data Record Was Created QDATUMERST 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
PHYSPROBE Number of the Partial Sample QPHYSPROBE NUMC 6 0
SATZSTATUS Specification Record Status QSTATUS TQ76 CHAR 1 0
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL CHAR 30 0
TSTICHPRKZ Partial Samples Possible QTSTICHPRO CHAR 1 0
NULL No multiple samples
X Independent multiple samples
1 Dependent multiple samples
NOINPUTKZ Results Are Calculated Internally QNOINPUT CHAR 1 0
NULL Indicator is not set
X Indicator is set
NIPLANMKKZ Unplanned Characteristic QNIPLANMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
AKTPPKT Use of Unplanned Characteristics (Inspection Pt. Processing) QAKTPPKT CHAR 1 0
NULL Additional initial and correction confirmations
1 Current confirmation only
2 Additional initial confirmations
PPKTUNGEMK Unplanned Characteristic Was Created with this Sample No. QPKTUNGEMK QASV NUMC 6 0
QMTB_WERKS Plant WERKS_D T001W CHAR 4 0
PMETHODE Inspection Method QPMETHODE QMTB CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
ATINN Internal characteristic ATINN NUMC 10 0
ABW_CODES Deviating Valuation of Codes QABW_CODES CHAR 1 0
NULL Indicator is not set
X Indicator is set
QPMK_REF Type of Master Insp. Characteristic Ref. Results Recording QKZ_REF_EE CHAR 1 0
NULL Reference to master inspection characteristic
1 MastInspChar from pln overwritten with matSpec, NoRefToGenCh
2 Values from material specification, without ref. to gen.char
3 Master inspection char. was copied to plan
4 Specifications were changed
5 Specifications were changed by config./batch determination
6 Specifications from config./batch determination
7 MastChar from pln overwritten with mat.spec, with refToGenCh
8 Values are from mat. spec. with ref to gen. charac.
9 Specs changed using flexible inspection specs function
QPMK_WERKS 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
MERKGEW Weighting of the Characteristic QMERKGEW TQ17A CHAR 2 0
KURZTEXT Short Text for the Inspection Characteristic QMKKURZTXT 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 T002 LANG 1 0
LTEXTEKZ Physical-Sample-Drawing Text Exists QKZPRZIEH CHAR 1 0
LTXTENTSPR Language Key SPRAS T002 LANG 1 0
PRUEFQUALI Inspector Qualification QPRQUALIF TQ11 CHAR 5 0
FORMEL1 Formula Field QFORMEL CHAR 60 0
FORMEL2 Formula Field QFORMEL CHAR 60 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
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
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
TOLERWKZ Tolerance Change Is Active QTOLERWKZ 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
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
PRZIEHVERF Sample-Drawing Procedure QPRZIEHVER QPRVP CHAR 8 0
VERSION Version No. of the Sample-Drawing Procedure QVERSNPRZV CHAR 6 0
POSNRPRZV Item Number in Sample-Drawing Procedure QZAEHLPRZV NUMC 4 0
LOSGEBEH Lot Container QGEBEH T006 UNIT 3 0
PROBNRPL Highest Partial Sample No. Valid for Instruction QPROBNRBIS NUMC 3 0
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF QDSV 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
ANTVERF Fraction Calculation QEANTVERF TQ72 CHAR 2 0
BEWREGEL Valuation Rule QBEWERT QDFM CHAR 2 0
PROBMGFAK Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK DEC 5 2
PROBEMGEH Sample Unit of Measure QPROBME T006 UNIT 3 0
SOLLSTPUMF Sample Size that Has to Be Inspected for a Characteristic QGESUMF INT4 10 0
PRUEFUMF Quantity to Be Inspected QPRUEFUMF QUAN 13 3
MENGENEINH Base Unit of Measure for the Sample Unit QPROBEMGEH T006 UNIT 3 0
HPZ 100% Inspection QHPZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
SOLLSTPANZ Number of Planned Partial Samples QSOSTPANZ INT2 5 0
ANTEILKZ Take Share Estimate into Account QANTEILKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
RUECKMELNR Confirmation Number for Inspection Characteristic QRUECKNR NUMC 8 0
KZEINSTELL Characteristic Type QKZEINSTMK CHAR 1 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
QDYNREGEL Dynamic Modification Rule QDYNREGEL QDDR CHAR 3 0
KZDYNAUT Time of Dynamic Modification in Inspection Lot QDYNTIME CHAR 1 0
NULL 3.0 lot -> Determine time of dyn. modif. from dyn. mod. rule
1 Dynamic modification at the usage decision
X Dynamic modification at lot creation
DYNKRIT String for Dynamic Modification Criteria (Database Relevant) QDYNSTRING CHAR 10 0
DYNMERKREF Characteristic (in Plan) whose Q-Level Will Be Copied QMERKDYN NUMC 4 0
KZDYNR Dynamic Modification Rule Available QKZDYNR CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZAEHLERQL Sequential Counter for Different Quality Levels QZAEHLERQL INT4 10 0
FORMELSL Check and Calculate Formula in QM QFORMELSL CHAR 1 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
KZRAST Indicator: Sampling Procedure for Inspection Points QKZRAST CHAR 1 0
NULL Without insp. points
X Inspection points for production
1 Inspection points for Plant Maintenance
2 Inspection points for sample management
RASTER Inspection Frequency (Only for Inspection with Insp. Points) QRASTER NUMC 3 0
PPANZPRUE Number of Insp. Point Inspections Without Characteristic QPPANZPRUE INT4 10 0
SPCKRIT SPC Criterion QSPCKRIT QPSP CHAR 3 0
CHARACT_ID1 Characteristic Description for Quality Data Exchange QCHARACT_ID1 CHAR 40 0
QERGDATH Planned Results Data Origin QERGDATHPL TQ73 CHAR 2 0
INPPROC Parameters for Input Processing in QM Results Recording QINPPROC CHAR 3 0

QAMV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAMV ANTVERF QAMV ANTVERF TQ72 Type of share calculation ANTVERF
QAMV ANTVERF QAMV MANDANT TQ72 Type of share calculation MANDT
QAMV AUSWMGWRK1 QAMV MANDANT T001W Plants/Branches MANDT
QAMV AUSWMGWRK1 QAMV AUSWMGWRK1 T001W Plants/Branches WERKS
QAMV AUSWMGWRK2 QAMV AUSWMGWRK2 T001W Plants/Branches WERKS
QAMV AUSWMGWRK2 QAMV MANDANT T001W Plants/Branches MANDT
QAMV AUSWMGWRK3 QAMV MANDANT T001W Plants/Branches MANDT
QAMV AUSWMGWRK3 QAMV AUSWMGWRK3 T001W Plants/Branches WERKS
QAMV AUSWMGWRK4 QAMV MANDANT T001W Plants/Branches MANDT
QAMV AUSWMGWRK4 QAMV AUSWMGWRK4 T001W Plants/Branches WERKS
QAMV AUSWMGWRK5 QAMV MANDANT T001W Plants/Branches MANDT
QAMV AUSWMGWRK5 QAMV AUSWMGWRK5 T001W Plants/Branches WERKS
QAMV BEWREGEL QAMV BEWREGEL QDFM Function modules for valuation mode FBKEY
QAMV BEWREGEL QAMV MANDANT QDFM Function modules for valuation mode MANDT
QAMV KATALGART1 QAMV KATALGART1 TQ15 Inspection catalog type index KATALOGART
QAMV KATALGART1 QAMV MANDANT TQ15 Inspection catalog type index MANDT
QAMV KATALGART2 QAMV MANDANT TQ15 Inspection catalog type index MANDT
QAMV KATALGART2 QAMV KATALGART2 TQ15 Inspection catalog type index KATALOGART
QAMV KATALGART3 QAMV KATALGART3 TQ15 Inspection catalog type index KATALOGART
QAMV KATALGART3 QAMV MANDANT TQ15 Inspection catalog type index MANDT
QAMV KATALGART4 QAMV KATALGART4 TQ15 Inspection catalog type index KATALOGART
QAMV KATALGART4 QAMV MANDANT TQ15 Inspection catalog type index MANDT
QAMV KATALGART5 QAMV KATALGART5 TQ15 Inspection catalog type index KATALOGART
QAMV KATALGART5 QAMV MANDANT TQ15 Inspection catalog type index MANDT
QAMV LOSGEBEH QAMV MANDANT T006 Units of Measurement MANDT
QAMV LOSGEBEH QAMV LOSGEBEH T006 Units of Measurement MSEHI
QAMV LTEXTSPR QAMV LTEXTSPR T002 Language Keys (Component BC-I18) SPRAS
QAMV LTXTENTSPR QAMV LTXTENTSPR T002 Language Keys (Component BC-I18) SPRAS
QAMV MANDANT QAMV MANDANT T000 Clients MANDT
QAMV MASSEINHSW QAMV MASSEINHSW T006 Units of Measurement MSEHI
QAMV MASSEINHSW QAMV MANDANT T006 Units of Measurement MANDT
QAMV MENGENEINH QAMV MANDANT T006 Units of Measurement MANDT
QAMV MENGENEINH QAMV MENGENEINH T006 Units of Measurement MSEHI
QAMV MERKGEW QAMV MANDANT TQ17A Characteristic weightings MANDT
QAMV MERKGEW QAMV MERKGEW TQ17A Characteristic weightings MERKKLASSE
QAMV PMETHODE QAMV QMTB_WERKS QMTB Inspection method master record WERKS
QAMV PMETHODE QAMV MANDANT QMTB Inspection method master record MANDT
QAMV PMETHODE QAMV PMETHODE QMTB Inspection method master record PMTNR
QAMV PMETHODE QAMV PMTVERSION QMTB Inspection method master record VERSION
QAMV PPKTUNGEMK QAMV PPKTUNGEMK QASV Sample specifications for inspection processing PROBENR
QAMV PPKTUNGEMK QAMV MERKNR QASV Sample specifications for inspection processing MERKNR
QAMV PPKTUNGEMK QAMV MANDANT QASV Sample specifications for inspection processing MANDANT
QAMV PPKTUNGEMK QAMV PRUEFLOS QASV Sample specifications for inspection processing PRUEFLOS
QAMV PPKTUNGEMK QAMV VORGLFNR QASV Sample specifications for inspection processing VORGLFNR
QAMV PROBEMGEH QAMV MANDANT T006 Units of Measurement MANDT
QAMV PROBEMGEH QAMV PROBEMGEH T006 Units of Measurement MSEHI
QAMV PRUEFLOS QAMV MANDANT QALS Inspection lot record MANDANT
QAMV PRUEFLOS QAMV PRUEFLOS QALS Inspection lot record PRUEFLOS
QAMV PRUEFQUALI QAMV MANDANT TQ11 Inspector qualification MANDT
QAMV PRUEFQUALI QAMV PRUEFQUALI TQ11 Inspector qualification PRFQL
QAMV PRZIEHVERF QAMV MANDANT QPRVP Sample-drawing items MANDT
QAMV PRZIEHVERF QAMV POSNRPRZV QPRVP Sample-drawing items POSNRPRZV
QAMV PRZIEHVERF QAMV VERSION QPRVP Sample-drawing items VERSION
QAMV PRZIEHVERF QAMV PRZIEHVERF QPRVP Sample-drawing items PRZIEHVERF
QAMV QDYNREGEL QAMV QDYNREGEL QDDR Dynamic modification rule (header) DYNREGEL
QAMV QDYNREGEL QAMV MANDANT QDDR Dynamic modification rule (header) MANDT
QAMV QERGDATH QAMV MANDANT TQ73 Origin of results data MANDT
QAMV QERGDATH QAMV QERGDATH TQ73 Origin of results data QERGDATH
QAMV QMTB_WERKS QAMV QMTB_WERKS T001W Plants/Branches WERKS
QAMV QMTB_WERKS QAMV MANDANT T001W Plants/Branches MANDT
QAMV SATZSTATUS QAMV SATZSTATUS TQ76 Processing status of inspection characteristics STATUS
QAMV SPCKRIT QAMV SPCKRIT QPSP SPC criterion SPCKRIT
QAMV SPCKRIT QAMV MANDANT QPSP SPC criterion MANDT
QAMV STICHPRVER QAMV STICHPRVER QDSV Sampling procedure STICHPRVER
QAMV STICHPRVER QAMV MANDANT QDSV Sampling procedure MANDT
QAMV VERWMERKM QAMV QPMK_WERKS QPMK Inspection characteristic master ZAEHLER
QAMV VERWMERKM QAMV MANDANT QPMK Inspection characteristic master MANDT
QAMV VERWMERKM QAMV VERWMERKM QPMK Inspection characteristic master MKMNR
QAMV VERWMERKM QAMV PMTVERSION QPMK Inspection characteristic master VERSION