SAP Table QAIMR

Structure for Uploading Charac. Results from QM Subsystem

QAIMR (Structure for Uploading Charac. Results from QM Subsystem) 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 QAIMR to other SAP tables.

Source: QAIMR (Structure for Uploading Charac. Results from QM Subsystem)

QAIMR 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
KZABSCHL Close Characteristic or Sample QEIFABSCHL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZBEWEEXT Copy Valuation from External System QEIFBEWE CHAR 1 0
NULL Indicator is not set
X Indicator is set
ATTRIBUT Attribute of the Results Record (Valid, Invalid,...) QATTRIBUT CHAR 1 0
NULL Result is valid (default)
< The true value is less or equal to; valid result
> The true value is greater or equal to; valid result
? The result was estimated; valid result
* Result considerede an outlier; valid result
/ Invalid result
( Customer attribute '('; valid result
) Customer attribute '('; invalid result
[ Customer attribute '['; valid result
] Customer attribute '['; invalid result
{ Customer attribute '{'; valid result
} Customer attribute '}'; invalid result
~ Result not proven; valid result
# Result not determinable; valid result
U Customer attribute 'U'; valid result
V Customer attribute 'V'; valid result
W Customer attribute 'W'; valid result
X Customer attribute 'X'; invalid result
Y Customer attribute 'Y'; invalid result
Z Customer attribute 'Z'; invalid result
A Formula: Calculation input characteristic is inappropriate
B Formula: Calculation input characteristic does not exist
C Formula: Syntax error
D Formula: Calculation input charac. has an incorrect format
E Formula: Error during values' trans. for calc. input charac.
F Formula: Arithmetic error during formula calculation
G Formula: Not all single results were calculated
H Formula: Error when calculating single units
& Error occurred during results transfer
\ Result is not current; invalid result
MBEWERTG Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
FEHLKLAS Defect Class QFEHLKLAS TQ17 CHAR 2 0
GRUPPE1 Code Group QCODEGRP QPGR CHAR 8 0
CODE1 Code QCODE QPCD CHAR 4 0
GRUPPE2 Code Group QCODEGRP QPGR CHAR 8 0
CODE2 Code QCODE QPCD CHAR 4 0
GRUPPE3 Code Group QCODEGRP QPGR CHAR 8 0
CODE3 Code QCODE QPCD CHAR 4 0
GRUPPE4 Code Group QCODEGRP QPGR CHAR 8 0
CODE4 Code QCODE QPCD CHAR 4 0
GRUPPE5 Code Group QCODEGRP QPGR CHAR 8 0
CODE5 Code QCODE QPCD CHAR 4 0
ANZWERTG No. of Valid Values for Char. Results Upload to QM Subsys. QEIFAWERTG CHAR 7 0
ANZFEHLEH No. of Nonconforming Units for Char. Confirmation via QM-IDI QEIFAFEEH CHAR 7 0
ANZFEHLER Number of Defects for Confirmation of Charac. via QM-IDI QEIFAFEHL CHAR 7 0
ANZWERTO Number of Values Above the Tolerance Limit (Characteristic) QEIFAWRTO CHAR 7 0
ANZWERTU Number of Values Below the Tolerance Limit (Characteristic) QEIFAWRTU CHAR 7 0
MITTELWERT Arithmetic Mean of Valid Measured Values QMITTEWRTC CHAR 16 0
VARIANZ Dispersion (Variance) of Valid Measured Values QVARIANZC CHAR 16 0
MAXWERT Maximum Value of the Valid Measured Values QMAXWERTC CHAR 16 0
MEDIANWERT Median of Valid Measured Values QMEDIAWRTC CHAR 16 0
MINWERT Minimum Value of the Valid Measured Values QMINWERTC CHAR 16 0
IVARIANZ Internal Dispersion of Valid Measured Values QIVARIANZC CHAR 16 0
PRUEFDATUV Inspection Start Date (QM Subsystem Interface) QEIFPRDATV DATS 8 0
PRUEFDATUB Inspection End Date (QM Subsystem Interface) QEIFPRDATB DATS 8 0
PRUEFZEITV Inspection Start Time (QM Subsystem Interface) QEIFPRZTV TIMS 6 0
PRUEFZEITB Inspection End Time (QM Subsystem Interface) QEIFPRZTB TIMS 6 0
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
QERGDATH Data Origin QRES_ORG CHAR 2 0
MASCHINE General Information QMASCHINE CHAR 18 0
POSITION Position on the Machine (QM Interface - Subsystem) QEIFPOSMAS CHAR 4 0
PRUEFBEMKT Short Text QKURZTEXT CHAR 40 0

QAIMR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAIMR CODE1 * QPCD Inspection catalog codes VERSION
QAIMR CODE1 QAIMR CODE1 QPCD Inspection catalog codes CODE
QAIMR CODE1 QAIMR GRUPPE1 QPCD Inspection catalog codes CODEGRUPPE
QAIMR CODE1 QAIMV KATALGART1 QPCD Inspection catalog codes KATALOGART
QAIMR CODE1 SYST MANDT QPCD Inspection catalog codes MANDT
QAIMR CODE2 QAIMR GRUPPE2 QPCD Inspection catalog codes CODEGRUPPE
QAIMR CODE2 QAIMV KATALGART2 QPCD Inspection catalog codes KATALOGART
QAIMR CODE2 SYST MANDT QPCD Inspection catalog codes MANDT
QAIMR CODE2 QAIMR CODE2 QPCD Inspection catalog codes CODE
QAIMR CODE2 * QPCD Inspection catalog codes VERSION
QAIMR CODE3 QAIMR GRUPPE3 QPCD Inspection catalog codes CODEGRUPPE
QAIMR CODE3 SYST MANDT QPCD Inspection catalog codes MANDT
QAIMR CODE3 QAIMV KATALGART3 QPCD Inspection catalog codes KATALOGART
QAIMR CODE3 QAIMR CODE3 QPCD Inspection catalog codes CODE
QAIMR CODE3 * QPCD Inspection catalog codes VERSION
QAIMR CODE4 SYST MANDT QPCD Inspection catalog codes MANDT
QAIMR CODE4 QAIMV KATALGART4 QPCD Inspection catalog codes KATALOGART
QAIMR CODE4 QAIMR GRUPPE4 QPCD Inspection catalog codes CODEGRUPPE
QAIMR CODE4 QAIMR CODE4 QPCD Inspection catalog codes CODE
QAIMR CODE4 * QPCD Inspection catalog codes VERSION
QAIMR CODE5 * QPCD Inspection catalog codes VERSION
QAIMR CODE5 SYST MANDT QPCD Inspection catalog codes MANDT
QAIMR CODE5 QAIMV KATALGQRT5 QPCD Inspection catalog codes KATALOGART
QAIMR CODE5 QAIMR GRUPPE5 QPCD Inspection catalog codes CODEGRUPPE
QAIMR CODE5 QAIMR CODE5 QPCD Inspection catalog codes CODE
QAIMR FEHLKLAS SYST MANDT TQ17 Defect classes MANDT
QAIMR FEHLKLAS QAIMR FEHLKLAS TQ17 Defect classes FEHLKLASSE
QAIMR GRUPPE1 SYST MANDT QPGR Inspection catalog code groups MANDT
QAIMR GRUPPE1 QAIMV KATALGART1 QPGR Inspection catalog code groups KATALOGART
QAIMR GRUPPE1 QAIMR GRUPPE1 QPGR Inspection catalog code groups CODEGRUPPE
QAIMR GRUPPE2 SYST MANDT QPGR Inspection catalog code groups MANDT
QAIMR GRUPPE2 QAIMV KATALGART2 QPGR Inspection catalog code groups KATALOGART
QAIMR GRUPPE2 QAIMR GRUPPE2 QPGR Inspection catalog code groups CODEGRUPPE
QAIMR GRUPPE3 SYST MANDT QPGR Inspection catalog code groups MANDT
QAIMR GRUPPE3 QAIMV KATALGART3 QPGR Inspection catalog code groups KATALOGART
QAIMR GRUPPE3 QAIMR GRUPPE3 QPGR Inspection catalog code groups CODEGRUPPE
QAIMR GRUPPE4 SYST MANDT QPGR Inspection catalog code groups MANDT
QAIMR GRUPPE4 QAIMV KATALGART4 QPGR Inspection catalog code groups KATALOGART
QAIMR GRUPPE4 QAIMR GRUPPE4 QPGR Inspection catalog code groups CODEGRUPPE
QAIMR GRUPPE5 QAIMR GRUPPE5 QPGR Inspection catalog code groups CODEGRUPPE
QAIMR GRUPPE5 SYST MANDT QPGR Inspection catalog code groups MANDT
QAIMR GRUPPE5 QAIMV KATALGART5 QPGR Inspection catalog code groups KATALOGART