QPGR

Transparent Table Customizing Table
10 Fields 15 CDS Views

Inspection catalog code groups

QPGR is an SAP database table in S/4HANA. Inspection catalog code groups. It contains 10 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_CharcAttributeCodeGrp view from BASIC Characteristic Attribute Code Group
I_ConfigurableCodesCodeGroup view_entity from BASIC Code Group of Configurable Codes
I_DefectCauseCodeGroup view_entity from BASIC Defect Cause Code Group
I_DefectCodeGroup view from BASIC Defect Code Group
I_DefectLocationCodeGroup view_entity from BASIC Defect Location Code Group
I_InspectionCodeGroup view_entity from BASIC Inspection Code Group
I_InspSpecAddlCodeGroup view_entity from BASIC Additional Code Group of Master Charc
I_MaintNotifCauseCodeGroup view_entity from BASIC Catalog Code Group
I_MfgActionReasonCodeGroup view from BASIC Reason Code Group
I_NotifActivityCodeGroup view_entity from BASIC Notification Activity Code Group
I_NotifCauseCodeGroup view_entity from BASIC Notification Cause Code Group
I_NotificationCodeGroup view_entity from BASIC Notification Code Group
I_QltyTskCodeGroup view_entity from BASIC Quality Task Code Group
I_UsageDecisionCodeGroup view from BASIC Usage Decision Code Group
I_UsgeDcsnSelectedSetCodeGrp view_entity inner BASIC Code Group of Selected Set for UD

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY katalogart qkatart Catalog
KEY codegruppe qcodegrp Code Group
ersteller qersteller Created By
e_datum qdatumerst Created On
aenderer qaenderer Changed By
a_datum qdatumaend Changed On
verwendung qusage
inaktiv qinak Record inactive
status qloeschkz1 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.

-- Inspection catalog code groups
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPGR (
    MANDT,       -- Client [mandt]
    KATALOGART,  -- Catalog [qkatart]
    CODEGRUPPE,  -- Code Group [qcodegrp]
    ERSTELLER,   -- Created By [qersteller]
    E_DATUM,     -- Created On [qdatumerst]
    AENDERER,    -- Changed By [qaenderer]
    A_DATUM,     -- Changed On [qdatumaend]
    VERWENDUNG,  -- qusage
    INAKTIV,     -- Record inactive [qinak]
    STATUS,      -- Status [qloeschkz1]
    PRIMARY KEY (MANDT, KATALOGART, CODEGRUPPE)
);

Learn More