CRMD_CASE_INDEX

Transparent Table Application Table
19 Fields 2 CDS Views

Index Table for CRM Cases

CRMD_CASE_INDEX is an SAP database table in S/4HANA. Index Table for CRM Cases. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
crms4_case_index view from CRM Case Index
I_InvgCsMCaseStaffAndUnit view from BASIC Basic View for ICM Case Staff and Unit

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid CRMT_OBJECT_GUID Object GUID
case_guid SCMG_CASE_GUID Case Key
partner_no CRMT_PARTNER_NO Partner Number
partner_fct COMT_PARTNER_FCT Partner Function
crm_main_partner CRMT_PARTNER_MAIN Main Partner
stat_open CRMT_BOOLEAN Flag
stat_process CRMT_BOOLEAN Flag
stat_ex_process CRMT_BOOLEAN Flag
stat_f_release CRMT_BOOLEAN Flag
stat_release CRMT_BOOLEAN Flag
stat_reject CRMT_BOOLEAN Flag
stat_closed CRMT_BOOLEAN Flag
stat_confirmed CRMT_BOOLEAN Flag
stat_deleted CRMT_BOOLEAN Flag
object_type CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
object_guid CRMT_OBJECT_GUID Object GUID
object_id CRMT_OBJECT_ID_DB Transaction ID
product_id MATNR Material

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.

-- Index Table for CRM Cases
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMD_CASE_INDEX (
    CLIENT,            -- Client [MANDT]
    GUID,              -- Object GUID [CRMT_OBJECT_GUID]
    CASE_GUID,         -- Case Key [SCMG_CASE_GUID]
    PARTNER_NO,        -- Partner Number [CRMT_PARTNER_NO]
    PARTNER_FCT,       -- Partner Function [COMT_PARTNER_FCT]
    CRM_MAIN_PARTNER,  -- Main Partner [CRMT_PARTNER_MAIN]
    STAT_OPEN,         -- Flag [CRMT_BOOLEAN]
    STAT_PROCESS,      -- Flag [CRMT_BOOLEAN]
    STAT_EX_PROCESS,   -- Flag [CRMT_BOOLEAN]
    STAT_F_RELEASE,    -- Flag [CRMT_BOOLEAN]
    STAT_RELEASE,      -- Flag [CRMT_BOOLEAN]
    STAT_REJECT,       -- Flag [CRMT_BOOLEAN]
    STAT_CLOSED,       -- Flag [CRMT_BOOLEAN]
    STAT_CONFIRMED,    -- Flag [CRMT_BOOLEAN]
    STAT_DELETED,      -- Flag [CRMT_BOOLEAN]
    OBJECT_TYPE,       -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_GUID,       -- Object GUID [CRMT_OBJECT_GUID]
    OBJECT_ID,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    PRODUCT_ID,        -- Material [MATNR]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More