Follow us on LinkedIn for your next SAP project
← Back to Search

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 Possible values
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
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
DBEWERTG
Valuation of the Characteristic for Dynamic Modification
 QDBEWERTG
CHAR
 1 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
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
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
MEDIANNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
MINWERTNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
MITTELWNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
VARIANZNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
MOMENT3NI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
MOMENT4NI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
ANTEILONI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
ANTEILUNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
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
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
KZBEWERTG
Valuation Copied or Forced
 QKZBEWERTG
CHAR
 1 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
SIGN_ID
Digital Signature for Process
 SIGN_GUID_22_CHG
CHAR
 22 0
SIGN_STATE
Status of Signature Process
 SIGN_STATE
CHAR
 1 0

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 MANDANT TQ15
Inspection catalog type index
 MANDT
QASR KATALGART3 QASR KATALGART3 TQ15
Inspection catalog type index
 KATALOGART
QASR KATALGART4 QASR KATALGART4 TQ15
Inspection catalog type index
 KATALOGART
QASR KATALGART4 QASR MANDANT TQ15
Inspection catalog type index
 MANDT
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 PROBENR QASV
Sample specifications for inspection processing
 PROBENR
QASR PROBENR QASR MANDANT QASV
Sample specifications for inspection processing
 MANDANT
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 PRUEFLOS QASR MANDANT QALS
Inspection lot record
 MANDANT
QASR PRUEFLOS QASR PRUEFLOS QALS
Inspection lot record
 PRUEFLOS
QASR QERGDATH QASR QERGDATH TQ73
Origin of results data
 QERGDATH
QASR QERGDATH QASR MANDANT TQ73
Origin of results data
 MANDT
QASR SATZSTATUS QASR SATZSTATUS TQ76
Processing status of inspection characteristics
 STATUS