SAP table QAMR (Characteristic results during inspection processing)

SAP table QAMR has 4 primary key fields being MANDANT,PRUEFLOS,VORGLFNR,MERKNR.

Field Description Data Type Length Decimals Checktable Data Element
MANDANT Client CLNT 3 0 T000 MANDT
PRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
VORGLFNR Current Node Number from Order Counter NUMC 8 0 QLFNKN
MERKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
SATZSTATUS Results Record Status CHAR 1 0 TQ76 QBEASTATUS
ATTRIBUT Attribute of the Results Record (Valid, Invalid,...) CHAR 1 0 QATTRIBUT
Result is valid (default)
# Result not determinable; valid result
& Error occurred during results transfer
( Customer attribute '('; valid result
) Customer attribute ')'; invalid result
* Result considered an outlier; valid result
/ Invalid result
< True value is less than or less equal to; valid result
> True value is greater than or greater equal to; valid result
? Result was estimated; valid 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
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
[ Customer attribute '['; valid result
\ Result is not current; invalid result
] Customer attribute ']'; invalid result
{ Customer attribute '{'; valid result
} Customer attribute '}'; invalid result
~ Result not proven; valid result
True value is less than or equal to; valid result
True value is greater than or equal to; valid result
QERGDATH Origin of Results Data CHAR 2 0 TQ73 QERGDATH
ERSTELLER Name of User Who Created the Data Record CHAR 12 0 QERSTELLER
ERSTELLDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
AENDERER Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
DBEWERTG Valuation of the Characteristic for Dynamic Modification CHAR 1 0 QDBEWERTG
MBEWERTG Inspection Result Valuation CHAR 1 0 QMBEWERTG
PRUEFER Name of Inspector CHAR 12 0 QPRUEFER
PRUEFDATUV Start Date in Local Time Zone of Inspection DATS 8 0 QPRUEFDATV
PRUEFDATUB End Date in Local Time Zone of Inspection DATS 8 0 QPRUEFDATB
PRUEFZEITV Start Time in Local Time Zone of Inspection TIMS 6 0 QPRUEFZTV
PRUEFZEITB End Time in Local Time Zone of Inspection TIMS 6 0 QPRUEFZTB
PRUEFBEMKT Short Text CHAR 40 0 QKURZTEXT
PRLTEXTKZ Inspection Characteristic Long Text Exists CHAR 1 0 QLTEXTKZ
LTEXTSPR Language Key LANG 1 0 T002 SPRAS
ISTSTPANZ Number of Partial Samples for Characteristic INT2 5 0 QANZSTIPRO
ISTSTPUMF Number of Recorded Sample Units INT4 10 0 QISTSTPUMF
ANZFEHLEH Number of Nonconforming Sample Units INT4 10 0 QANZFEHEH4
ANTEILNI Not Initialized for Fraction CHAR 1 0 QNIANTEIL
ANTEIL Estimated Fraction of Nonconforming Sample Units FLTP 16 16 QANTEIL
ANZFEHLER Number of Defects Found INT4 10 0 QANZFEHL4
ANZWERTO Number of Measured Values Above Tolerance Range INT4 10 0 QANZWERTO4
ANZWERTU Number of Measured Values Below Tolerance Range INT4 10 0 QANZWERTU4
ANZWERTG Number of Inspected Sample Units INT4 10 0 QANZWERTG4
MAXWERTNI Value Not Initial if Set CHAR 1 0 QNINITIAL
MEDIANNI Value Not Initial if Set CHAR 1 0 QNINITIAL
MINWERTNI Value Not Initial if Set CHAR 1 0 QNINITIAL
MITTELWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
VARIANZNI Value Not Initial if Set CHAR 1 0 QNINITIAL
MOMENT3NI Value Not Initial if Set CHAR 1 0 QNINITIAL
MOMENT4NI Value Not Initial if Set CHAR 1 0 QNINITIAL
ANTEILONI Value Not Initial if Set CHAR 1 0 QNINITIAL
ANTEILUNI Value Not Initial if Set CHAR 1 0 QNINITIAL
MAXWERT Maximum Value of Valid Measured Values FLTP 16 16 QMAXWERT
MEDIANWERT Median of Valid Measured Values FLTP 16 16 QMEDIANWRT
MINWERT Minimum Value of Valid Measured Values FLTP 16 16 QMINWERT
MITTELWERT Arithmetic Mean of Valid Measured Values FLTP 16 16 QMITTELWRT
VARIANZ Dispersion (Variance) of Valid Measured Values FLTP 16 16 QVARIANZ
MOMENT3 Third Central Moment of Valid Measured Values FLTP 16 16 QMOMENT3
MOMENT4 Fourth Central Moment of Valid Measured Values FLTP 16 16 QMOMENT4
ANTEILO Estimated Fraction Above Tolerance Range FLTP 16 16 QANTEILO
ANTEILU Estimated Fraction Below Tolerance Range FLTP 16 16 QANTEILU
GUELSTPANZ Number of Valid Partial Samples INT2 5 0 QGUELSTPAN
IVARIANZNI Value Not Initial if Set CHAR 1 0 QNINITIAL
IVARIANZ Internal Dispersion of Valid Measured Values FLTP 16 16 QIVARIANZ
KATALGART1 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
GRUPPE1 Code Group CHAR 8 0 QCODEGRP
CODE1 Code CHAR 4 0 QCODE
VERSION1 Version Number CHAR 6 0 QVERSNR
KATALGART2 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
GRUPPE2 Code Group CHAR 8 0 QCODEGRP
CODE2 Code CHAR 4 0 QCODE
VERSION2 Version Number CHAR 6 0 QVERSNR
KATALGART3 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
GRUPPE3 Code Group CHAR 8 0 QCODEGRP
CODE3 Code CHAR 4 0 QCODE
VERSION3 Version Number CHAR 6 0 QVERSNR
KATALGART4 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
GRUPPE4 Code Group CHAR 8 0 QCODEGRP
CODE4 Code CHAR 4 0 QCODE
VERSION4 Version Number CHAR 6 0 QVERSNR
KATALGART5 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
GRUPPE5 Code Group CHAR 8 0 QCODEGRP
CODE5 Code CHAR 4 0 QCODE
VERSION5 Version Number CHAR 6 0 QVERSNR
FEHLKLAS Defect Class CHAR 2 0 TQ17 QFEHLKLAS
SENDEFLAG Characteristic Result Confirmation from Control Station CHAR 1 0 QSENDEFLAG
Characteristic result was not confirmed
1 First confirmation of characteristic result
2 Correction confirmation of characteristic result
MASCHINE General Information CHAR 18 0 QMASCHINE
POSITION Test Position NUMC 4 0 QPRPOS
AENDBELEG Create Change Documents During Results Recording CHAR 1 0 QKZAENBEL
KZBEWERTG Valuation Copied or Forced CHAR 1 0 QKZBEWERTG
Valuation and/or close using plan specifications
* Manual valuation was forced
+ Manual valuation and forced closure
- Valuation imported internally, e.g. from a differnt char.
. Valuation imported externally and forced closure
/ Valuation using specifications, forced closure
X Valuation imported from another system (e.g. subsystem)
ZEITERSTL System Time at Which Data Record Was Created TIMS 6 0 QZEITERSTL
ZEITAEND System Time at Which Data Record Was Changed TIMS 6 0 QZEITAEND
KZVERDICHT Reduced No. of Samples for Characteristic Summarization CHAR 1 0 QVERDICHTG
ORIGINAL_INPUT Original Value Before Input Processing CHAR 25 0 QORIGINAL_INPUT
DIFF_DEC_PLACES Different Number of Decimal Places INT2 5 0 QDIFF_DEC_PLACES
INPPROC_READY Input Processing Successfully Completed CHAR 1 0 QINPPROC_READY
SIGN_ID Digital Signature for Process CHAR 22 0 SIGN_GUID_22_CHG
SIGN_STATE Status of Signature Process CHAR 1 0 SIGN_STATE
New Signature Process
1 Completed Signature Process
2 Canceled Signature Process
3 Current Signature Process
DUMMY_QAMR_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QAMR foreign key relationships

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