SAP table QAIMR (Structure for Uploading Charac. Results from QM Subsystem)

SAP table QAIMR has 2 primary key fields being SATZART,RUECKMELNR.

Field Description Data Type Length Decimals Checktable Data Element
SATZART Record Types for QM Interface - Subsystems CHAR 3 0 QEIFART
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 NUMC 8 0 QRUECKNR
KZABSCHL Close Characteristic or Sample CHAR 1 0 QEIFABSCHL
KZBEWEEXT Copy Valuation from External System CHAR 1 0 QEIFBEWE
ATTRIBUT Attribute of the Results Record (Valid, Invalid,...) CHAR 1 0 QATTRIBUT
Result is valid (default)
# Result not determinable; valid result
& Error occurred during results transfer
( Customer attribute '('; valid result
) Customer attribute ')'; invalid result
* Result considered an outlier; valid result
/ Invalid result
< True value is less than or less equal to; valid result
> True value is greater than or greater equal to; valid result
? Result was estimated; valid 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
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
[ Customer attribute '['; valid result
\ Result is not current; invalid result
] Customer attribute ']'; invalid result
{ Customer attribute '{'; valid result
} Customer attribute '}'; invalid result
~ Result not proven; valid result
≤ True value is less than or equal to; valid result
≥ True value is greater than or equal to; valid result
MBEWERTG Inspection Result Valuation CHAR 1 0 QMBEWERTG
FEHLKLAS Defect Class CHAR 2 0 TQ17 QFEHLKLAS
GRUPPE1 Code Group CHAR 8 0 QPGR QCODEGRP
CODE1 Code CHAR 4 0 QPCD QCODE
GRUPPE2 Code Group CHAR 8 0 QPGR QCODEGRP
CODE2 Code CHAR 4 0 QPCD QCODE
GRUPPE3 Code Group CHAR 8 0 QPGR QCODEGRP
CODE3 Code CHAR 4 0 QPCD QCODE
GRUPPE4 Code Group CHAR 8 0 QPGR QCODEGRP
CODE4 Code CHAR 4 0 QPCD QCODE
GRUPPE5 Code Group CHAR 8 0 QPGR QCODEGRP
CODE5 Code CHAR 4 0 QPCD QCODE
ANZWERTG No. of Valid Values for Char. Results Upload to QM Subsys. CHAR 7 0 QEIFAWERTG
ANZFEHLEH No. of Nonconforming Units for Char. Confirmation via QM-IDI CHAR 7 0 QEIFAFEEH
ANZFEHLER Number of Defects for Confirmation of Charac. via QM-IDI CHAR 7 0 QEIFAFEHL
ANZWERTO Number of Values Above the Tolerance Limit (Characteristic) CHAR 7 0 QEIFAWRTO
ANZWERTU Number of Values Below the Tolerance Limit (Characteristic) CHAR 7 0 QEIFAWRTU
MITTELWERT Arithmetic Mean of Valid Measured Values CHAR 16 0 QMITTEWRTC
VARIANZ Dispersion (Variance) of Valid Measured Values CHAR 16 0 QVARIANZC
MAXWERT Maximum Value of the Valid Measured Values CHAR 16 0 QMAXWERTC
MEDIANWERT Median of Valid Measured Values CHAR 16 0 QMEDIAWRTC
MINWERT Minimum Value of the Valid Measured Values CHAR 16 0 QMINWERTC
IVARIANZ Internal Dispersion of Valid Measured Values CHAR 16 0 QIVARIANZC
PRUEFDATUV Inspection Start Date (QM Subsystem Interface) DATS 8 0 QEIFPRDATV
PRUEFDATUB Inspection End Date (QM Subsystem Interface) DATS 8 0 QEIFPRDATB
PRUEFZEITV Inspection Start Time (QM Subsystem Interface) TIMS 6 0 QEIFPRZTV
PRUEFZEITB Inspection End Time (QM Subsystem Interface) TIMS 6 0 QEIFPRZTB
PRUEFER Name of Inspector CHAR 12 0 QPRUEFER
QERGDATH Data Origin CHAR 2 0 QRES_ORG
MASCHINE General Information CHAR 18 0 QMASCHINE
POSITION Position on the Machine (QM Interface - Subsystem) CHAR 4 0 QEIFPOSMAS
PRUEFBEMKT Short Text CHAR 40 0 QKURZTEXT
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS

QAIMR foreign key relationships

Table Field Check Table Check Field
0 QAIMR CODE1 QPCD Inspection catalog codes MANDT
0 QAIMR CODE1 QPCD Inspection catalog codes KATALOGART
0 QAIMR CODE1 QPCD Inspection catalog codes CODEGRUPPE
0 QAIMR CODE1 QPCD Inspection catalog codes CODE
0 QAIMR CODE1 QPCD Inspection catalog codes VERSION
1 QAIMR CODE2 QPCD Inspection catalog codes MANDT
1 QAIMR CODE2 QPCD Inspection catalog codes KATALOGART
1 QAIMR CODE2 QPCD Inspection catalog codes CODEGRUPPE
1 QAIMR CODE2 QPCD Inspection catalog codes CODE
1 QAIMR CODE2 QPCD Inspection catalog codes VERSION
0 QAIMR CODE3 QPCD Inspection catalog codes MANDT
0 QAIMR CODE3 QPCD Inspection catalog codes KATALOGART
0 QAIMR CODE3 QPCD Inspection catalog codes CODEGRUPPE
0 QAIMR CODE3 QPCD Inspection catalog codes CODE
0 QAIMR CODE3 QPCD Inspection catalog codes VERSION
1 QAIMR CODE4 QPCD Inspection catalog codes MANDT
1 QAIMR CODE4 QPCD Inspection catalog codes KATALOGART
1 QAIMR CODE4 QPCD Inspection catalog codes CODEGRUPPE
1 QAIMR CODE4 QPCD Inspection catalog codes CODE
1 QAIMR CODE4 QPCD Inspection catalog codes VERSION
0 QAIMR CODE5 QPCD Inspection catalog codes MANDT
0 QAIMR CODE5 QPCD Inspection catalog codes KATALOGART
0 QAIMR CODE5 QPCD Inspection catalog codes CODEGRUPPE
0 QAIMR CODE5 QPCD Inspection catalog codes CODE
0 QAIMR CODE5 QPCD Inspection catalog codes VERSION
1 QAIMR FEHLKLAS TQ17 Defect classes MANDT
0 QAIMR GRUPPE1 QPGR Inspection catalog code groups MANDT
0 QAIMR GRUPPE1 QPGR Inspection catalog code groups KATALOGART
1 QAIMR GRUPPE2 QPGR Inspection catalog code groups MANDT
1 QAIMR GRUPPE2 QPGR Inspection catalog code groups KATALOGART
0 QAIMR GRUPPE3 QPGR Inspection catalog code groups MANDT
0 QAIMR GRUPPE3 QPGR Inspection catalog code groups KATALOGART
1 QAIMR GRUPPE4 QPGR Inspection catalog code groups MANDT
1 QAIMR GRUPPE4 QPGR Inspection catalog code groups KATALOGART
0 QAIMR GRUPPE5 QPGR Inspection catalog code groups MANDT
0 QAIMR GRUPPE5 QPGR Inspection catalog code groups KATALOGART