QASR

Transparent Table Application Table
82 Fields 5 CDS Views

Sample results for inspection characteristics

QASR is an SAP database table in S/4HANA. Sample results for inspection characteristics. It contains 82 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_Inspsubsetresult view from EXTENSION Insp. Rslt. for an Insp. Point Extension
I_InspSubsetResult view from BASIC Insp Result for an Inspection Point
P_InspSampleResultFrmtdValues view from BASIC
UPOV_ME_MEDOC_IT_UOM view inner Measurement document item (UOM)
UPOV_WELLTEST_MEASUREDVAL view inner Sample Readings of a Well / WC Test

Fields (82)

KeyField Data ElementDescription DomainTypeLength
KEY mandant mandt Client
KEY prueflos qplos Inspection Lot
KEY vorglfnr qlfnkn Node Number
KEY merknr qmerknrp Characteristic
KEY probenr qstipronr Partial Sample
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
mbewertg qmbewertg Valuation
dbewertg qdbewertg Dyn. 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
iststpumf qiststpumf Recorded
anzfehleh qanzfeheh2 Nonconforming
anteilni qnianteil Not initialized
anteil qanteil Nonconf.frac
anzfehler qanzfehl2 No. of defects
anzwerto qanzwerto2 Number Above
anzwertu qanzwertu2 Number Below
anzwertg qanzwertg2 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
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
changeddatetime tzntstmps Time Stamp
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.

-- Sample results for inspection characteristics
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QASR (
    MANDANT,          -- Client [mandt]
    PRUEFLOS,         -- Inspection Lot [qplos]
    VORGLFNR,         -- Node Number [qlfnkn]
    MERKNR,           -- Characteristic [qmerknrp]
    PROBENR,          -- Partial Sample [qstipronr]
    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]
    MBEWERTG,         -- Valuation [qmbewertg]
    DBEWERTG,         -- Dyn. Valuation [qdbewertg]
    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]
    ISTSTPUMF,        -- Recorded [qiststpumf]
    ANZFEHLEH,        -- Nonconforming [qanzfeheh2]
    ANTEILNI,         -- Not initialized [qnianteil]
    ANTEIL,           -- Nonconf.frac [qanteil]
    ANZFEHLER,        -- No. of defects [qanzfehl2]
    ANZWERTO,         -- Number Above [qanzwerto2]
    ANZWERTU,         -- Number Below [qanzwertu2]
    ANZWERTG,         -- Inspected [qanzwertg2]
    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]
    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]
    CHANGEDDATETIME,  -- Time Stamp [tzntstmps]
    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, PROBENR)
);

Learn More