QPAC

Transparent Table Customizing Table
29 Fields 2 CDS Views

Inspection catalog codes for selected sets

QPAC is an SAP database table in S/4HANA. Inspection catalog codes for selected sets. It contains 29 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CharcAttribSelectedSetCode view from BASIC Selected Set Code for Charc Attribute
I_UsgeDcsnSelectedSetCode view from BASIC Usage Decision Code in Selected Set

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY werks werks_d Plant
KEY katalogart qkatart Catalog
KEY auswahlmge qauswahlmg Selected Set
KEY codegruppe qcodegrp Code Group
KEY code qcode Code
KEY versionam qversnram Version
gueltigab datuv Valid From
versioncd qversnrcd Version
massnahme qmassktext Measures
ltextmassv qltextms Long text
auswirkung qauswktext Effect
ltextauswv qltextaw Long text
bewertung qbewertung Code Valuation
fehlklasse qfehlklas Defect Class
waehrung q_unusedcuky Dummy
fkosten q_unusedcurr102 Dummy
musstextkz qmusstkz Text required
aenderkz q1lzeitmk Long-Term Char.
ersteller qersteller Created By
e_datum qdatumerst Created On
aenderer qaenderer Changed By
a_datum qdatumaend Changed On
geloescht q_unused01 Dummy
qkennzahl qkennz Quality Score
folgeakti qfolgeakti Follow-Up Actn
bb_vorsch q_bb_vor Qty proposal
bb_dunkel q_bb_dark Backgr
feldname qmgbuch Posting in UD

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.

-- Inspection catalog codes for selected sets
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPAC (
    MANDT,       -- Client [mandt]
    WERKS,       -- Plant [werks_d]
    KATALOGART,  -- Catalog [qkatart]
    AUSWAHLMGE,  -- Selected Set [qauswahlmg]
    CODEGRUPPE,  -- Code Group [qcodegrp]
    CODE,        -- Code [qcode]
    VERSIONAM,   -- Version [qversnram]
    GUELTIGAB,   -- Valid From [datuv]
    VERSIONCD,   -- Version [qversnrcd]
    MASSNAHME,   -- Measures [qmassktext]
    LTEXTMASSV,  -- Long text [qltextms]
    AUSWIRKUNG,  -- Effect [qauswktext]
    LTEXTAUSWV,  -- Long text [qltextaw]
    BEWERTUNG,   -- Code Valuation [qbewertung]
    FEHLKLASSE,  -- Defect Class [qfehlklas]
    WAEHRUNG,    -- Dummy [q_unusedcuky]
    FKOSTEN,     -- Dummy [q_unusedcurr102]
    MUSSTEXTKZ,  -- Text required [qmusstkz]
    AENDERKZ,    -- Long-Term Char. [q1lzeitmk]
    ERSTELLER,   -- Created By [qersteller]
    E_DATUM,     -- Created On [qdatumerst]
    AENDERER,    -- Changed By [qaenderer]
    A_DATUM,     -- Changed On [qdatumaend]
    GELOESCHT,   -- Dummy [q_unused01]
    QKENNZAHL,   -- Quality Score [qkennz]
    FOLGEAKTI,   -- Follow-Up Actn [qfolgeakti]
    BB_VORSCH,   -- Qty proposal [q_bb_vor]
    BB_DUNKEL,   -- Backgr [q_bb_dark]
    FELDNAME,    -- Posting in UD [qmgbuch]
    PRIMARY KEY (MANDT, WERKS, KATALOGART, AUSWAHLMGE, CODEGRUPPE, CODE, VERSIONAM)
);

Learn More