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

SAP Table QAMR

Characteristic results during inspection processing

QAMR (Characteristic results during inspection processing) 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 QAMR to other SAP tables.

QAMR 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
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
DBEWERTG
Valuation of the Characteristic for Dynamic Modification
 QDBEWERTG
CHAR
 1 0
MBEWERTG
Inspection Result Valuation
 QMBEWERTG
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
ISTSTPANZ
Number of Partial Samples for the Characteristic
 QANZSTIPRO
INT2
 5 0
ISTSTPUMF
Number of Recorded Sample Units
 QISTSTPUMF
INT4
 10 0
ANZFEHLEH
Number of Nonconforming Sample Units
 QANZFEHEH4
INT4
 10 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
 QANZFEHL4
INT4
 10 0
ANZWERTO
Number of Measured Values Above the Tolerance Range
 QANZWERTO4
INT4
 10 0
ANZWERTU
Number of Measured Values Below the Tolerance Range
 QANZWERTU4
INT4
 10 0
ANZWERTG
Number of Inspected Sample Units
 QANZWERTG4
INT4
 10 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
GUELSTPANZ
Number of Valid Partial Samples
 QGUELSTPAN
INT2
 5 0
IVARIANZNI
Value Not Initial if Set
 QNINITIAL
CHAR
 1 0
IVARIANZ
Internal Dispersion of Valid Measured Values
 QIVARIANZ
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
KZVERDICHT
Reduced No. of Samples for Characteristic Summarization
 QVERDICHTG
CHAR
 1 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

QAMR foreign key relationships

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