CRMD_ICM_REL - ICM Relationship: Relationship
ICM Relationship: Relationship information is stored in SAP table CRMD_ICM_REL.
It is part of development package CRM_ICM_REL_APP in software component CRM-S4-IPS-ICM. This development package consists of objects that can be grouped under "CRM ICM Relation - Relation application".
It is part of development package CRM_ICM_REL_APP in software component CRM-S4-IPS-ICM. This development package consists of objects that can be grouped under "CRM ICM Relation - Relation application".
Fields for table CRMD_ICM_REL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| GUID | ICM Relationship: Relationship GUID | X | CRM_ICM_REL_GUID | RAW | 16 | |
| .INCLUDE | CRMS_ICM_REL_RELATION | 0 | ||||
| REL_TYPE_ID | ICM Relationship Type ID | CRM_ICM_REL_TYPE_ID | CHAR | 8 | CRMC_ICM_REL | |
| SOURCE_GUID | ICM Relationship: Relationship DB Table Entity GUID | CRM_ICM_REL_ENTITY_GUID | CHAR | 90 | ||
| TARGET_GUID | ICM Relationship: Relationship DB Table Entity GUID | CRM_ICM_REL_ENTITY_GUID | CHAR | 90 | ||
| SECURITY_LEVEL | Investigative Case Management Security Level | CRM_ICM_AUT_SEC_LVL | NUMC | 12 | ||
| EXPUNGE_DATE | ICM Relationship: Dates | CRM_ICM_REL_DATE | DATS | 16 | ||
| VALID_FROM | ICM Relationship: Dates | CRM_ICM_REL_DATE | DATS | 16 | ||
| VALID_TO | ICM Relationship: Dates | CRM_ICM_REL_DATE | DATS | 16 | ||
| SOURCE_TYPE | ICM Relationship, Entity Type ID | CRM_ICM_REL_SRC_ENT_TYPE_ID | CHAR | 20 | ||
| TARGET_TYPE | ICM Relationship, Entity Type ID | CRM_ICM_REL_TGT_ENT_TYPE_ID | CHAR | 20 | ||
| DELETED | ICM Relationship: Delete Flag | CRM_ICM_REL_FLAG | CHAR | 2 | ||
| ARCHIV_STATUS | ICM Relationship Archive Status | CRM_ICM_REL_ARCHIV_STATUS | CHAR | 2 | ||
| ENTITIES_HASH | ICM Relationship: Entities Hash | CRM_ICM_REL_ENTITIES_HASH | CHAR | 180 | ||
| .INCLUDE | CRMS_ICM_REL_ADMIN | 0 | ||||
| CREATED_ON | ICM Relationship: Administration Date | CRM_ICM_REL_ADMIN_DATE | DEC | 8 | ||
| CREATED_BY | ICM Relationship: User Name | CRM_ICM_REL_USER | CHAR | 24 | ||
| CHANGED_ON | ICM Relationship: Administration Date | CRM_ICM_REL_ADMIN_DATE | DEC | 8 | ||
| CHANGED_BY | ICM Relationship: User Name | CRM_ICM_REL_USER | CHAR | 24 | ||
| CREATED_BY_ORG | ICM Relationship: Organizational Element | CRM_ICM_REL_ORG | CHAR | 20 | * | |
| CHANGED_BY_ORG | ICM Relationship: Organizational Element | CRM_ICM_REL_ORG | CHAR | 20 | * | |
| .INCLUDE | CRMS4S_ICM_REL_INCL_EEW_PS | 0 | ||||
| ICM_REL_DUMMY | Custom Fields: Dummy for Use in Extension Includes | CFD_DUMMY | CHAR | 2 | ||
| HIDDEN_FLAG | ICM Case Hidden Checkbox | CRM_ICM_CMG_HIDDEN_FLAG | CHAR | 2 |