SAP table CRM_JCDS (Change Documents for System/User Statuses (Table JEST))

SAP table CRM_JCDS has 4 primary key fields being MANDT,OBJNR,STAT,CHGNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OBJNR GUID of a CRM Order Object RAW 16 0 CRM_JEST CRMT_OBJECT_GUID
STAT Object Status CHAR 5 0 CRM_J_STATUS
CHGNR Change Number NUMC 3 0 CRM_J_CHGNR
USNAM User name of the person responsible in change document CHAR 12 0 CDUSERNAME
UDATE Creation date of the change document DATS 8 0 CDDATUM
UTIME Time changed TIMS 6 0 CDUZEIT
CDTCODE Transaction in which a change was made CHAR 20 0 TSTC CDTCODE
INACT Indicator: Status Is Inactive CHAR 1 0 CRM_J_INACT
Active
X Inactive
CHIND Change Indicator CHAR 1 0 CRM_J_CHIND
I Insert
U Update

CRM_JCDS foreign key relationships

Table Field Check Table Check Field
0 CRM_JCDS CDTCODE TSTC SAP Transaction Codes TCODE
1 CRM_JCDS MANDT T000 Clients MANDT
0 CRM_JCDS OBJNR CRM_JEST Individual Object Status MANDT
0 CRM_JCDS OBJNR CRM_JEST Individual Object Status OBJNR