SAP Table QAISE

Structure for uploading single values from QM subsystem

QAISE (Structure for uploading single values 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 QAISE to other SAP tables.

QAISE 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
STUECKNR Counter for Inspection Unit Number QSTUECKNR NUMC 4 0
KZSERNR Serial Number To Be Recorded in QM Subsystem QEIFSERNR CHAR 1 0
NULL Indicator is not set
X Indicator is set
SERIALNR Single-Unit Number for the Unit to Be Inspected QSERIALNR CHAR 18 0
KZLWERT Last Original Value, Sample or Inspection Point QEIFKZENDE CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
MESSWERT Measured Value for a Sample Unit QMESSWERTC CHAR 16 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
BEWERTUNG Valuation of Original Value - Upload to QM Subsystem QEIFBEWURW CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
FEHLKLAS Defect Class QFKLASERG TQ17 CHAR 2 0
ANZFEHLER Number of Defects for Confirming Indiv. Units via QM-IDI QEIFAFHL2 CHAR 2 0
PRUEFDATUV Inspection Start Date (QM Subsystem Interface) QEIFPRDATV DATS 8 0
PRUEFZEITV Inspection Start Time (QM Subsystem Interface) QEIFPRZTV 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

QAISE foreign key relationships

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