SAP ABAP Table ICSACTIVITY (Activity in the Claim)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSACTIVITY	Table Relationship Diagram
Short Description	Activity in the Claim

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	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
4	SUBCLAIM	☑	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
5	ACTNUMBER	☑	ICL_ACTIVITYNO	ICL_ACTIVITYNO	NUMC	4	0	Sequence Number of Activity	*
6	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
8	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
9	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
10	.INCLUDE	☐				0	0	Attributes of ICLACTIVITY
11	.INCLUDE	☐				0	0	Organizational Include (Short Version)
12	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
13	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
14	ACTIVITY	☐	ICL_ACTIVITY	ICL_MESSAGE	CHAR	6	0	Activity Management: Task	TICL044
15	XMANUAL	☐	ICL_ACTIVITY02	XFELD	CHAR	1	0	Activity Set Manually
16	TEXT	☐	ICL_ACTIVITYT	ICL_ACTIVITY_TEXT	CHAR	128	0	Task Name
17	DUETIME	☐	ICL_DUETIME	ICL_TIMESTAMP	DEC	15	0	Due Time
18	XDONE	☐	ICL_XDONE	XFELD	CHAR	1	0	Task Completed
19	ACT_STATUS	☐	ICL_ACTLOG_STATUS	ICL_ACTLOG_STATUS	CHAR	1	0	Activity Management: Status of a Task
20	NAVIGATE	☐	ICL_ACTNAV	ICL_ACTNAV	CHAR	4	0	Navigation Target	TICL019
21	SUBOBJCAT	☐	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	TICL013
22	SUBOBJECT	☐	ICL_SUBOBJECTA	ICL_SUBOBJECT	CHAR	16	0	ID of Claim Subobject for Navigation
23	ACT_ASSIGN_STATE	☐	ICL_ASSIGN_STATE	ICL_ASSIGN_STATE	CHAR	2	0	Assignment Status of a Claim Subobject
24	ACT_HANDLERTYPE	☐	ICL_HANDLERTYPE	OTYPE	CHAR	2	0	Object Category of Subclaim Handler	*
25	ACT_HANDLER	☐	ICL_ACT_HANDLER	XUBNAME	CHAR	12	0	Claim Handler for Task	*
26	ACT_HNDLRTP_GRP	☐	ICL_HANDLERTYPE2	OTYPE	CHAR	2	0	Object Category of Subclaim Handler Group	*
27	ACT_HANDLER_GRP	☐	ICL_ACT_HANDLER_GRP	XUBNAME	CHAR	12	0	Claim Handler Group for Task	*
28	PRIORITY	☐	ICL_ACTIVITYPRIO	NUMC3	NUMC	3	0	(Do Not Use For Timebeing) Priority of Task
29	SUBACTIVITYUSED	☐	ICL_SUBACTIVITYUSED	ICL_SUBACTIVITY	CHAR	6	0	Activity Used to Process the Task	TICL039
30	RESUBM_TIME	☐	ICL_RESUBM_ACT	ICL_TIMESTAMP	DEC	15	0	Resubmission of a Task
31	ACT_GRP_CAT	☐	IGN_ACT_GRP_CAT	IGN_ACT_GRP_CAT	CHAR	2	0	Activity Management: Task Type	TICL037
32	EXPRESSION_ORIG	☐	ICL_EXPRESSION_ORIG	BRF_EXPRESSION	CHAR	20	0	Expression Responsible for Anomaly (Control Predicate)	*
33	DUEDATE_TIME1	☐	ICL_DUEDATE_TIME1	ICL_TIMESTAMP	DEC	15	0	Date/Time for First Submission in Workplace
34	DUEDATE_TIME2	☐	ICL_DUEDATE_TIME2	ICL_TIMESTAMP	DEC	15	0	Date/Time for Latest Start of Task
35	DUEDATE_TIME3	☐	ICL_DUEDATE_TIME3	ICL_TIMESTAMP	DEC	15	0	Date/Time for Latest End of Task
36	MAN_OTYPE	☐	ICL_MAN_OTYPE	OTYPE	CHAR	2	0	Manual Task: Claim Handler Category	T779O
37	MAN_ACTORID	☐	ICL_MAN_ACTORID	HROBJID_12	CHAR	12	0	Proposed Handler for This Manual Task
38	PRIORITY_WF	☐	ICL_TASK_PRIORITY_WF	SWD_PRIORI	NUMC	1	0	Activity Management: Priority of Task - Workflow
39	AUTHGRP	☐	ICL_AUTHGRP	ICL_AUTHGRP	CHAR	4	0	Authorization Group	*
40	CCTYPE	☐	ICL_ACT_CCEVENTCAT	ICL_CCEVENTCAT	CHAR	2	0	Claim Bundle Type	TICL001
41	TASK_CCEVENT	☐	ICLE_MESSAGE	ICLE_MESSAGE	CHAR	6	0	Claim Bundle: Task/Log Entry	TICL950
42	XSYSTEM_ACTIVITY	☐	IAM_XSYSTEM_ACTIVITY	IAM_BOOLE_D	CHAR	1	0	Activity Is System Activity
43	MANUAL_TASK_ONLY	☐	IAM_MANUAL_TASK_ONLY	IAM_BOOLE_D	CHAR	1	0	Purely Manual Task
44	MANUAL_CHARACTER	☐	IAM_MANUAL_CHARACTER	IAM_BOOLE_D	CHAR	1	0	Task Has Manual Character
45	WF_RELEVANT	☐	ICL_WF_RELEVANT	ICL_KIND	CHAR	1	0	Activity Management: Relevant for Workflow
46	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
47	REF_OBJCAT	☐	ICL_PARTOBJCAT	ICL_PARTOBJCAT	CHAR	2	0	Claims Management Object Category	*
48	REF_OBJECT	☐	ICL_OBJECT	ICL_OBJECT	CHAR	17	0	Claims Management Object
49	REFTASK_SUBCLAIM	☐	IAM_REFTASK_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim of Reference Task	*
50	REFTASK_ACTNO	☐	IAM_REFTASK_ACTIVITYNO	ICL_ACTIVITYNO	NUMC	4	0	Sequence Number of Reference Task	*
51	REFTASK_CATEGORY	☐	IAM_REFTASK_CAT	IAM_REFTASK_CAT	CHAR	2	0	Category of Reference Task
52	PARENT_SUBCLAIM	☐	IAM_PARENT_SUBCLAIM	ICL_SUBCL	CHAR	3	0	Higher-Level Claim Subobject - Subclaim	*
53	PARENT_SUBOBJCAT	☐	IAM_PARENT_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Higher-Level Claim Subobject - Subobject Category	*
54	PARENT_SUBOBJECT	☐	IAM_PARENT_SUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Higher-Level Claim Subobject - Subobject
55	WI_ID	☐	SWW_WIID	SWW_WIID	NUMC	12	0	Work item ID	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSACTIVITY	ACTIVITY	TICL044	MESSAGE
2	ICSACTIVITY	ACT_GRP_CAT	TICL037	ACT_GRP_CAT
3	ICSACTIVITY	CCTYPE	TICL001	CCTYPE
4	ICSACTIVITY	CHANGEDBY	USR02	BNAME
5	ICSACTIVITY	CLAIM	ICLCLAIM	CLAIM
6	ICSACTIVITY	CLIENT	T000	MANDT
7	ICSACTIVITY	CREATEDBY	USR02	BNAME
8	ICSACTIVITY	MAN_OTYPE	T779O	OTYPE
9	ICSACTIVITY	NAVIGATE	TICL019	ACTNAV
10	ICSACTIVITY	SUBACTIVITYUSED	TICL039	SUBACTIVITY
11	ICSACTIVITY	SUBCLAIM	ICLSUBCL	SUBCLAIM
12	ICSACTIVITY	SUBOBJCAT	TICL013	SUBOBJCAT
13	ICSACTIVITY	TASK_CCEVENT	TICL950	MESSAGE

History

Last changed by/on	SAP	20110901
SAP Release Created in