SAP Table QASE

Results table for the sample unit

QASE (Results table for the sample unit) 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 QASE to other SAP tables.

QASE table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
PRUEFLOS Inspection Lot Number QPLOS QALS NUMC 12 0
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
DETAILERG Number of the Individual Result QDETAILERG NUMC 8 0
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
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELLDAT Date on Which the Data Record Was Created QDATUMERST DATS 8 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDAT Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
PROBENR Sample Number QPROBENR QASV NUMC 6 0
STUECKNR Counter for Inspection Unit Number QSTUECKNR NUMC 4 0
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
PRUEFDATUV Inspection Start Date QPRUEFDATV DATS 8 0
PRUEFDATUB End Date of the Inspection QPRUEFDATB DATS 8 0
PRUEFZEITV Starting Time of the Inspection QPRUEFZTV TIMS 6 0
PRUEFZEITB End Time of the Inspection QPRUEFZTB TIMS 6 0
PRUEFBEMKT Short Text QKURZTEXT CHAR 40 0
PRLTEXTKZ Inspection Characteristic Long Text Exists QLTEXTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
LTEXTSPR Language Key SPRAS T002 LANG 1 0
MESSWERTNI Measured Value is Not Initial QMESSWRTNI CHAR 1 0
NULL Value is initial
X Value was set manually
* Value was calculated internally
MESSWERT Measured Value for a Sample Unit QMESSWERT FLTP 16 16
KATALGART1 Catalog QKATART TQ15 CHAR 1 0
GRUPPE1 Code Group QCODEGRP CHAR 8 0
CODE1 Code QCODE CHAR 4 0
VERSION1 Version Number QVERSNR CHAR 6 0
KATALGART2 Catalog QKATART TQ15 CHAR 1 0
GRUPPE2 Code Group QCODEGRP CHAR 8 0
CODE2 Code QCODE CHAR 4 0
VERSION2 Version Number QVERSNR CHAR 6 0
KATALGART3 Catalog QKATART TQ15 CHAR 1 0
GRUPPE3 Code Group QCODEGRP CHAR 8 0
CODE3 Code QCODE CHAR 4 0
VERSION3 Version Number QVERSNR CHAR 6 0
KATALGART4 Catalog QKATART TQ15 CHAR 1 0
GRUPPE4 Code Group QCODEGRP CHAR 8 0
CODE4 Code QCODE CHAR 4 0
VERSION4 Version Number QVERSNR CHAR 6 0
KATALGART5 Catalog QKATART TQ15 CHAR 1 0
GRUPVERS5 Version Number QVERSNR CHAR 6 0
GRUPPE5 Code Group QCODEGRP CHAR 8 0
CODE5 Code QCODE CHAR 4 0
VERSION5 Version Number QVERSNR CHAR 6 0
ANZFEHLER Number of Defects Found QANZFEHL1 INT1 3 0
FEHLKLAS Defect Class QFEHLKLAS TQ17 CHAR 2 0
MBEWERTG Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
ESTUECKNR Number of the Single Unit in the Inspection Lot QESTUECKNR QAES NUMC 4 0
SERIALNR Single-Unit Number for the Unit to Be Inspected QSERIALNR CHAR 18 0
MASCHINE General Information QMASCHINE CHAR 18 0
POSITION Test Position QPRPOS NUMC 4 0
ZEITERSTL Time at which data record was created QZEITERSTL TIMS 6 0
ZEITAEND Time at which data record was last changed QZEITAEND TIMS 6 0
ORIGINAL_INPUT Original Value Before Input Processing QORIGINAL_INPUT CHAR 25 0
DIFF_DEC_PLACES Different Number of Decimal Places QDIFF_DEC_PLACES INT2 5 0
INPPROC_READY Input Processing Successfully Completed QINPPROC_READY CHAR 1 0
NULL Indicator is not set
X Indicator is set

QASE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QASE ESTUECKNR QASE MANDANT QAES Sample unit table MANDANT
QASE ESTUECKNR QASE PRUEFLOS QAES Sample unit table PRUEFLOS
QASE ESTUECKNR QASE ESTUECKNR QAES Sample unit table ESTUECKNR
QASE FEHLKLAS QASE MANDANT TQ17 Defect classes MANDT
QASE FEHLKLAS QASE FEHLKLAS TQ17 Defect classes FEHLKLASSE
QASE KATALGART1 QASE MANDANT TQ15 Inspection catalog type index MANDT
QASE KATALGART1 QASE KATALGART1 TQ15 Inspection catalog type index KATALOGART
QASE KATALGART2 QASE MANDANT TQ15 Inspection catalog type index MANDT
QASE KATALGART2 QASE KATALGART2 TQ15 Inspection catalog type index KATALOGART
QASE KATALGART3 QASE MANDANT TQ15 Inspection catalog type index MANDT
QASE KATALGART3 QASE KATALGART3 TQ15 Inspection catalog type index KATALOGART
QASE KATALGART4 QASE KATALGART4 TQ15 Inspection catalog type index KATALOGART
QASE KATALGART4 QASE MANDANT TQ15 Inspection catalog type index MANDT
QASE KATALGART5 QASE MANDANT TQ15 Inspection catalog type index MANDT
QASE KATALGART5 QASE KATALGART5 TQ15 Inspection catalog type index KATALOGART
QASE LTEXTSPR QASE LTEXTSPR T002 Language Keys (Component BC-I18) SPRAS
QASE MANDANT QASE MANDANT T000 Clients MANDT
QASE PROBENR QASE MERKNR QASV Sample specifications for inspection processing MERKNR
QASE PROBENR QASE PROBENR QASV Sample specifications for inspection processing PROBENR
QASE PROBENR QASE MANDANT QASV Sample specifications for inspection processing MANDANT
QASE PROBENR QASE PRUEFLOS QASV Sample specifications for inspection processing PRUEFLOS
QASE PROBENR QASE VORGLFNR QASV Sample specifications for inspection processing VORGLFNR
QASE PRUEFLOS QASE MANDANT QALS Inspection lot record MANDANT
QASE PRUEFLOS QASE PRUEFLOS QALS Inspection lot record PRUEFLOS