SAP ABAP Table ICL_BW_ACTIVITY (Extract Structure for Tasks in Claim)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_ACTIVITY	Table Relationship Diagram
Short Description	Extract Structure for Tasks in Claim

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	471