SAP Table QAIMV

Characteristic specs. for download to complex QM subsystems

QAIMV (Characteristic specs. for download to complex QM subsystems) 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 QAIMV to other SAP tables.

Source: QAIMV (Characteristic specs. for download to complex QM subsystems)

QAIMV table fields

Field Data element Checktable Datatype Length Decimals
SATZART Record Types for QM Interface - Subsystems QEIFART CHAR 3 0
Q40 Inspection lot requirements
Q41 Req. for insp. lot header record
Q42 Char. specifications for subsystem
Q45 Download inspection catalog entries
Q48 Status changes in insp. lot
Q51 Quantative original value record for single unit
Q52 Qualitative orig. value rec. for sing. unit with char. code
Q53 Qualitative orig. value rec. for sing. unit with valuation_
Q54 Quantative original value record for inspection point_
Q55 Qualitative orig. value rec. with char. code for insp. point
Q56 Qualitative orig. value rec. with valuation for insp. point
Q58 Cancel single unit record
Q61 Quantative sample record
Q62 Qualitative sample record with characteristic code
Q63 Qualitative sample record with valuation
Q64 Quantative sample record for inspection point
Q65 Qualitative sample record with char. code for insp. point
Q66 Qualitative sample rec. with valuation for insp. point
Q68 Cancel sample record
Q69 Close sample record
Q71 Quantitative characteristic record
Q72 Qualitative characteristic set with char. code
Q73 Qualitative characteristic set with valuation
Q79 Close character.
Q83 Confirmation for inspection point
Q84 Valuation for inspection point
Q88 Usage Decision for Inspection Lot
Q89 Inspection cancelled for inspection lot
Q90 Insp.lot defects
Q91 Operation defects
Q92 Characteristic / sample defects
Q95 Operation defects with reference to an inspection point
Q96 Characteristic defects with reference to an inspection point
RUECKMELNR Confirmation Number for Inspection Characteristic QRUECKNR NUMC 8 0
ERFASSART Recording Type for Inspection Characteristic QEIFERFAS CHAR 1 0
A Measured values for single unit
B Code for single unit
C Valuation for single unit (O.K./n.O.K.)
D Measured values for sample
E Code for sample
F Valuation of a sample
G Measured value for characteristic
H Code for characteristic
I Valuation of a characteristic
J Measured values for single unit in a sample
K Code for single unit in a sample
L Valuation for single unit in a sample
M Measured values for single unit in an insp. pt.-based sample
N Code for single unit in an inspection point-based sample
O Valuation for single unit in inspection point-based sample
P Measured values for sample for an inspection point
Q Code for sample for an inspection point
R Valuation for the sample for an inspection point
KZBEWSUBSY Valuate Inspection Characteristic on Subsystem QEIFBEWSUB CHAR 1 0
NULL Indicator is not set
X Indicator is set
BEWART Valuation Type for Characteristic for QM Subsystems QEIFBEWMK CHAR 1 0
A Attributive inspection for no. of non-conforming units
B Attributive inspection for no. of defects
C Variable inspection s method
D Valuation by code
E Manual Valuation
F Inspection against tolerance limits
G Valuation of characteristic using sample ratings
H SPC inspection using quality control cards
I Dependent multiple samples
KZRZWANG Required Confirmation for Inspection Characteristic QEIFRWANG CHAR 1 0
X Required characteristic
NULL Optional characteristic
+ Required when previous required characteristic is accepted
- Required when previous required characteristic is rejected
STATUSV Specification Record Status QSTATUS CHAR 1 0
STATUSR Results Record Status QBEASTATUS CHAR 1 0
KZPRUMF Inspection Scope QPUMFKZ CHAR 1 0
= Fixed inspection scope
NULL Scope not fixed
< Smaller inspection scope allowed
> Larger inspection scope allowed
KZDOKU Documentation Required for Inspection Results QDOKUKZ CHAR 1 0
NULL Text documentation of test values is not required
. The test values with valuation R (reject) must be documented
+ All test values must be documented with text
KZSERNR Serial Number To Be Recorded in QM Subsystem QEIFSERNR CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZTSTICHPR Partial Samples Possible QTSTICHPRO CHAR 1 0
NULL No multiple samples
X Independent multiple samples
1 Dependent multiple samples
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
SOLLSTPANZ Number of Planned Partial Samples QEIFSTPANZ CHAR 5 0
BEWARTSP Valuation Type for Sample for QM Subsystems QEIFBEWSP CHAR 1 0
A Attributive inspection for no. of non-conforming units
B Attributive inspection for no. of defects
C Variable inspection s method
D Valuation by code
E Manual Valuation
F Inspection against tolerance limits
G Valuation of characteristic using sample ratings
H SPC inspection using quality control cards
I Dependent multiple samples
PRUEFLOS Inspection Lot Number QPLOS QALS NUMC 12 0
PLNFL Sequence PLNFOLGE CHAR 6 0
VORNR Operation/Activity Number VORNR CHAR 4 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
QPMK_WERKS Plant for Master Inspection Characteristic QEIFPMKWRK CHAR 4 0
VERWMERKM Master Inspection Characteristics QMERKNR QPMK CHAR 8 0
MKVERSION Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 0
QMTB_WERKS Plant for Inspection Method QEIFMTBWRK T001W CHAR 4 0
PMETHODE Inspection Method QPMETHODE QMTB CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
PMTKURZTXT Short Text for Inspection Method QEIFPMTTXT CHAR 40 0
PRUEFQUALI Inspector Qualification QPRQUALIF CHAR 5 0
MERKGEW Weighting of the Characteristic QMERKGEW TQ17A CHAR 2 0
GEWKURZTXT Short Text for Characteristic Weighting QEIFGEWTXT CHAR 40 0
KURZTEXT Short Text for the Inspection Characteristic QMKKURZTXT CHAR 40 0
FORMEL Complete Formula for Linking Insp. Char. to QM Subsystems QEIFFORMEL CHAR 120 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
STELLEN Number of Decimal Places QEIFSTELLE NUMC 2 0
MASSEINHSW Unit of Measurement for the Inspection Characteristic QEIFPRFMK T006 UNIT 3 0
SOLLWERT Target Value for a Quantitative Characteristic QSOLLWERTC CHAR 16 0
TOLERANZOB Upper Specification Limit QTOLOBC CHAR 16 0
TOLERANZUN Lower Specification Limit QTOLUNC CHAR 16 0
PLAUSIOBEN Upper Plausibility Limit QPLAUSIOBC CHAR 16 0
PLAUSIUNTE Lower Plausibility Limit QPLAUSIUNC CHAR 16 0
GRENZEOB1 First Upper Specification Limit QGRENZO1C CHAR 16 0
GRENZEUN1 First Lower Specification Limit QGRENZU1C CHAR 16 0
GRENZEOB2 Second Upper Specification Limit QGRENZO2C CHAR 16 0
GRENZEUN2 Second Lower Specification Limit QGRENZU2C CHAR 16 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
AUSWMGWRK1 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWMENGE1 Assigned Code Group or Selected Set QCGRAUSW CHAR 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
AUSWMGWRK2 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWMENGE2 Assigned Code Group or Selected Set QCGRAUSW CHAR 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
AUSWMGWRK3 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWMENGE3 Assigned Code Group or Selected Set QCGRAUSW CHAR 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
AUSWMGWRK4 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWMENGE4 Assigned Code Group or Selected Set QCGRAUSW CHAR 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
AUSWMGWRK5 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
AUSWMENGE5 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
SOLLSTPUMF Sample Size to Be Inspected in QM Subsystem QEIFSTUMF NUMC 7 0
PROBEMGEH Base Unit of Measure for the Inspection Lot QEIFMASS UNIT 3 0
PROBMGFAK Sample Unit of Measurement Factor for QM Subsystem QEIFSTPFAK NUMC 6 0
ANNAHMEZ Acceptance Number in Attrib. Insp. for QM Subsystems QEIFANNAMZ NUMC 5 0
RUECKWEZ Rejection Number in Attributive Insp. for QM Subsystems QEIFRUECKZ NUMC 5 0
KFAKTOR K-Factor for a Variable Inspection QKFAKTORC CHAR 16 0
QRKNR Control Chart Number QQRKNR QASH NUMC 12 0
PHYSPROBE Number of the Partial Sample QPHYSPROBE NUMC 6 0
KZKORRTRAN Correction Transfer Was Carried Out QEIFKORRTR CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZAEHL Internal counter CIM_COUNT NUMC 8 0
ANTVERF Fraction Calculation QEIFANVERF CHAR 1 0
A Binomial distribution
B Poisson distribution
C Normal distribution
NULL Distribution not specified

QAIMV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAIMV AUSWMGWRK1 QAIMV AUSWMGWRK1 T001W Plants/Branches WERKS
QAIMV AUSWMGWRK1 SYST MANDT T001W Plants/Branches MANDT
QAIMV AUSWMGWRK2 SYST MANDT T001W Plants/Branches MANDT
QAIMV AUSWMGWRK2 QAIMV AUSWMGWRK2 T001W Plants/Branches WERKS
QAIMV AUSWMGWRK3 SYST MANDT T001W Plants/Branches MANDT
QAIMV AUSWMGWRK3 QAIMV AUSWMGWRK3 T001W Plants/Branches WERKS
QAIMV AUSWMGWRK4 SYST MANDT T001W Plants/Branches MANDT
QAIMV AUSWMGWRK4 QAIMV AUSWMGWRK4 T001W Plants/Branches WERKS
QAIMV AUSWMGWRK5 QAIMV AUSWMGWRK5 T001W Plants/Branches WERKS
QAIMV AUSWMGWRK5 SYST MANDT T001W Plants/Branches MANDT
QAIMV KATALGART1 SYST MANDT TQ15 Inspection catalog type index MANDT
QAIMV KATALGART1 QAIMV KATALGART1 TQ15 Inspection catalog type index KATALOGART
QAIMV KATALGART2 SYST MANDT TQ15 Inspection catalog type index MANDT
QAIMV KATALGART2 QAIMV KATALGART2 TQ15 Inspection catalog type index KATALOGART
QAIMV KATALGART3 SYST MANDT TQ15 Inspection catalog type index MANDT
QAIMV KATALGART3 QAIMV KATALGART3 TQ15 Inspection catalog type index KATALOGART
QAIMV KATALGART4 QAIMV KATALGART4 TQ15 Inspection catalog type index KATALOGART
QAIMV KATALGART4 SYST MANDT TQ15 Inspection catalog type index MANDT
QAIMV KATALGART5 SYST MANDT TQ15 Inspection catalog type index MANDT
QAIMV KATALGART5 QAIMV KATALGART5 TQ15 Inspection catalog type index KATALOGART
QAIMV MASSEINHSW QAIMV MASSEINHSW T006 Units of Measurement MSEHI
QAIMV MASSEINHSW SYST MANDT T006 Units of Measurement MANDT
QAIMV MERKGEW SYST MANDT TQ17A Characteristic weightings MANDT
QAIMV MERKGEW QAIMV MERKGEW TQ17A Characteristic weightings MERKKLASSE
QAIMV PMETHODE QAIMV MKVERSION QMTB Inspection method master record VERSION
QAIMV PMETHODE QAIMV PMETHODE QMTB Inspection method master record PMTNR
QAIMV PMETHODE QAIMV QMTB_WERKS QMTB Inspection method master record WERKS
QAIMV PMETHODE SYST MANDT QMTB Inspection method master record MANDT
QAIMV PRUEFLOS SYST MANDT QALS Inspection lot record MANDANT
QAIMV PRUEFLOS QAIMV PRUEFLOS QALS Inspection lot record PRUEFLOS
QAIMV QMTB_WERKS QAIMV QMTB_WERKS T001W Plants/Branches WERKS
QAIMV QMTB_WERKS SYST MANDT T001W Plants/Branches MANDT
QAIMV QRKNR SYST MANDT QASH Quality control chart MANDT
QAIMV QRKNR QAIMV QRKNR QASH Quality control chart QRKNR
QAIMV VERWMERKM QAIMV MKVERSION QPMK Inspection characteristic master VERSION
QAIMV VERWMERKM QAIMV VERWMERKM QPMK Inspection characteristic master MKMNR
QAIMV VERWMERKM QAIMV QPMK_WERKS QPMK Inspection characteristic master ZAEHLER
QAIMV VERWMERKM SYST MANDT QPMK Inspection characteristic master MANDT