SAP table QAMV (Characteristic specifications for inspection processing)

SAP table QAMV has 4 primary key fields being MANDANT,PRUEFLOS,VORGLFNR,MERKNR.

Field Description Data Type Length Decimals Checktable Data Element
MANDANT Client CLNT 3 0 T000 MANDT
PRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
VORGLFNR Current Node Number from Order Counter NUMC 8 0 QLFNKN
MERKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
ERSTELLER Name of User Who Created the Data Record CHAR 12 0 QERSTELLER
ERSTELLDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
AENDERER Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
PHYSPROBE Number of the Partial Sample NUMC 6 0 QPHYSPROBE
SATZSTATUS Specification Record Status CHAR 1 0 TQ76 QSTATUS
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. CHAR 30 0 QMKCONTROL
TSTICHPRKZ Partial Samples Possible CHAR 1 0 QTSTICHPRO
NOINPUTKZ Results Are Calculated Internally CHAR 1 0 QNOINPUT
NIPLANMKKZ Unplanned Characteristic CHAR 1 0 QNIPLANMK
CHAR_RELEVANCE Relevance of Characteristic for Inspection CHAR 1 0 QP_CHAR_RELEVANCE
General
X First Article Inspection
AKTPPKT Use of Unplanned Characteristics (Inspection Pt. Processing) CHAR 1 0 QAKTPPKT
Additional initial and correction confirmations
1 Current confirmation only
2 Additional initial confirmations
PPKTUNGEMK Unplanned Characteristic Was Created with this Sample No. NUMC 6 0 QASV QPKTUNGEMK
QMTB_WERKS Plant CHAR 4 0 T001W WERKS_D
PMETHODE Inspection Method CHAR 8 0 QMTB QPMETHODE
PMTVERSION Version Number of Inspection Method CHAR 6 0 QVERSNRPM
ATINN Internal characteristic NUMC 10 0 ATINN
ABW_CODES Deviating Valuation of Codes CHAR 1 0 QABW_CODES
QPMK_REF Type of Master Insp. Characteristic Ref. Results Recording CHAR 1 0 QKZ_REF_EE
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 CHAR 4 0 QZAEHLER
VERWMERKM Master Inspection Characteristic CHAR 8 0 QPMK QMERKNR
MKVERSION Version Number of Master Inspection Characteristic CHAR 6 0 QVERSNRMK
MERKGEW Weighting of Characteristic CHAR 2 0 TQ17A QMERKGEW
KURZTEXT Short Text for the Inspection Characteristic CHAR 40 0 QMKKURZTXT
LTEXTKZ Inspection Characteristic Long Text Exists CHAR 1 0 QLTEXTKZ
LTEXTSPR Language Key LANG 1 0 T002 SPRAS
LTEXTEKZ Sample-Drawing Text Exists CHAR 1 0 QKZPRZIEH
LTXTENTSPR Language Key LANG 1 0 T002 SPRAS
PRUEFQUALI Inspector Qualification CHAR 5 0 TQ11 QPRQUALIF
FORMEL1 Formula Field CHAR 60 0 QFORMEL
FORMEL2 Formula Field CHAR 60 0 QFORMEL
DUMMY10 Text Line for Additional Information CHAR 10 0 QTXT10
DUMMY20 Text Line for Additional Information CHAR 20 0 QTXT20
DUMMY40 Text Line for Additional Information CHAR 40 0 QTXT40
CODEGR9U Defect Code Group for Rejection at Lower Tolerance CHAR 8 0 QCODEGRPU
CODE9U Defect Code for Rejection at Lower Specification Limit CHAR 4 0 QCODEU
CODEVR9U Version Number CHAR 6 0 QVERSNR
CODEGR9O Defect Code Group for Rejection at Upper Tolerance CHAR 8 0 QCODEGRPO
CODE9O Defect Code for Rejection at Upper Specification Limit CHAR 4 0 QCODEO
CODEVR9O Version Number CHAR 6 0 QVERSNR
KATAB1 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART1 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE1 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK1 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS1 Version Number CHAR 6 0 QVERSNR
AUSWDAT1 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB2 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART2 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE2 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK2 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS2 Version Number CHAR 6 0 QVERSNR
AUSWDAT2 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB3 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART3 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE3 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK3 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS3 Version Number CHAR 6 0 QVERSNR
AUSWDAT3 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB4 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART4 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE4 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK4 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS4 Version Number CHAR 6 0 QVERSNR
AUSWDAT4 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB5 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART5 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE5 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK5 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS5 Version Number CHAR 6 0 QVERSNR
AUSWDAT5 Key Date for Version Selection DATS 8 0 QVERSDAT
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
MASSEINHSW Unit of Measurement in Which Quantitative Data Is Stored UNIT 3 0 T006 QMASSEH
SOLLWERT Target Value for a Quantitative Characteristic FLTP 16 16 QSOLLWERTE
SOLLWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZOB Upper Specification Limit FLTP 16 16 QTOLOB
TOLOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZUN Lower Specification Limit FLTP 16 16 QTOLUN
TOLUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWKZ Tolerance Change Is Active CHAR 1 0 QTOLERWKZ
GRENZEOB1 First Upper Specification Limit FLTP 16 16 QGRENZOB1
GRENZOB1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN1 First Lower Specification Limit FLTP 16 16 QGRENZUN1
GRENZUN1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEOB2 Second Upper Specification Limit FLTP 16 16 QGRENZOB2
GRENZOB2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN2 Second Lower Specification Limit FLTP 16 16 QGRENZUN2
GRENZUN2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIOBEN Upper Plausibility Limit FLTP 16 16 QPLAUSIOB
PLAUSIOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIUNTE Lower Plausibility Limit FLTP 16 16 QPLAUSIUN
PLAUSIUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASANZAHL Number of Value Classes for Inspection Results INT1 3 0 QKLASSZAHL
KLASBREITE Class Width FLTP 16 16 QKLASSBR
KLASBRNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASMITTE Class Midpoint FLTP 16 16 QKLASSMIT
KLASMINI Value Not Initial if Set CHAR 1 0 QNINITIAL
PRZIEHVERF Sample-Drawing Procedure CHAR 8 0 QPRVP QPRZIEHVER
VERSION Version No. of the Sample-Drawing Procedure CHAR 6 0 QVERSNPRZV
POSNRPRZV Item Number in Sample-Drawing Procedure NUMC 4 0 QZAEHLPRZV
LOSGEBEH Lot Container UNIT 3 0 T006 QGEBEH
PROBNRPL Highest Partial Sample No. Valid for Instruction NUMC 3 0 QPROBNRBIS
STICHPRVER Sampling Procedure in Inspection Characteristic CHAR 8 0 QDSV QSTICHVERF
FAKPLANME Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure FLTP 16 16 QUMREN
FAKPROBME Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure FLTP 16 16 QUMRENPME
ANTVERF Fraction Calculation CHAR 2 0 TQ72 QEANTVERF
BEWREGEL Valuation Rule CHAR 2 0 QDFM QBEWERT
PROBMGFAK Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) DEC 5 2 QPROBEFAK
PROBEMGEH Sample Unit of Measure UNIT 3 0 T006 QPROBME
SOLLSTPUMF Sample Size that Has to Be Inspected for a Characteristic INT4 10 0 QGESUMF
PRUEFUMF Quantity to Be Inspected QUAN 13 3 QPRUEFUMF
MENGENEINH Base Unit of Measure for Sample Unit UNIT 3 0 T006 QPROBEMGEH
HPZ 100% Inspection CHAR 1 0 QHPZ
SOLLSTPANZ Number of Planned Partial Samples INT2 5 0 QSOSTPANZ
ANTEILKZ Take Share Estimate into Account CHAR 1 0 QANTEILKZ
RUECKMELNR Confirmation Number for Inspection Characteristic NUMC 8 0 QRUECKNR
KZEINSTELL Characteristic Type CHAR 1 0 QKZEINSTMK
Inspection Characteristic
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
QDYNREGEL Dynamic Modification Rule CHAR 3 0 QDDR QDYNREGEL
KZDYNAUT Time of Dynamic Modification in Inspection Lot CHAR 1 0 QDYNTIME
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) CHAR 10 0 QDYNSTRING
DYNMERKREF Characteristic (in Plan) whose Q-Level Will Be Copied NUMC 4 0 QMERKDYN
KZDYNR Dynamic Modification Rule Available CHAR 1 0 QKZDYNR
ZAEHLERQL Sequential Counter for Different Quality Levels INT4 10 0 QZAEHLERQL
FORMELSL Check and Calculate Formula in QM CHAR 1 0 QFORMELSL
PZLFH Assigned Test Equipment NUMC 8 0 QPZLFH
CODEGRQUAL Defect Code Group for General Rejection CHAR 8 0 QCODEGRPQL
CODEQUAL Defect Code for Rejection: General CHAR 4 0 QCODEQL
KZRAST Sampling Procedure for Inspection Points CHAR 1 0 QKZRAST
Without Inspection Points
1 Inspection Points for Plant Maintenance
2 Inspection Points for Sample Management
X Inspection Points for Production
RASTER Inspection Frequency (Only for Inspection with Insp. Points) NUMC 3 0 QRASTER
PPANZPRUE Number of Insp. Point Inspections Without Characteristic INT4 10 0 QPPANZPRUE
SPCKRIT SPC Criterion CHAR 3 0 QPSP QSPCKRIT
CHARACT_ID1 Characteristic Description for Quality Data Exchange CHAR 40 0 QCHARACT_ID1
QERGDATH Planned Results Data Origin CHAR 2 0 TQ73 QERGDATHPL
INPPROC Parameters for Input Processing in QM Results Recording CHAR 3 0 QINPPROC
CHAORIG Inspection Characteristic Origin CHAR 3 0 QP_CHAORIG
QP_CHAORIG_ID Original Identification for Characteristic CHAR 40 0 QMIP_CHAORIG_ID
CHARGROUP Characteristic Group CHAR 10 0 QCHARGROUP
CHARGROUP_CREF Source Characteristic of Characteristic Group Division NUMC 4 0 QCHARGROUP_CREF
DIVISIONINT Internal Division ID NUMC 4 0 QDIVISIONINT
OA_ID Identifies an Operation Activity INT8 19 0 MPE_OA_ID
OA_VERSION_NO Number of an Operation Actiivity Version INT4 10 0 MPE_OA_VERSION_NO
DUMMY_QAMV_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QAMV foreign key relationships

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