1. Home
  2. Resources
  3. SAP Tables
  4. QAMSV - Specifications for inspection characteristics

SAP Table QAMSV

Specifications for inspection characteristics

QAMSV (Specifications for inspection characteristics) 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 QAMSV to other SAP tables.

Source: QAMSV (Specifications for inspection characteristics)

QAMSV table fields

Field Data element Checktable Datatype Length Decimals
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
UPSLV Data Base Access QUPSL CHAR 1 0
MARK Selection Field QEEMARK CHAR 1 0
NULL Indicator is not set
X Indicator is set
PLNFL Sequence PLNFOLGE CHAR 6 0
PLNKN Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
VORNR Operation/Activity Number VORNR CHAR 4 0
PHYSPROBE Number of the Partial Sample QPHYSPROBE NUMC 6 0
STATUSV 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
QMTB_WERKS Plant WERKS_D T001W CHAR 4 0
PMETHODE Inspection Method QPMETHODE CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
QPMK_WERKS Plant for the Master Inspection Characteristic QZAEHLER CHAR 4 0
VERWMERKM Master Inspection Characteristics QMERKNR 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
LTXTEKZ Long Text for Physical-Sample Drawing of a Characteristic QLTEXTEKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
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 Code Group QCODEGRP CHAR 8 0
CODE9U Defect Code for Rejection at Lower Specification Limit QCODEU CHAR 4 0
CODEVR9U Version Number QVERSNR CHAR 6 0
CODEGR9O Code Group QCODEGRP 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 Measurement Unit in Which Quantitative Data Is Maintained QMGEH6 T006C CHAR 6 0
MASSEINHOB Measurement Unit in Which Quantitative Data Is Maintained QMGEH6 CHAR 6 0
MASSEINHUN Measurement Unit in Which Quantitative Data Is Maintained QMGEH6 CHAR 6 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
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF 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 CHAR 2 0
BEWREGEL Valuation Rule QBEWERT QDFM CHAR 2 0
FBNAME Name of Function Module QFBNAME CHAR 30 0
KZATTRFE Attributive Inspection by Nonconforming Units QKZATTRFE CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZATTRFZ Attributive Inspection by Number of Defects QKZATTRFZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZVARS Variable Inspection by S-Method QKZVARS CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZCOD Valuation by Code QKZCOD CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZMAN Manual Valuation QKZMAN CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZUMFS Multiple Samples QKZUMFS CHAR 1 0
NULL No multiple samples
X Independent multiple samples
1 Dependent multiple samples
KZNULL Inspection Against Specification Limits (k = 0) QKZKNULL CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
ANNAHMEZ Acceptance Number QANNAHMEZ INT2 5 0
RUECKWEZ Rejection Number QRUECKWEZ INT2 5 0
KFAKTORNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KFAKTOR K-Factor for a Variable Inspection QKFAKTOR FLTP 16 16
TQ15TSW1 Keyword for Catalog Type 1 of the Inspection Characteristic QTQ15TSW CHAR 12 0
QPAMKTXT1 Short Text for Selected Set or Code Group QPAMKTXT CHAR 40 0
QPAMSP1 Language Key for Long Text for Selected Set/Code Group QPAMSP T002 LANG 1 0
QPAMLTXT1 Long Text Exists for the Selected Set QLTEXTMGE CHAR 1 0
NULL Indicator is not set
X Indicator is set
TQ15TSW2 Keyword for Catalog Type 1 of the Inspection Characteristic QTQ15TSW CHAR 12 0
QPAMKTXT2 Short Text for Selected Set or Code Group QPAMKTXT CHAR 40 0
QPAMSP2 Language Key for Long Text for Selected Set/Code Group QPAMSP T002 LANG 1 0
QPAMLTXT2 Long Text Exists for the Selected Set QLTEXTMGE CHAR 1 0
NULL Indicator is not set
X Indicator is set
TQ15TSW3 Keyword for Catalog Type 1 of the Inspection Characteristic QTQ15TSW CHAR 12 0
QPAMKTXT3 Short Text for Selected Set or Code Group QPAMKTXT CHAR 40 0
QPAMSP3 Language Key for Long Text for Selected Set/Code Group QPAMSP T002 LANG 1 0
QPAMLTXT3 Long Text Exists for the Selected Set QLTEXTMGE CHAR 1 0
NULL Indicator is not set
X Indicator is set
TQ15TSW4 Keyword for Catalog Type 1 of the Inspection Characteristic QTQ15TSW CHAR 12 0
QPAMKTXT4 Short Text for Selected Set or Code Group QPAMKTXT CHAR 40 0
QPAMSP4 Language Key for Long Text for Selected Set/Code Group QPAMSP T002 LANG 1 0
QPAMLTXT4 Long Text Exists for the Selected Set QLTEXTMGE CHAR 1 0
NULL Indicator is not set
X Indicator is set
TQ15TSW5 Keyword for Catalog Type 1 of the Inspection Characteristic QTQ15TSW CHAR 12 0
QPAMKTXT5 Short Text for Selected Set or Code Group QPAMKTXT CHAR 40 0
QPAMSP5 Language Key for Long Text for Selected Set/Code Group QPAMSP T002 LANG 1 0
QPAMLTXT5 Long Text Exists for the Selected Set QLTEXTMGE CHAR 1 0
NULL Indicator is not set
X Indicator is set
KEINTOLKZ No Tolerance Limit Defined QKEINTOLKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
SUMPROBKZ Summarized Characteristic Results for Multiple Samples QSUMPROBKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MITTEL1WKZ Summ. Recording of Mean Value if Target Sample Size = 1 QMITTEL1KZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDKZ1 Field Selection Not Used Before QDUMMYKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDKZ2 Field Selection Not Used Before QDUMMYKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDKZ3 Field Selection Not Used Before QDUMMYKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDKZ4 Field Selection Not Used Before QDUMMYKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDKZ5 Field Selection Not Used Before QDUMMYKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
KATVORG Catalog Specifications Available QKATVORG CHAR 1 0
NULL Indicator is not set
X Indicator is set

QAMSV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAMSV AUSWMGWRK1 QAMV MANDT T001W Plants/Branches MANDT
QAMSV AUSWMGWRK1 QAMSV AUSWMGWRK1 T001W Plants/Branches WERKS
QAMSV AUSWMGWRK2 QAMV MANDT T001W Plants/Branches MANDT
QAMSV AUSWMGWRK2 QAMSV AUSWMGWRK2 T001W Plants/Branches WERKS
QAMSV AUSWMGWRK3 QAMV MANDT T001W Plants/Branches MANDT
QAMSV AUSWMGWRK3 QAMSV AUSWMGWRK3 T001W Plants/Branches WERKS
QAMSV AUSWMGWRK4 QAMSV AUSWMGWRK4 T001W Plants/Branches WERKS
QAMSV AUSWMGWRK4 QAMV MANDT T001W Plants/Branches MANDT
QAMSV AUSWMGWRK5 QAMSV AUSWMGWRK5 T001W Plants/Branches WERKS
QAMSV AUSWMGWRK5 QAMV MANDT T001W Plants/Branches MANDT
QAMSV BEWREGEL QAMSV BEWREGEL QDFM Function modules for valuation mode FBKEY
QAMSV BEWREGEL QAMV MANDT QDFM Function modules for valuation mode MANDT
QAMSV KATALGART1 QAMV MANDT TQ15 Inspection catalog type index MANDT
QAMSV KATALGART1 QAMSV KATALGART1 TQ15 Inspection catalog type index KATALOGART
QAMSV KATALGART2 QAMV MANDT TQ15 Inspection catalog type index MANDT
QAMSV KATALGART2 QAMSV KATALGART2 TQ15 Inspection catalog type index KATALOGART
QAMSV KATALGART3 QAMV MANDT TQ15 Inspection catalog type index MANDT
QAMSV KATALGART3 QAMSV KATALGART3 TQ15 Inspection catalog type index KATALOGART
QAMSV KATALGART4 QAMV MANDT TQ15 Inspection catalog type index MANDT
QAMSV KATALGART4 QAMSV KATALGART4 TQ15 Inspection catalog type index KATALOGART
QAMSV KATALGART5 QAMSV KATALGART5 TQ15 Inspection catalog type index KATALOGART
QAMSV KATALGART5 QAMV MANDT TQ15 Inspection catalog type index MANDT
QAMSV LTXTENTSPR QAMSV LTXTENTSPR T002 Language Keys (Component BC-I18) SPRAS
QAMSV MASSEINHSW SY LANGU T006C Assignment of external technical to internal unit of measure SPRAS
QAMSV MASSEINHSW SY MANDT T006C Assignment of external technical to internal unit of measure MANDT
QAMSV MASSEINHSW QAMSV MASSEINHSW T006C Assignment of external technical to internal unit of measure MSEH6
QAMSV MENGENEINH QAMSV MENGENEINH T006 Units of Measurement MSEHI
QAMSV MENGENEINH SY MANDT T006 Units of Measurement MANDT
QAMSV MERKGEW QAMSV MERKGEW TQ17A Characteristic weightings MERKKLASSE
QAMSV MERKGEW QAMV MANDT TQ17A Characteristic weightings MANDT
QAMSV PROBEMGEH QAMSV PROBEMGEH T006 Units of Measurement MSEHI
QAMSV PROBEMGEH SY MANDT T006 Units of Measurement MANDT
QAMSV PRUEFQUALI QAMV MANDT TQ11 Inspector qualification MANDT
QAMSV PRUEFQUALI QAMSV PRUEFQUALI TQ11 Inspector qualification PRFQL
QAMSV QMTB_WERKS QAMV MANDT T001W Plants/Branches MANDT
QAMSV QMTB_WERKS QAMSV QMTB_WERKS T001W Plants/Branches WERKS
QAMSV QPAMSP1 QAMSV QPAMSP1 T002 Language Keys (Component BC-I18) SPRAS
QAMSV QPAMSP2 QAMSV QPAMSP2 T002 Language Keys (Component BC-I18) SPRAS
QAMSV QPAMSP3 QAMSV QPAMSP3 T002 Language Keys (Component BC-I18) SPRAS
QAMSV QPAMSP4 QAMSV QPAMSP4 T002 Language Keys (Component BC-I18) SPRAS
QAMSV QPAMSP5 QAMSV QPAMSP5 T002 Language Keys (Component BC-I18) SPRAS
QAMSV STATUSV QAMSV STATUSV TQ76 Processing status of inspection characteristics STATUS