SAP ABAP Table CRMS_BOL_ICM_RELACT_ATTR (BOL Activities Relationship Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS-ICM-REL (Application Component) Relationships and Reliability
     ⤷ CRM_ICM_BOL_REL (Package) CRM ICM: BOL for Relations

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BOL_ICM_RELACT_ATTR	Table Relationship Diagram
Short Description	BOL Activities Relationship Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	ICM Relationship Child attributes...
2	.INCLUDE	☐				0	0	CRM ICM: Relation Attributes
3	.INCLUDE	☐				0	0	ICM Relationship: Relationship attribute (object layer)
4	.INCLUDE	☐				0	0	ICM Relationship: Relationship
5	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	GUID	☐	CRM_ICM_REL_GUID	SYSUUID	RAW	16	0	ICM Relationship: Relationship GUID
7	.INCLUDE	☐				0	0	ICM Relationship: Relationship attributes
8	REL_TYPE_ID	☐	CRM_ICM_REL_TYPE_ID		CHAR	4	0	CRM ICM Relationship Type ID
9	SOURCE_GUID	☐	CRM_ICM_REL_ENTITY_GUID	CHAR45	CHAR	45	0	ICM Relationship: Relationship DB Table Entity GUID
10	TARGET_GUID	☐	CRM_ICM_REL_ENTITY_GUID	CHAR45	CHAR	45	0	ICM Relationship: Relationship DB Table Entity GUID
11	SECURITY_LEVEL	☐	CRM_AUTH_SCOPE	CRM_AUTH_SCOPE	NUMC	6	0	Authorization Scope	*
12	EXPUNGE_DATE	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
13	VALID_FROM	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
14	VALID_TO	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
15	SOURCE_TYPE	☐	CRM_ICM_REL_SRC_ENT_TYPE_ID	CRM_ICM_REL_SRC_ENTITY_TYPE	CHAR	10	0	CRM ICM Relationship, Entity Type ID
16	TARGET_TYPE	☐	CRM_ICM_REL_TGT_ENT_TYPE_ID	CRM_ICM_REL_TGT_ENTITY_TYPE	CHAR	10	0	CRM ICM Relationship, Entity Type ID
17	DELETED	☐	CRM_ICM_REL_FLAG	FLAG	CHAR	1	0	ICM Relationship: Delete Flag
18	ARCHIV_STATUS	☐	CRM_ICM_REL_ARCHIV_STATUS	CRM_ICM_REL_ARCHIV_STATUS	CHAR	1	0	ICM Relationship Archive Status
19	ENTITIES_HASH	☐	CRM_ICM_REL_ENTITIES_HASH		CHAR	90	0	ICM Relationship: Entities Hash
20	.INCLUDE	☐				0	0	ICM Relationship: Administrative data for relation
21	CREATED_ON	☐	CRM_ICM_REL_ADMIN_DATE	TZNTSTMPS	DEC	15	0	ICM Relationship: Administration Date
22	CREATED_BY	☐	CRM_ICM_REL_USER	SYCHAR12	CHAR	12	0	ICM Relationship: User Name
23	CHANGED_ON	☐	CRM_ICM_REL_ADMIN_DATE	TZNTSTMPS	DEC	15	0	ICM Relationship: Administration Date
24	CHANGED_BY	☐	CRM_ICM_REL_USER	SYCHAR12	CHAR	12	0	ICM Relationship: User Name
25	CREATED_BY_ORG	☐	CRM_ICM_REL_ORG	BU_PARTNER	CHAR	10	0	ICM Relationship: Organizational Element	*
26	CHANGED_BY_ORG	☐	CRM_ICM_REL_ORG	BU_PARTNER	CHAR	10	0	ICM Relationship: Organizational Element	*
27	.INCLUDE	☐				0	0	ICM: Relationship include structure
28	CRM_ICM_REL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	RELATIONSHIP_DESC	☐	CRM_ICM_REL_DESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Description
30	RELATIONSHIP_RDESC	☐	CRM_ICM_REL_RDESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Reverse Description
31	CATEGORY_ID	☐	CRM_ICM_REL_CAT_ID	CRM_ICM_REL_CATEGORY	CHAR	4	0	CRM ICM Relationship Category ID
32	SOURCE_DESC	☐	CRM_ICM_REL_ENT_DESC	DDTEXT	CHAR	60	0	ICM Relationship Description of the Entity
33	TARGET_DESC	☐	CRM_ICM_REL_ENT_DESC	DDTEXT	CHAR	60	0	ICM Relationship Description of the Entity
34	SOURCE_REL_DESC	☐	CRM_ICM_REL_DESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Description
35	SOURCE_REL_RDESC	☐	CRM_ICM_REL_RDESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Reverse Description
36	SOURCE_REL_GUID	☐	CRM_ICM_REL_GUID	SYSUUID	RAW	16	0	ICM Relationship: Relationship GUID
37	TARGET_REL_DESC	☐	CRM_ICM_REL_DESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Description
38	TARGET_REL_RDESC	☐	CRM_ICM_REL_RDESC	TEXT40	CHAR	40	0	CRM ICM Relationship Type Reverse Description
39	TARGET_REL_GUID	☐	CRM_ICM_REL_GUID	SYSUUID	RAW	16	0	ICM Relationship: Relationship GUID
40	REF_OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
41	REF_OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
42	CREATED_BY_DESC	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
43	CHANGED_BY_DESC	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
44	CREATED_BY_ORGDESC	☐	STEXT	TEXT40	CHAR	40	0	Object Name
45	CHANGED_BY_ORGDESC	☐	STEXT	TEXT40	CHAR	40	0	Object Name
46	CREATED_ON_IO	☐	DATS	DATS	DATS	8	0	Field of type DATS
47	CHANGED_ON_IO	☐	DATS	DATS	DATS	8	0	Field of type DATS
48	LINKING_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
49	.INCLUDE	☐				0	0	ICM Relationship Matrix Attributes.
50	MAT_GUID	☐	CRM_ICM_MAT_GUID	SYSUUID	RAW	16	0	ICM Matrix: Reliability Matrix GUID
51	MAT_REF_OBJKEY	☐	CRM_ICM_MAT_REF_OBJKEY	SWO_TYPEID	CHAR	70	0	ICM Matrix: Reliability Matrix Reference Object Key
52	MAT_REF_OBJTYPE	☐	CRM_ICM_MAT_REF_OBJTYPE	OJ_NAME	CHAR	10	0	ICM Matrix: Reliability Matrix Reference Object Type	*
53	MAT_REF_OBJ_SETTYPE	☐	CRM_ICM_MAT_REF_OBJ_SETTYPE	CHAR32	CHAR	32	0	ICM Matrix: Reliability Matrix Reference Object Set Type
54	.INCLUDE	☐				0	0	ICM: Reliability Fields.
55	SOURCE_RELI_ID	☐	CRM_ICM_MAT_SOURCE_REL_ID	CHAR3	CHAR	3	0	ICM Matrix : Source Reliability ID
56	INFO_RELI_ID	☐	CRM_ICM_MAT_INFO_REL_ID	CHAR3	CHAR	3	0	ICM Matrix: Information Reliability ID
57	HANDLING_CODE_ID	☐	CRM_ICM_MAT_HAND_CODE_ID	CHAR3	CHAR	3	0	ICM Matrix: Reliability Matrix Handling Code ID
58	LOGICAL_DELETE	☐	CRM_ICM_MAT_FLAG	FLAG	CHAR	1	0	ICM Matrix: Reliability Matrix Indicator
59	MAT_ARC_STATUS	☐	CRM_ICM_MAT_ARCHIV_STATUS	CRM_ICM_MAT_ARCHIV_STATUS	CHAR	1	0	ICM Reliability Matrix Archive Status
60	.INCLUDE	☐				0	0	ICM: Reliability Include structure
61	CRM_ICM_MAT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
62	.INCLUDE	☐				0	0	Structure for combinations of customized values.
63	ICON_PATH	☐	CRM_ICM_MAT_ICON_PATH		CHAR	100	0	Icon Path
64	COMBINATION	☐	CRM_ICM_MAT_RELIABILITY_ID	CHAR6	CHAR	6	0	ICM Matrix: Reliability ID
65	SOURCE_TYPE_DESC	☐	CRM_ICM_REL_ENT_DESC	DDTEXT	CHAR	60	0	ICM Relationship Description of the Entity
66	TARGET_TYPE_DESC	☐	CRM_ICM_REL_ENT_DESC	DDTEXT	CHAR	60	0	ICM Relationship Description of the Entity
67	CREATED_ON_TIME	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
68	CHANGED_ON_TIME	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
69	SOURCE_RELI_DESC	☐	CRM_ICM_MAT_SOURCE_REL_DESC	TEXT40	CHAR	40	0	ICM Matrix : Source Reliability Description
70	INFO_RELI_DESC	☐	CRM_ICM_MAT_INFO_REL_DESC	TEXT40	CHAR	40	0	ICM Matrix: Information Reliability Description
71	HANDLING_CODE_DESC	☐	CRM_ICM_MAT_HAND_CODE_DESC	TEXT40	CHAR	40	0	ICM Matrix: Reliability Matrix Handling Code Description
72	SECURITY_LEVEL_DESC	☐	CRM_ICM_AUT_SEC_LVL_DESC	CRM_ICM_AUT_SEC_LVL_DESC	CHAR	40	0	Investigative Case Management Security Level Description
73	MATRIX_LONG_TEXT	☐	CRM_ICM_MAT_RELI_LONG_TEXT	TEXT80	CHAR	80	0	ICM Matrix Reliability Long Text
74	MAIN	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
75	ACCOUNT	☐			STRG	0	0
76	ACT_LOCATION	☐	CRMT_ACTIVITY_LCTN	CRM_ACTIVITY_LOCATION	CHAR	100	0	Location
77	ACT_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
78	CATEGORY_DESC	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
79	CONTACT	☐			STRG	0	0
80	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
81	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
82	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
83	DOMINANT	☐	CRMT_DATES_DOMINANT	CRM_DATES_DOMINANT	CHAR	1	0	All Day Event
84	DUE	☐			STRG	0	0
85	EMAIL_BCC	☐			STRG	0	0
86	EMAIL_CC	☐			STRG	0	0
87	EMAIL_FROM	☐			STRG	0	0
88	EMAIL_TO	☐			STRG	0	0
89	EXPECTED_DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
90	LAW_ID	☐	CRM_ICM_LAW_ABRV	CRM_ICM_LAW_ABRV	CHAR	32	0	Legal Reference Abbreviation
91	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
92	PARTNER_NO	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
93	DESCRIPTION_NAME	☐	CRM_ICM_LAW_ABRV	CRM_ICM_LAW_ABRV	CHAR	32	0	Legal Reference Abbreviation
94	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
95	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
96	PROC_TYPE_DESCR_40	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
97	TIME_FROM	☐	SC_TIMEFRO	SYTIME	TIMS	6	0	From Time
98	TIME_TO	☐	SC_TIMETO	SYTIME	TIMS	6	0	To Time

History

Last changed by/on	SAP	20130604
SAP Release Created in	700