SAP ABAP Table CRMD_ICM_REL (ICM Relationship: Relationship)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-IPS-ICM-REL (Application Component) Relationships and Reliability
⤷ CRM_ICM_REL_APP (Package) CRM ICM Relation - Relation application
⤷ CRM-IPS-ICM-REL (Application Component) Relationships and Reliability
⤷ CRM_ICM_REL_APP (Package) CRM ICM Relation - Relation application
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CRMD_ICM_REL | Table Relationship Diagram |
Short Description | ICM Relationship: Relationship |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | GUID | CRM_ICM_REL_GUID | SYSUUID | RAW | 16 | 0 | ICM Relationship: Relationship GUID | ||
3 | .INCLUDE | 0 | 0 | ICM Relationship: Relationship attributes | |||||
4 | REL_TYPE_ID | CRM_ICM_REL_TYPE_ID | CHAR | 4 | 0 | CRM ICM Relationship Type ID | CRMC_ICM_REL | ||
5 | SOURCE_GUID | CRM_ICM_REL_ENTITY_GUID | CHAR45 | CHAR | 45 | 0 | ICM Relationship: Relationship DB Table Entity GUID | ||
6 | TARGET_GUID | CRM_ICM_REL_ENTITY_GUID | CHAR45 | CHAR | 45 | 0 | ICM Relationship: Relationship DB Table Entity GUID | ||
7 | SECURITY_LEVEL | CRM_AUTH_SCOPE | CRM_AUTH_SCOPE | NUMC | 6 | 0 | Authorization Scope | * | |
8 | EXPUNGE_DATE | CRM_ICM_REL_DATE | SYDATS | DATS | 8 | 0 | ICM Relationship: Dates | ||
9 | VALID_FROM | CRM_ICM_REL_DATE | SYDATS | DATS | 8 | 0 | ICM Relationship: Dates | ||
10 | VALID_TO | CRM_ICM_REL_DATE | SYDATS | DATS | 8 | 0 | ICM Relationship: Dates | ||
11 | SOURCE_TYPE | CRM_ICM_REL_SRC_ENT_TYPE_ID | CRM_ICM_REL_SRC_ENTITY_TYPE | CHAR | 10 | 0 | CRM ICM Relationship, Entity Type ID | ||
12 | TARGET_TYPE | CRM_ICM_REL_TGT_ENT_TYPE_ID | CRM_ICM_REL_TGT_ENTITY_TYPE | CHAR | 10 | 0 | CRM ICM Relationship, Entity Type ID | ||
13 | DELETED | CRM_ICM_REL_FLAG | FLAG | CHAR | 1 | 0 | ICM Relationship: Delete Flag | ||
14 | ARCHIV_STATUS | CRM_ICM_REL_ARCHIV_STATUS | CRM_ICM_REL_ARCHIV_STATUS | CHAR | 1 | 0 | ICM Relationship Archive Status | ||
15 | ENTITIES_HASH | CRM_ICM_REL_ENTITIES_HASH | CHAR | 90 | 0 | ICM Relationship: Entities Hash | |||
16 | .INCLUDE | 0 | 0 | ICM Relationship: Administrative data for relation | |||||
17 | CREATED_ON | CRM_ICM_REL_ADMIN_DATE | TZNTSTMPS | DEC | 15 | 0 | ICM Relationship: Administration Date | ||
18 | CREATED_BY | CRM_ICM_REL_USER | SYCHAR12 | CHAR | 12 | 0 | ICM Relationship: User Name | ||
19 | CHANGED_ON | CRM_ICM_REL_ADMIN_DATE | TZNTSTMPS | DEC | 15 | 0 | ICM Relationship: Administration Date | ||
20 | CHANGED_BY | CRM_ICM_REL_USER | SYCHAR12 | CHAR | 12 | 0 | ICM Relationship: User Name | ||
21 | CREATED_BY_ORG | CRM_ICM_REL_ORG | BU_PARTNER | CHAR | 10 | 0 | ICM Relationship: Organizational Element | * | |
22 | CHANGED_BY_ORG | CRM_ICM_REL_ORG | BU_PARTNER | CHAR | 10 | 0 | ICM Relationship: Organizational Element | * | |
23 | .INCLUDE | 0 | 0 | ICM: Relationship include structure | |||||
24 | CRM_ICM_REL | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMD_ICM_REL | REL_TYPE_ID | CRMC_ICM_REL | REL_TYPE_ID | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |