QPGT

Transparent Table Customizing Table
7 Fields 13 CDS Views

Code group texts

QPGT is an SAP database table in S/4HANA. Code group texts. It contains 7 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_CharcAttributeCodeGrpText view from BASIC Characteristic Attribute Code Group - Text
I_ConfigblCodesCodeGroupText view_entity from BASIC Code Group of Configurable Codes - Text
I_DefectCauseCodeGroupText view from BASIC Defect Cause Code Group Text
I_DefectCodeGroupText view from BASIC Defect Code Group - Text
I_DefectLocationCodeGroupText view from BASIC Defect Location Code Group Text
I_Inspectioncodegrouptext view from BASIC Inspection Code Group - Text
I_InspSpecAddlCodeGroupText view from BASIC Addl Code Group of Master Charc - Text
I_MfgActionReasonCodeGroupText view from BASIC MPE Reason Code Group Text
I_NotifActivityCodeGroupText view from BASIC Notification Activity Code Group Text
I_NotifCauseCodeGroupText view from BASIC Notification Cause Code Group - Text
I_NotificationCodeGroupText view from BASIC Notification Code Group Text
I_QltyTskCodeGroupText view from BASIC Quality Task Code Group Text
I_UsageDecisionCodeGroupText view from BASIC Usage Decision Code Group - Text

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandant MANDT Client
KEY katalogart QKATART Catalog
KEY codegruppe QCODEGRP Code Group
KEY sprache SPRAS Language
kurztext QKTEXTGR Short Text
ltextv QLTEXTGRP Long Text
inaktiv QINAK Record inactive

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.

-- Code group texts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPGT (
    MANDANT,     -- Client [MANDT]
    KATALOGART,  -- Catalog [QKATART]
    CODEGRUPPE,  -- Code Group [QCODEGRP]
    SPRACHE,     -- Language [SPRAS]
    KURZTEXT,    -- Short Text [QKTEXTGR]
    LTEXTV,      -- Long Text [QLTEXTGRP]
    INAKTIV,     -- Record inactive [QINAK]
    PRIMARY KEY (MANDANT, KATALOGART, CODEGRUPPE, SPRACHE)
);

Learn More