1. Home
  2. Resources
  3. SAP Tables
  4. QAMR - Characteristic results during inspection processing

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
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
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
DBEWERTG Valuation of the Characteristic for Dynamic Modification QDBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
MBEWERTG Inspection Result Valuation QMBEWERTG 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
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
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 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
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
GUELSTPANZ Number of Valid Partial Samples QGUELSTPAN INT2 5 0
IVARIANZNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
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
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
KZVERDICHT Reduced No. of Samples for Characteristic Summarization QVERDICHTG CHAR 1 0
NULL Indicator is not set
X Indicator is set
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

QAMR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAMR FEHLKLAS QAMR FEHLKLAS TQ17 Defect classes FEHLKLASSE
QAMR FEHLKLAS QAMR MANDANT TQ17 Defect classes MANDT
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 MANDANT TQ15 Inspection catalog type index MANDT
QAMR KATALGART4 QAMR KATALGART4 TQ15 Inspection catalog type index KATALOGART
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