QAMR

Transparent Table Application Table
86 Fields 5 CDS Views

Characteristic results during inspection processing

QAMR is an SAP database table in S/4HANA. Characteristic results during inspection processing. It contains 86 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_InspectionResult view from EXTENSION Inspection Result Extension
FNDEI_QAMR_BLOCKINGINFO view from Blocking View for table QAMR
FNDEI_QAMR_FILTER view from Filter View for table QAMR
I_InspectionResult view from BASIC Summarized Insp Result for an Insp Charc
P_InspResultFrmtdValues view from BASIC

Fields (86)

KeyField Data ElementDescription DomainTypeLength
KEY mandant mandt Client
KEY prueflos qplos Inspection Lot
KEY vorglfnr qlfnkn Node Number
KEY merknr qmerknrp Characteristic
satzstatus qbeastatus Status
attribut qattribut Attribute
qergdath qergdath Data Origin
ersteller qersteller Created By
erstelldat qdatumerst Created On
aenderer qaenderer Changed By
aenderdat qdatumaend Changed On
changeddatetime tzntstmps Time Stamp
dbewertg qdbewertg Dyn. Valuation
mbewertg qmbewertg Valuation
pruefer qpruefer Inspector
pruefdatuv qpruefdatv Insp.Start Date
pruefdatub qpruefdatb Insp. End Date
pruefzeitv qpruefztv Insp.Start Time
pruefzeitb qpruefztb Insp. End Time
pruefbemkt qkurztext Short Text
prltextkz qltextkz Long text
ltextspr spras Language
iststpanz qanzstipro Partial Samples
iststpumf qiststpumf Recorded
anzfehleh qanzfeheh4 Nonconforming
anteilni qnianteil Not initialized
anteil qanteil Nonconf.frac
anzfehler qanzfehl4 No. of Defects
anzwerto qanzwerto4 Number Above
anzwertu qanzwertu4 Number Below
anzwertg qanzwertg4 Inspected
maxwertni qninitial Not Initial
medianni qninitial Not Initial
minwertni qninitial Not Initial
mittelwni qninitial Not Initial
varianzni qninitial Not Initial
moment3ni qninitial Not Initial
moment4ni qninitial Not Initial
anteiloni qninitial Not Initial
anteiluni qninitial Not Initial
maxwert qmaxwert Max Valid Value
medianwert qmedianwrt Median
minwert qminwert Min Valid Value
mittelwert qmittelwrt Mean Value
varianz qvarianz Variance
moment3 qmoment3 3rd centrMoment
moment4 qmoment4 4th centrMoment
anteilo qanteilo Fraction Above
anteilu qanteilu Fraction Below
guelstpanz qguelstpan Valid Samples
ivarianzni qninitial Not Initial
ivarianz qivarianz Intern. disp.
katalgart1 qkatausw Catalog Type
gruppe1 qcodegrp Code Group
code1 qcode Code
version1 qversnr Version
katalgart2 qkatausw Catalog Type
gruppe2 qcodegrp Code Group
code2 qcode Code
version2 qversnr Version
katalgart3 qkatausw Catalog Type
gruppe3 qcodegrp Code Group
code3 qcode Code
version3 qversnr Version
katalgart4 qkatausw Catalog Type
gruppe4 qcodegrp Code Group
code4 qcode Code
version4 qversnr Version
katalgart5 qkatausw Catalog Type
gruppe5 qcodegrp Code Group
code5 qcode Code
version5 qversnr Version
fehlklas qfehlklas Defect Class
sendeflag qsendeflag Send flag
maschine qmaschine Information
position qprpos Test Position
aendbeleg qkzaenbel RR change docs
kzbewertg qkzbewertg Valuation Copied or Forced
zeiterstl qzeiterstl Time
zeitaend qzeitaend Time
kzverdicht qverdichtg Reduced SampNo
original_input qoriginal_input Original Value
diff_dec_places qdiff_dec_places Diff. Decimal Places
inpproc_ready qinpproc_ready Input Processing
sign_id sign_guid_22_chg Signature ID
sign_state sign_state Process Status

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Characteristic results during inspection processing
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QAMR (
    MANDANT,          -- Client [mandt]
    PRUEFLOS,         -- Inspection Lot [qplos]
    VORGLFNR,         -- Node Number [qlfnkn]
    MERKNR,           -- Characteristic [qmerknrp]
    SATZSTATUS,       -- Status [qbeastatus]
    ATTRIBUT,         -- Attribute [qattribut]
    QERGDATH,         -- Data Origin [qergdath]
    ERSTELLER,        -- Created By [qersteller]
    ERSTELLDAT,       -- Created On [qdatumerst]
    AENDERER,         -- Changed By [qaenderer]
    AENDERDAT,        -- Changed On [qdatumaend]
    CHANGEDDATETIME,  -- Time Stamp [tzntstmps]
    DBEWERTG,         -- Dyn. Valuation [qdbewertg]
    MBEWERTG,         -- Valuation [qmbewertg]
    PRUEFER,          -- Inspector [qpruefer]
    PRUEFDATUV,       -- Insp.Start Date [qpruefdatv]
    PRUEFDATUB,       -- Insp. End Date [qpruefdatb]
    PRUEFZEITV,       -- Insp.Start Time [qpruefztv]
    PRUEFZEITB,       -- Insp. End Time [qpruefztb]
    PRUEFBEMKT,       -- Short Text [qkurztext]
    PRLTEXTKZ,        -- Long text [qltextkz]
    LTEXTSPR,         -- Language [spras]
    ISTSTPANZ,        -- Partial Samples [qanzstipro]
    ISTSTPUMF,        -- Recorded [qiststpumf]
    ANZFEHLEH,        -- Nonconforming [qanzfeheh4]
    ANTEILNI,         -- Not initialized [qnianteil]
    ANTEIL,           -- Nonconf.frac [qanteil]
    ANZFEHLER,        -- No. of Defects [qanzfehl4]
    ANZWERTO,         -- Number Above [qanzwerto4]
    ANZWERTU,         -- Number Below [qanzwertu4]
    ANZWERTG,         -- Inspected [qanzwertg4]
    MAXWERTNI,        -- Not Initial [qninitial]
    MEDIANNI,         -- Not Initial [qninitial]
    MINWERTNI,        -- Not Initial [qninitial]
    MITTELWNI,        -- Not Initial [qninitial]
    VARIANZNI,        -- Not Initial [qninitial]
    MOMENT3NI,        -- Not Initial [qninitial]
    MOMENT4NI,        -- Not Initial [qninitial]
    ANTEILONI,        -- Not Initial [qninitial]
    ANTEILUNI,        -- Not Initial [qninitial]
    MAXWERT,          -- Max Valid Value [qmaxwert]
    MEDIANWERT,       -- Median [qmedianwrt]
    MINWERT,          -- Min Valid Value [qminwert]
    MITTELWERT,       -- Mean Value [qmittelwrt]
    VARIANZ,          -- Variance [qvarianz]
    MOMENT3,          -- 3rd centrMoment [qmoment3]
    MOMENT4,          -- 4th centrMoment [qmoment4]
    ANTEILO,          -- Fraction Above [qanteilo]
    ANTEILU,          -- Fraction Below [qanteilu]
    GUELSTPANZ,       -- Valid Samples [qguelstpan]
    IVARIANZNI,       -- Not Initial [qninitial]
    IVARIANZ,         -- Intern. disp. [qivarianz]
    KATALGART1,       -- Catalog Type [qkatausw]
    GRUPPE1,          -- Code Group [qcodegrp]
    CODE1,            -- Code [qcode]
    VERSION1,         -- Version [qversnr]
    KATALGART2,       -- Catalog Type [qkatausw]
    GRUPPE2,          -- Code Group [qcodegrp]
    CODE2,            -- Code [qcode]
    VERSION2,         -- Version [qversnr]
    KATALGART3,       -- Catalog Type [qkatausw]
    GRUPPE3,          -- Code Group [qcodegrp]
    CODE3,            -- Code [qcode]
    VERSION3,         -- Version [qversnr]
    KATALGART4,       -- Catalog Type [qkatausw]
    GRUPPE4,          -- Code Group [qcodegrp]
    CODE4,            -- Code [qcode]
    VERSION4,         -- Version [qversnr]
    KATALGART5,       -- Catalog Type [qkatausw]
    GRUPPE5,          -- Code Group [qcodegrp]
    CODE5,            -- Code [qcode]
    VERSION5,         -- Version [qversnr]
    FEHLKLAS,         -- Defect Class [qfehlklas]
    SENDEFLAG,        -- Send flag [qsendeflag]
    MASCHINE,         -- Information [qmaschine]
    POSITION,         -- Test Position [qprpos]
    AENDBELEG,        -- RR change docs [qkzaenbel]
    KZBEWERTG,        -- Valuation Copied or Forced [qkzbewertg]
    ZEITERSTL,        -- Time [qzeiterstl]
    ZEITAEND,         -- Time [qzeitaend]
    KZVERDICHT,       -- Reduced SampNo [qverdichtg]
    ORIGINAL_INPUT,   -- Original Value [qoriginal_input]
    DIFF_DEC_PLACES,  -- Diff. Decimal Places [qdiff_dec_places]
    INPPROC_READY,    -- Input Processing [qinpproc_ready]
    SIGN_ID,          -- Signature ID [sign_guid_22_chg]
    SIGN_STATE,       -- Process Status [sign_state]
    PRIMARY KEY (MANDANT, PRUEFLOS, VORGLFNR, MERKNR)
);

Learn More