SAP Table CRM_JCDS
Change Documents for System/User Statuses (Table JEST)
CRM_JCDS (Change Documents for System/User Statuses (Table JEST)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CRM_JCDS to other SAP tables.
CRM_JCDS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| OBJNR | GUID of a CRM Order Object | CRMT_OBJECT_GUID | CRM_JEST | RAW | 16 | 0 | ||||||
| STAT | Object Status | CRM_J_STATUS | CHAR | 5 | 0 | |||||||
| CHGNR | Change Number | CRM_J_CHGNR | NUMC | 3 | 0 | |||||||
| USNAM | User name of the person responsible in change document | CDUSERNAME | CHAR | 12 | 0 | |||||||
| UDATE | Creation date of the change document | CDDATUM | DATS | 8 | 0 | |||||||
| UTIME | Time changed | CDUZEIT | TIMS | 6 | 0 | |||||||
| CDTCODE | Transaction in which a change was made | CDTCODE | TSTC | CHAR | 20 | 0 | ||||||
| INACT | Indicator: Status Is Inactive | CRM_J_INACT | CHAR | 1 | 0 |
Possible values
|
||||||
| CHIND | Change Indicator | CRM_J_CHIND | CHAR | 1 | 0 |
Possible values
|
||||||
CRM_JCDS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CRM_JCDS | CDTCODE | CRM_JCDS | CDTCODE | TSTC | SAP Transaction Codes | TCODE |
| CRM_JCDS | MANDT | CRM_JCDS | MANDT | T000 | Clients | MANDT |
| CRM_JCDS | OBJNR | CRM_JCDS | MANDT | CRM_JEST | Individual Object Status | MANDT |
| CRM_JCDS | OBJNR | CRM_JCDS | OBJNR | CRM_JEST | Individual Object Status | OBJNR |
| CRM_JCDS | OBJNR | CRM_JCDS | STAT | CRM_JEST | Individual Object Status | STAT |
