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

SAP table 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 Object number CHAR 22 0 JEST J_OBJNR
STAT Object status CHAR 5 0 J_STATUS
CHGNR Change number NUMC 3 0 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
TCODE Transaction code CHAR 4 0 OLD_TCODE
CDTCODE Transaction in which a change was made CHAR 20 0 TSTC CDTCODE
INACT Indicator: Status Is Inactive CHAR 1 0 J_INACT
Active
X Not active
CHIND Change Indicator CHAR 1 0 J_CHIND
I Insert
U Update
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

JCDS foreign key relationships

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