CRM_JCDS

Transparent Table Application Table
10 Fields 3 CDS Views

Change Documents for System/User Statuses (Table JEST)

CRM_JCDS is an SAP database table in S/4HANA. Change Documents for System/User Statuses (Table JEST). It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BankPaymentBatchRejectAlert view from BASIC Rejection Alert for Payment Batch
I_CustomerStatus view_entity from BASIC Customer Status
I_SrvcMgmtObjStsChgInformation view from BASIC View to read from DB table CRM_JCDS

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objnr CRMT_OBJECT_GUID Object GUID
KEY stat CRM_J_STATUS Status
KEY chgnr CRM_J_CHGNR Change Number
usnam CDUSERNAME User
udate CDDATUM Date
utime CDUZEIT Time
cdtcode CDTCODE Transaction
inact CRM_J_INACT Status Inact.
chind CRM_J_CHIND Change Ind

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.

-- Change Documents for System/User Statuses (Table JEST)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRM_JCDS (
    MANDT,    -- Client [MANDT]
    OBJNR,    -- Object GUID [CRMT_OBJECT_GUID]
    STAT,     -- Status [CRM_J_STATUS]
    CHGNR,    -- Change Number [CRM_J_CHGNR]
    USNAM,    -- User [CDUSERNAME]
    UDATE,    -- Date [CDDATUM]
    UTIME,    -- Time [CDUZEIT]
    CDTCODE,  -- Transaction [CDTCODE]
    INACT,    -- Status Inact. [CRM_J_INACT]
    CHIND,    -- Change Ind [CRM_J_CHIND]
    PRIMARY KEY (MANDT, OBJNR, STAT, CHGNR)
);

Learn More