SAP Table QAISR

Structure for uploading sample results from QM subsystem

QAISR (Structure for uploading sample 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 QAISR to other SAP tables.

QAISR 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
PROBENR Number of the Partial Sample QSTIPRONR QASV NUMC 6 0
KZLPROBE Last Original Value, Sample or Inspection Point QEIFKZENDE CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
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 Sample Results Upload to QM subsys. QEIFANZWRT NUMC 4 0
ANZFEHLEH Number of Nonconforming Units for QM Subsystem Interface QEIFAFHLEH CHAR 4 0
ANZFEHLER Number of Defects for Sample Confirmation Using QM-IDI QEIFANZFHL CHAR 4 0
ANZWERTO Number of Values Above Tolerance Limit (Sample) QEIFAWERTO CHAR 4 0
ANZWERTU Number of Values Below the Tolerance Limit (Sample) QEIFAWERTU CHAR 4 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
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
MBEWERTGPR Valuation of Sample for Usage Decision QEIFMPRBEW CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
FEHLKLASPR Defect Class QFEHLKLAS TQ17 CHAR 2 0
MBEWERTGMK Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
FEHLKLASMK Defect Class QFEHLKLAS TQ17 CHAR 2 0

QAISR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAISR CODE1 SYST MANDT QPCD Inspection catalog codes MANDT
QAISR CODE1 QAIMV KATALGART1 QPCD Inspection catalog codes KATALOGART
QAISR CODE1 QAISR GRUPPE1 QPCD Inspection catalog codes CODEGRUPPE
QAISR CODE1 QAISR CODE1 QPCD Inspection catalog codes CODE
QAISR CODE1 * QPCD Inspection catalog codes VERSION
QAISR CODE2 SYST MANDT QPCD Inspection catalog codes MANDT
QAISR CODE2 QAIMV KATALGART2 QPCD Inspection catalog codes KATALOGART
QAISR CODE2 QAISR GRUPPE1 QPCD Inspection catalog codes CODEGRUPPE
QAISR CODE2 QAISR CODE2 QPCD Inspection catalog codes CODE
QAISR CODE2 * QPCD Inspection catalog codes VERSION
QAISR CODE3 SYST MANDT QPCD Inspection catalog codes MANDT
QAISR CODE3 QAIMV KATALGART3 QPCD Inspection catalog codes KATALOGART
QAISR CODE3 QAISR GRUPPE3 QPCD Inspection catalog codes CODEGRUPPE
QAISR CODE3 QAISR CODE3 QPCD Inspection catalog codes CODE
QAISR CODE3 * QPCD Inspection catalog codes VERSION
QAISR CODE4 SYST MANDT QPCD Inspection catalog codes MANDT
QAISR CODE4 QAIMV KATALGART4 QPCD Inspection catalog codes KATALOGART
QAISR CODE4 QAISR GRUPPE4 QPCD Inspection catalog codes CODEGRUPPE
QAISR CODE4 QAISR CODE4 QPCD Inspection catalog codes CODE
QAISR CODE4 * QPCD Inspection catalog codes VERSION
QAISR CODE5 QAIMV KATALGART5 QPCD Inspection catalog codes KATALOGART
QAISR CODE5 QAISR GRUPPE5 QPCD Inspection catalog codes CODEGRUPPE
QAISR CODE5 QAISR CODE5 QPCD Inspection catalog codes CODE
QAISR CODE5 * QPCD Inspection catalog codes VERSION
QAISR CODE5 SYST MANDT QPCD Inspection catalog codes MANDT
QAISR FEHLKLASMK SYST MANDT TQ17 Defect classes MANDT
QAISR FEHLKLASMK QAISR FEHLKLASMK TQ17 Defect classes FEHLKLASSE
QAISR FEHLKLASPR SYST MANDT TQ17 Defect classes MANDT
QAISR FEHLKLASPR QAISR FEHLKLASPR TQ17 Defect classes FEHLKLASSE
QAISR GRUPPE1 QAIMV KATALGART1 QPGR Inspection catalog code groups KATALOGART
QAISR GRUPPE1 QAISR GRUPPE1 QPGR Inspection catalog code groups CODEGRUPPE
QAISR GRUPPE1 SYST MANDT QPGR Inspection catalog code groups MANDT
QAISR GRUPPE2 SYST MANDT QPGR Inspection catalog code groups MANDT
QAISR GRUPPE2 QAIMV KATALGART2 QPGR Inspection catalog code groups KATALOGART
QAISR GRUPPE2 QAISR GRUPPE2 QPGR Inspection catalog code groups CODEGRUPPE
QAISR GRUPPE3 SYST MANDT QPGR Inspection catalog code groups MANDT
QAISR GRUPPE3 QAIMV KATALGART3 QPGR Inspection catalog code groups KATALOGART
QAISR GRUPPE3 QAISR GRUPPE3 QPGR Inspection catalog code groups CODEGRUPPE
QAISR GRUPPE4 SYST MANDT QPGR Inspection catalog code groups MANDT
QAISR GRUPPE4 QAIMV KATALGART4 QPGR Inspection catalog code groups KATALOGART
QAISR GRUPPE4 QAISR GRUPPE4 QPGR Inspection catalog code groups CODEGRUPPE
QAISR GRUPPE5 SYST MANDT QPGR Inspection catalog code groups MANDT
QAISR GRUPPE5 QAIMV KATALGART5 QPGR Inspection catalog code groups KATALOGART
QAISR GRUPPE5 QAISR GRUPPE5 QPGR Inspection catalog code groups CODEGRUPPE
QAISR PROBENR QAISR PROBENR QASV Sample specifications for inspection processing PROBENR
QAISR PROBENR SYST MANDT QASV Sample specifications for inspection processing MANDANT
QAISR PROBENR QASV PRUEFLOS QASV Sample specifications for inspection processing PRUEFLOS
QAISR PROBENR QASV VORGLFNR QASV Sample specifications for inspection processing VORGLFNR
QAISR PROBENR QASV MERKNR QASV Sample specifications for inspection processing MERKNR