QPCD

Transparent Table Customizing Table
16 Fields 16 CDS Views

Inspection catalog codes

QPCD is an SAP database table in S/4HANA. Inspection catalog codes. It contains 16 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_CharcAttributeCode view from BASIC Characteristic Attribute Code
I_ConfigurableCodesCode view_entity from BASIC Code of Configurable Codes
I_DefectCauseCode view from BASIC Defect Cause Code
I_DefectCode view from BASIC Defect Code
I_DefectLocationCode view from BASIC Defect Location Code
I_InspectionCode view from BASIC Inspection Code
I_MaintNotifCauseCode view from BASIC Inspection Code
I_MfgActionReasonCode view from BASIC Reason Code
I_NotifActivityCode view from BASIC Notification Activity Code
I_NotifCauseCode view from BASIC Notification Cause Code
I_NotificationCode view from BASIC Notification Code
I_QltyTskCode view from BASIC Quality Task Code
I_RetMatlInspResultCode view from BASIC Return Material Inspection Result Code
I_ReturnsInspectionCode view_entity from BASIC Returns Inspection Code
I_UsageDecisionCode view from BASIC Usage Decision Code
I_UsgeDcsnSelectedSetCode view inner BASIC Usage Decision Code in Selected Set

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY katalogart QKATART Catalog
KEY codegruppe QCODEGRP Code Group
KEY code QCODE Code
KEY version QVERSNR Version
gueltigab DATUV Valid From
fehlklasse QFEHLKLAS Defect Class
ersteller QERSTELLER Created By
e_datum QDATUMERST Created On
aenderer QAENDERER Changed By
a_datum QDATUMAEND Changed On
inaktiv QINAK Record inactive
verwendung QVERW Record Used
geloescht QGEL Deleted record
folgeakti QFOLGEAKTI Follow-Up Actn
code4actionbox_rel QCODE4ACTIONBOX_REL Follow-Up Relevance

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
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPCD (
    MANDT,               -- Client [MANDT]
    KATALOGART,          -- Catalog [QKATART]
    CODEGRUPPE,          -- Code Group [QCODEGRP]
    CODE,                -- Code [QCODE]
    VERSION,             -- Version [QVERSNR]
    GUELTIGAB,           -- Valid From [DATUV]
    FEHLKLASSE,          -- Defect Class [QFEHLKLAS]
    ERSTELLER,           -- Created By [QERSTELLER]
    E_DATUM,             -- Created On [QDATUMERST]
    AENDERER,            -- Changed By [QAENDERER]
    A_DATUM,             -- Changed On [QDATUMAEND]
    INAKTIV,             -- Record inactive [QINAK]
    VERWENDUNG,          -- Record Used [QVERW]
    GELOESCHT,           -- Deleted record [QGEL]
    FOLGEAKTI,           -- Follow-Up Actn [QFOLGEAKTI]
    CODE4ACTIONBOX_REL,  -- Follow-Up Relevance [QCODE4ACTIONBOX_REL]
    PRIMARY KEY (MANDT, KATALOGART, CODEGRUPPE, CODE, VERSION)
);

Learn More