CRM_JEST

Transparent Table Application Table
5 Fields 17 CDS Views

Individual Object Status

CRM_JEST is an SAP database table in S/4HANA. Individual Object Status. It contains 5 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
/PF1/I_CRM_JEST view from CRM_JEST
FINOC_RULE_SRV_BASE view_entity left_outer Orgl Change-Rule: Service Doc Item Base
I_CndnContrActSystemStatus view from BASIC Active System Status
I_CollateralStatusObject view_entity from BASIC Collateral Object Status
I_DevelopmentStatusObjectBasic view from BASIC Individual Status Object
I_Ghocrmjest_Db view from BASIC Object Status
I_InvgCsMActyIncdntStatus view from BASIC Basic View for ICM Activity and Incident Status
I_Paymentstatistics_Base view left_outer BASIC Base View for Payment Statistics
I_SrvcMgmtObjectStatus view from BASIC CDS View for CRM Jest
P_Bcmitem view left_outer BASIC Analyze Payment Detail BCM Item
P_CndnContrActiveStatus view from BASIC
P_CndnContrActiveStatus view union_all BASIC
P_StatusObjectStatusWithGUID view union_all BASIC
P_StatusObjectStatusWithGUID view from BASIC
TSI_BAT_STATUS_entry view inner
VFCP_DDL_BCM view left_outer
VFCP_DDL_BCM view inner

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objnr CRMT_OBJECT_GUID Object GUID
KEY stat CRM_J_STATUS Status
inact CRM_J_INACT Status Inact.
chgnr CRM_J_CHGNR Change Number

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.

-- Individual Object Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRM_JEST (
    MANDT,  -- Client [MANDT]
    OBJNR,  -- Object GUID [CRMT_OBJECT_GUID]
    STAT,   -- Status [CRM_J_STATUS]
    INACT,  -- Status Inact. [CRM_J_INACT]
    CHGNR,  -- Change Number [CRM_J_CHGNR]
    PRIMARY KEY (MANDT, OBJNR, STAT)
);

Learn More