CRMD_CMG_CASE_AT

Transparent Table Application Table
11 Fields 3 CDS Views

CRM-Specific Case Attributes

CRMD_CMG_CASE_AT is an SAP database table in S/4HANA. CRM-Specific Case Attributes. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
crms4_cmg_case_at view from CRM Case Attributes
E_ServiceManagementCase view from EXTENSION Service Management Case Extension
I_InvgCsMCase view inner BASIC Basic View For ICM Case

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY case_guid SCMG_CASE_GUID Case Key
crm_case_title CRMT_CMG_CASE_TITLE_UPPER Heading
crm_sch_ref_time CRMT_CMG_SCH_REF_TSTMP Schema Ref.Timestamp
crm_bus_ref_time CRMT_CMG_REF_TSTMP Bus. Ref. Timestamp
crm_schema_id CRMT_CMG_SCH_ID Schema ID
crm_category_id CRMT_CMG_CAT_ID Ref. Category ID
prod_cat_id CRMT_PROD_HIERARCHY Product Cat.
category_text COMT_CATEGORY_TEXT Category Description
cmg_eew_dummy CFD_DUMMY Dummy
cmg_eew DUMMY Dummy function in length 1

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.

-- CRM-Specific Case Attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_CMG_CASE_AT (
    MANDT,             -- Client [MANDT]
    CASE_GUID,         -- Case Key [SCMG_CASE_GUID]
    CRM_CASE_TITLE,    -- Heading [CRMT_CMG_CASE_TITLE_UPPER]
    CRM_SCH_REF_TIME,  -- Schema Ref.Timestamp [CRMT_CMG_SCH_REF_TSTMP]
    CRM_BUS_REF_TIME,  -- Bus. Ref. Timestamp [CRMT_CMG_REF_TSTMP]
    CRM_SCHEMA_ID,     -- Schema ID [CRMT_CMG_SCH_ID]
    CRM_CATEGORY_ID,   -- Ref. Category ID [CRMT_CMG_CAT_ID]
    PROD_CAT_ID,       -- Product Cat. [CRMT_PROD_HIERARCHY]
    CATEGORY_TEXT,     -- Category Description [COMT_CATEGORY_TEXT]
    CMG_EEW_DUMMY,     -- Dummy [CFD_DUMMY]
    CMG_EEW,           -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, CASE_GUID)
);

Learn More