1. Home
  2. Resources
  3. SAP Tables
  4. QASR - Sample results for inspection characteristics

SAP Table QASR

Sample results for inspection characteristics

QASR (Sample results for inspection characteristics) 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 QASR to other SAP tables.

QASR 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
PROBENR Number of the Partial Sample QSTIPRONR QASV NUMC 6 0
SATZSTATUS Results Record Status QBEASTATUS TQ76 CHAR 1 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
QERGDATH Origin of Results Data QERGDATH TQ73 CHAR 2 0
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
MBEWERTG Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
DBEWERTG Valuation of the Characteristic for Dynamic Modification QDBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
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
ISTSTPUMF Number of Recorded Sample Units QISTSTPUMF INT4 10 0
ANZFEHLEH Number of Nonconforming Sample Units QANZFEHEH2 INT2 5 0
ANTEILNI Not Initialized for Fraction QNIANTEIL CHAR 1 0
NULL Value is initial
X Value was set manually
* Value was calculated internally
ANTEIL Estimated Fraction of Nonconforming Sample Units QANTEIL FLTP 16 16
ANZFEHLER Number of Defects Found QANZFEHL2 INT2 5 0
ANZWERTO Number of Measured Values Above the Tolerance Range QANZWERTO2 INT2 5 0
ANZWERTU Number of Measured Values Below the Tolerance Range QANZWERTU2 INT2 5 0
ANZWERTG Number of Inspected Sample Units QANZWERTG2 INT2 5 0
MAXWERTNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MEDIANNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MINWERTNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MITTELWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
VARIANZNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MOMENT3NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MOMENT4NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILONI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILUNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MAXWERT Maximum Value of the Valid Measured Values QMAXWERT FLTP 16 16
MEDIANWERT Median of Valid Measured Values QMEDIANWRT FLTP 16 16
MINWERT Minimum Value of the Valid Measured Values QMINWERT FLTP 16 16
MITTELWERT Arithmetic Mean of Valid Measured Values QMITTELWRT FLTP 16 16
VARIANZ Dispersion (Variance) of Valid Measured Values QVARIANZ FLTP 16 16
MOMENT3 Third Central Moment of Valid Measured Values QMOMENT3 FLTP 16 16
MOMENT4 Fourth Central Moment of Valid Measured Values QMOMENT4 FLTP 16 16
ANTEILO Estimated Fraction Above the Tolerance Range QANTEILO FLTP 16 16
ANTEILU Estimated Fraction Below the Tolerance Range QANTEILU FLTP 16 16
KATALGART1 Catalog Type of Assigned Code Group or Selected Set QKATAUSW 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 Type of Assigned Code Group or Selected Set QKATAUSW 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 Type of Assigned Code Group or Selected Set QKATAUSW 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 Type of Assigned Code Group or Selected Set QKATAUSW 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 Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE5 Code Group QCODEGRP CHAR 8 0
CODE5 Code QCODE CHAR 4 0
VERSION5 Version Number QVERSNR CHAR 6 0
FEHLKLAS Defect Class QFEHLKLAS TQ17 CHAR 2 0
SENDEFLAG Characteristic Result Confirmation from Control Station QSENDEFLAG CHAR 1 0
NULL Characteristic result was not confirmed
1 First confirmation of characteristic result
2 Correction confirmation of characteristic result
MASCHINE General Information QMASCHINE CHAR 18 0
POSITION Test Position QPRPOS NUMC 4 0
AENDBELEG Create Change Documents During Results Recording QKZAENBEL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZBEWERTG Valuation Copied or Forced QKZBEWERTG CHAR 1 0
NULL Valuation and/or close using plan specifications
* Manual valuation was forced
X Valuation imported from another system (e.g. subsystem)
- Valuation imported internally, e.g. from a differnt char.
+ Manual valuation and forced closure
. Valuation imported externally and forced closure
/ Valuation using specifications, forced closure
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
SIGN_ID Digital Signature for Process SIGN_GUID_22_CHG CHAR 22 0
SIGN_STATE Status of Signature Process SIGN_STATE CHAR 1 0
NULL New Signature Process
1 Completed Signature Process
2 Canceled Signature Process
3 Current Signature Process

QASR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QASR FEHLKLAS QASR MANDANT TQ17 Defect classes MANDT
QASR FEHLKLAS QASR FEHLKLAS TQ17 Defect classes FEHLKLASSE
QASR KATALGART1 QASR MANDANT TQ15 Inspection catalog type index MANDT
QASR KATALGART1 QASR KATALGART1 TQ15 Inspection catalog type index KATALOGART
QASR KATALGART2 QASR MANDANT TQ15 Inspection catalog type index MANDT
QASR KATALGART2 QASR KATALGART2 TQ15 Inspection catalog type index KATALOGART
QASR KATALGART3 QASR KATALGART3 TQ15 Inspection catalog type index KATALOGART
QASR KATALGART3 QASR MANDANT TQ15 Inspection catalog type index MANDT
QASR KATALGART4 QASR MANDANT TQ15 Inspection catalog type index MANDT
QASR KATALGART4 QASR KATALGART4 TQ15 Inspection catalog type index KATALOGART
QASR KATALGART5 QASR MANDANT TQ15 Inspection catalog type index MANDT
QASR KATALGART5 QASR KATALGART5 TQ15 Inspection catalog type index KATALOGART
QASR LTEXTSPR QASR LTEXTSPR T002 Language Keys (Component BC-I18) SPRAS
QASR MANDANT QASR MANDANT T000 Clients MANDT
QASR PROBENR QASR PRUEFLOS QASV Sample specifications for inspection processing PRUEFLOS
QASR PROBENR QASR VORGLFNR QASV Sample specifications for inspection processing VORGLFNR
QASR PROBENR QASR MERKNR QASV Sample specifications for inspection processing MERKNR
QASR PROBENR QASR PROBENR QASV Sample specifications for inspection processing PROBENR
QASR PROBENR QASR MANDANT QASV Sample specifications for inspection processing MANDANT
QASR PRUEFLOS QASR MANDANT QALS Inspection lot record MANDANT
QASR PRUEFLOS QASR PRUEFLOS QALS Inspection lot record PRUEFLOS
QASR QERGDATH QASR MANDANT TQ73 Origin of results data MANDT
QASR QERGDATH QASR QERGDATH TQ73 Origin of results data QERGDATH
QASR SATZSTATUS QASR SATZSTATUS TQ76 Processing status of inspection characteristics STATUS