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 |