QASE

Transparent Table Application Table
56 Fields 5 CDS Views

Results table for the sample unit

QASE is an SAP database table in S/4HANA. Results table for the sample unit. It contains 56 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_InspectionResultValue view from EXTENSION Single Value of an Inspection Charc Rslt Extension
FNDEI_QASE_BLOCKINGINFO view from Blocking View for table QASE
FNDEI_QASE_FILTER view from Filter View for table QASE
I_InspectionResultValue view from BASIC Single Value of an Inspection Charc Rslt
P_InspResultValueFrmtdValues view from BASIC

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandant MANDT Client
KEY prueflos QPLOS Inspection Lot
KEY vorglfnr QLFNKN Node Number
KEY merknr QMERKNRP Characteristic
KEY detailerg QDETAILERG Indiv. result
attribut QATTRIBUT Attribute
ersteller QERSTELLER Created By
erstelldat QDATUMERST Created On
aenderer QAENDERER Changed By
aenderdat QDATUMAEND Changed On
probenr QPROBENR Sample Number
stuecknr QSTUECKNR Insp. Unit No.
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
messwertni QMESSWRTNI MeasVal.notInit
messwert QMESSWERT Measured Value
katalgart1 QKATART Catalog
gruppe1 QCODEGRP Code Group
code1 QCODE Code
version1 QVERSNR Version
katalgart2 QKATART Catalog
gruppe2 QCODEGRP Code Group
code2 QCODE Code
version2 QVERSNR Version
katalgart3 QKATART Catalog
gruppe3 QCODEGRP Code Group
code3 QCODE Code
version3 QVERSNR Version
katalgart4 QKATART Catalog
gruppe4 QCODEGRP Code Group
code4 QCODE Code
version4 QVERSNR Version
katalgart5 QKATART Catalog
grupvers5 QVERSNR Version
gruppe5 QCODEGRP Code Group
code5 QCODE Code
version5 QVERSNR Version
anzfehler QANZFEHL1 No. of defects
fehlklas QFEHLKLAS Defect Class
mbewertg QMBEWERTG Valuation
estuecknr QESTUECKNR Single Unit
serialnr QSERIALNR Serial Number
maschine QMASCHINE Information
position QPRPOS Test Position
zeiterstl QZEITERSTL Time
zeitaend QZEITAEND Time
original_input QORIGINAL_INPUT Original Value
diff_dec_places QDIFF_DEC_PLACES Diff. Decimal Places
inpproc_ready QINPPROC_READY Input Processing
dummy_qase_incl_eew_ps DUMMY Dummy function in length 1

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.

-- Results table for the sample unit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QASE (
    MANDANT,                 -- Client [MANDT]
    PRUEFLOS,                -- Inspection Lot [QPLOS]
    VORGLFNR,                -- Node Number [QLFNKN]
    MERKNR,                  -- Characteristic [QMERKNRP]
    DETAILERG,               -- Indiv. result [QDETAILERG]
    ATTRIBUT,                -- Attribute [QATTRIBUT]
    ERSTELLER,               -- Created By [QERSTELLER]
    ERSTELLDAT,              -- Created On [QDATUMERST]
    AENDERER,                -- Changed By [QAENDERER]
    AENDERDAT,               -- Changed On [QDATUMAEND]
    PROBENR,                 -- Sample Number [QPROBENR]
    STUECKNR,                -- Insp. Unit No. [QSTUECKNR]
    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]
    MESSWERTNI,              -- MeasVal.notInit [QMESSWRTNI]
    MESSWERT,                -- Measured Value [QMESSWERT]
    KATALGART1,              -- Catalog [QKATART]
    GRUPPE1,                 -- Code Group [QCODEGRP]
    CODE1,                   -- Code [QCODE]
    VERSION1,                -- Version [QVERSNR]
    KATALGART2,              -- Catalog [QKATART]
    GRUPPE2,                 -- Code Group [QCODEGRP]
    CODE2,                   -- Code [QCODE]
    VERSION2,                -- Version [QVERSNR]
    KATALGART3,              -- Catalog [QKATART]
    GRUPPE3,                 -- Code Group [QCODEGRP]
    CODE3,                   -- Code [QCODE]
    VERSION3,                -- Version [QVERSNR]
    KATALGART4,              -- Catalog [QKATART]
    GRUPPE4,                 -- Code Group [QCODEGRP]
    CODE4,                   -- Code [QCODE]
    VERSION4,                -- Version [QVERSNR]
    KATALGART5,              -- Catalog [QKATART]
    GRUPVERS5,               -- Version [QVERSNR]
    GRUPPE5,                 -- Code Group [QCODEGRP]
    CODE5,                   -- Code [QCODE]
    VERSION5,                -- Version [QVERSNR]
    ANZFEHLER,               -- No. of defects [QANZFEHL1]
    FEHLKLAS,                -- Defect Class [QFEHLKLAS]
    MBEWERTG,                -- Valuation [QMBEWERTG]
    ESTUECKNR,               -- Single Unit [QESTUECKNR]
    SERIALNR,                -- Serial Number [QSERIALNR]
    MASCHINE,                -- Information [QMASCHINE]
    POSITION,                -- Test Position [QPRPOS]
    ZEITERSTL,               -- Time [QZEITERSTL]
    ZEITAEND,                -- Time [QZEITAEND]
    ORIGINAL_INPUT,          -- Original Value [QORIGINAL_INPUT]
    DIFF_DEC_PLACES,         -- Diff. Decimal Places [QDIFF_DEC_PLACES]
    INPPROC_READY,           -- Input Processing [QINPPROC_READY]
    DUMMY_QASE_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDANT, PRUEFLOS, VORGLFNR, MERKNR, DETAILERG)
);

Learn More