CRMC_ERMS_CAT_CA

Transparent Table Customizing (protected)
10 Fields 1 CDS Views

Coherent Cat - Categories

CRMC_ERMS_CAT_CA is an SAP database table in S/4HANA. Coherent Cat - Categories. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InvgCsMCatIDText view inner BASIC Category ID - Text

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY cat_guid CRM_ERMS_CAT_GUID Catego. GUID
cat_id CRM_ERMS_CAT_CA_ID Category ID
asp_guid CRM_ERMS_CAT_GUID Catego. GUID
cat_deleted CRM_ERMS_CAT_BOOLEAN Boolean
tstamp_create TIMESTAMP Time Stamp
tstamp_modify TIMESTAMP Time Stamp
resp_user UPNAME Last user changing
cat_sequence CRM_ERMS_CAT_SEQUENCE Category Sequence
cat_obsolete CRM_ERMS_CAT_OBSOLETE Obs Cat

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.

-- Coherent Cat - Categories
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMC_ERMS_CAT_CA (
    CLIENT,         -- Client [MANDT]
    CAT_GUID,       -- Catego. GUID [CRM_ERMS_CAT_GUID]
    CAT_ID,         -- Category ID [CRM_ERMS_CAT_CA_ID]
    ASP_GUID,       -- Catego. GUID [CRM_ERMS_CAT_GUID]
    CAT_DELETED,    -- Boolean [CRM_ERMS_CAT_BOOLEAN]
    TSTAMP_CREATE,  -- Time Stamp [TIMESTAMP]
    TSTAMP_MODIFY,  -- Time Stamp [TIMESTAMP]
    RESP_USER,      -- Last user changing [UPNAME]
    CAT_SEQUENCE,   -- Category Sequence [CRM_ERMS_CAT_SEQUENCE]
    CAT_OBSOLETE,   -- Obs Cat [CRM_ERMS_CAT_OBSOLETE]
    PRIMARY KEY (CLIENT, CAT_GUID)
);

Learn More