QDQL

Transparent Table Application Table
43 Fields 2 CDS Views

Quality level

QDQL is an SAP database table in S/4HANA. Quality level. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_QualityLevel view from EXTENSION Quality Level Extension
I_QualityLevel view from BASIC Quality Level

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
KEY matnr qmatnrql Material
KEY plnty qplntyql Task List Type
KEY plnnr qplnnrql Task List Group
KEY plnal qplnalql Group Counter
KEY plnfl qplnflql Sequence
KEY plnkn qplnknql Node
KEY zaehlerql qzaehlerql Counter
lifnr qelifnql Supplier
hersteller qherstql Manufacturer
kunnr qekunnql Customer
pruefart qpart Inspection Type
vornr qvornrd Operation
merknr qmerknrd Characteristic
vplty vplnty Ref TList type
vplnr vplnnr Ref. group
vplal vplnal Ref. group cntr
vplfl vplbfl Ref. sequence
vplnkn plnkn Node
aendlosa qaendlosa Changed by
aendlosm qaendlosm Changed by
aedatlosa qaedatlosa Changed on
aedatlosm qaedatlosm Changed on
aezeilosa qaezeilosa Changed at
aezeilosm qaezeilosm Changed at
prueflos qplosql Insp. Lot No.
bwlos qbwlos UD for Lot
bwlosdyn qbwlosdyn Dyn. Valuation
stichprver qstprver Smpl. Procedure
dynregel qdynregel Dyn. Mod. Rule
prstufenae qprstnae Next Stage
anzloseove qanzlosove Lots w/o UD
anzpraen qanzpraen Insp. s.change
anznioaen qanznioaen Not-OK Insp.
dbewertg qddbewertg Dyn. valuation
mbewertg qdmbewertg Valuation
plosove qplosql1 Inspection lot
datlpruef qdatlpruef Inspection Date
anzprstop qanzprstop Canceled Insp.
deldatum qdeldat Deletion Date
resdatum qresdat Reset Date
changeddatetime tzntstmps Time Stamp

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.

-- Quality level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QDQL (
    MANDT,            -- Client [mandt]
    WERKS,            -- Plant [werks_d]
    MATNR,            -- Material [qmatnrql]
    PLNTY,            -- Task List Type [qplntyql]
    PLNNR,            -- Task List Group [qplnnrql]
    PLNAL,            -- Group Counter [qplnalql]
    PLNFL,            -- Sequence [qplnflql]
    PLNKN,            -- Node [qplnknql]
    ZAEHLERQL,        -- Counter [qzaehlerql]
    LIFNR,            -- Supplier [qelifnql]
    HERSTELLER,       -- Manufacturer [qherstql]
    KUNNR,            -- Customer [qekunnql]
    PRUEFART,         -- Inspection Type [qpart]
    VORNR,            -- Operation [qvornrd]
    MERKNR,           -- Characteristic [qmerknrd]
    VPLTY,            -- Ref TList type [vplnty]
    VPLNR,            -- Ref. group [vplnnr]
    VPLAL,            -- Ref. group cntr [vplnal]
    VPLFL,            -- Ref. sequence [vplbfl]
    VPLNKN,           -- Node [plnkn]
    AENDLOSA,         -- Changed by [qaendlosa]
    AENDLOSM,         -- Changed by [qaendlosm]
    AEDATLOSA,        -- Changed on [qaedatlosa]
    AEDATLOSM,        -- Changed on [qaedatlosm]
    AEZEILOSA,        -- Changed at [qaezeilosa]
    AEZEILOSM,        -- Changed at [qaezeilosm]
    PRUEFLOS,         -- Insp. Lot No. [qplosql]
    BWLOS,            -- UD for Lot [qbwlos]
    BWLOSDYN,         -- Dyn. Valuation [qbwlosdyn]
    STICHPRVER,       -- Smpl. Procedure [qstprver]
    DYNREGEL,         -- Dyn. Mod. Rule [qdynregel]
    PRSTUFENAE,       -- Next Stage [qprstnae]
    ANZLOSEOVE,       -- Lots w/o UD [qanzlosove]
    ANZPRAEN,         -- Insp. s.change [qanzpraen]
    ANZNIOAEN,        -- Not-OK Insp. [qanznioaen]
    DBEWERTG,         -- Dyn. valuation [qddbewertg]
    MBEWERTG,         -- Valuation [qdmbewertg]
    PLOSOVE,          -- Inspection lot [qplosql1]
    DATLPRUEF,        -- Inspection Date [qdatlpruef]
    ANZPRSTOP,        -- Canceled Insp. [qanzprstop]
    DELDATUM,         -- Deletion Date [qdeldat]
    RESDATUM,         -- Reset Date [qresdat]
    CHANGEDDATETIME,  -- Time Stamp [tzntstmps]
    PRIMARY KEY (MANDT, WERKS, MATNR, PLNTY, PLNNR, PLNAL, PLNFL, PLNKN, ZAEHLERQL)
);

Learn More