CRMC_QPCT

Transparent Table Customizing Table

Code Texts

CRMC_QPCT is an SAP database table in S/4HANA. Code Texts. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SrvcMgmtCodeText view_entity from BASIC Code in Service Management - Text
I_UtilitiesServiceReason view_entity inner BASIC IS U BR Avg Serv Time Service Reason

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY katalogart comt_catalog Catalog
KEY codegruppe crm_qcodegrp Code Group
KEY code crm_qcode Code
KEY sprache spras Language
kurztext crm_qtxt_code Short Text Code
ltextv crm_qltextcode Long Text
inaktiv crm_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 Texts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMC_QPCT (
    MANDT,       -- Client [mandt]
    KATALOGART,  -- Catalog [comt_catalog]
    CODEGRUPPE,  -- Code Group [crm_qcodegrp]
    CODE,        -- Code [crm_qcode]
    SPRACHE,     -- Language [spras]
    KURZTEXT,    -- Short Text Code [crm_qtxt_code]
    LTEXTV,      -- Long Text [crm_qltextcode]
    INAKTIV,     -- Record inactive [crm_qinak]
    PRIMARY KEY (MANDT, KATALOGART, CODEGRUPPE, CODE, SPRACHE)
);