SAP ABAP View ICL_ACTVTY_SUBCL (Activity by Claim)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	ICL_ACTVTY_SUBCL
Short Description	Activity by Claim
Root table	ICLSUBCL	Subclaim

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLSUBCL	ICLSUBCL
2	ICLACTIVITY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLSUBCL	CLIENT	JL	EQ				0	0
2	ICLACTIVITY	CLIENT	JR	EQ			AND	0	0
3	ICLSUBCL	ACTIVE	JL	EQ				0	0
4	ICLACTIVITY	ACTIVE	JR	EQ			AND	0	0
5	ICLSUBCL	CLAIM	JL	EQ				0	0
6	ICLACTIVITY	CLAIM	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	ICLACTIVITY	*		☐		☐
2	CLIENT	ICLACTIVITY	CLIENT		☐	MANDT	☐	Client
3	ACTIVE	ICLACTIVITY	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
4	CLAIM	ICLACTIVITY	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
5	SUBCLAIM	ICLACTIVITY	SUBCLAIM		☐	ICL_SUBCL	☐	Subclaim
6	ACTNUMBER	ICLACTIVITY	ACTNUMBER		☐	ICL_ACTIVITYNO	☐	Sequence Number of Activity
7	CHANGETIME	ICLACTIVITY	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
8	CHANGEDBY	ICLACTIVITY	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
9	DELETED	ICLACTIVITY	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
10	CREATEDBY	ICLACTIVITY	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
11	CREATETIME	ICLACTIVITY	CREATETIME		☐	ICL_CREATEUTC	☐	Created: UTC Date+Time
12	ACTIVITY	ICLACTIVITY	ACTIVITY		☐	ICL_ACTIVITY	☐	Activity Management: Task
13	XMANUAL	ICLACTIVITY	XMANUAL		☐	ICL_ACTIVITY02	☐	Activity Set Manually
14	TEXT	ICLACTIVITY	TEXT		☐	ICL_ACTIVITYT	☐	Task Name
15	DUETIME	ICLACTIVITY	DUETIME		☐	ICL_DUETIME	☐	Due Time
16	XDONE	ICLACTIVITY	XDONE		☐	ICL_XDONE	☐	Task Completed
17	ACT_STATUS	ICLACTIVITY	ACT_STATUS		☐	ICL_ACTLOG_STATUS	☐	Activity Management: Status of a Task
18	NAVIGATE	ICLACTIVITY	NAVIGATE		☐	ICL_ACTNAV	☐	Navigation Target
19	SUBOBJCAT	ICLACTIVITY	SUBOBJCAT		☐	ICL_SUBOBJCAT	☐	Claim Subobject Category
20	SUBOBJECT	ICLACTIVITY	SUBOBJECT		☐	ICL_SUBOBJECTA	☐	ID of Claim Subobject for Navigation
21	ACT_ASSIGN_STATE	ICLACTIVITY	ACT_ASSIGN_STATE		☐	ICL_ASSIGN_STATE	☐	Assignment Status of a Claim Subobject
22	ACT_HANDLERTYPE	ICLACTIVITY	ACT_HANDLERTYPE		☐	ICL_HANDLERTYPE	☐	Object Category of Subclaim Handler
23	ACT_HANDLER	ICLACTIVITY	ACT_HANDLER		☐	ICL_ACT_HANDLER	☐	Claim Handler for Task
24	ACT_HNDLRTP_GRP	ICLACTIVITY	ACT_HNDLRTP_GRP		☐	ICL_HANDLERTYPE2	☐	Object Category of Subclaim Handler Group
25	ACT_HANDLER_GRP	ICLACTIVITY	ACT_HANDLER_GRP		☐	ICL_ACT_HANDLER_GRP	☐	Claim Handler Group for Task
26	PRIORITY	ICLACTIVITY	PRIORITY		☐	ICL_ACTIVITYPRIO	☐	(Do Not Use For Timebeing) Priority of Task
27	SUBACTIVITYUSED	ICLACTIVITY	SUBACTIVITYUSED		☐	ICL_SUBACTIVITYUSED	☐	Activity Used to Process the Task
28	RESUBM_TIME	ICLACTIVITY	RESUBM_TIME		☐	ICL_RESUBM_ACT	☐	Resubmission of a Task
29	ACT_GRP_CAT	ICLACTIVITY	ACT_GRP_CAT		☐	IGN_ACT_GRP_CAT	☐	Activity Management: Task Type
30	EXPRESSION_ORIG	ICLACTIVITY	EXPRESSION_ORIG		☐	ICL_EXPRESSION_ORIG	☐	Expression Responsible for Anomaly (Control Predicate)
31	DUEDATE_TIME1	ICLACTIVITY	DUEDATE_TIME1		☐	ICL_DUEDATE_TIME1	☐	Date/Time for First Submission in Workplace
32	DUEDATE_TIME2	ICLACTIVITY	DUEDATE_TIME2		☐	ICL_DUEDATE_TIME2	☐	Date/Time for Latest Start of Task
33	DUEDATE_TIME3	ICLACTIVITY	DUEDATE_TIME3		☐	ICL_DUEDATE_TIME3	☐	Date/Time for Latest End of Task
34	MAN_OTYPE	ICLACTIVITY	MAN_OTYPE		☐	ICL_MAN_OTYPE	☐	Manual Task: Claim Handler Category
35	MAN_ACTORID	ICLACTIVITY	MAN_ACTORID		☐	ICL_MAN_ACTORID	☐	Proposed Handler for This Manual Task
36	PRIORITY_WF	ICLACTIVITY	PRIORITY_WF		☐	ICL_TASK_PRIORITY_WF	☐	Activity Management: Priority of Task - Workflow
37	AUTHGRP	ICLACTIVITY	AUTHGRP		☐	ICL_AUTHGRP	☐	Authorization Group
38	CCTYPE	ICLACTIVITY	CCTYPE		☐	ICL_ACT_CCEVENTCAT	☐	Claim Bundle Type
39	TASK_CCEVENT	ICLACTIVITY	TASK_CCEVENT		☐	ICLE_MESSAGE	☐	Claim Bundle: Task/Log Entry
40	XSYSTEM_ACTIVITY	ICLACTIVITY	XSYSTEM_ACTIVITY		☐	IAM_XSYSTEM_ACTIVITY	☐	Activity Is System Activity
41	MANUAL_TASK_ONLY	ICLACTIVITY	MANUAL_TASK_ONLY		☐	IAM_MANUAL_TASK_ONLY	☐	Purely Manual Task
42	MANUAL_CHARACTER	ICLACTIVITY	MANUAL_CHARACTER		☐	IAM_MANUAL_CHARACTER	☐	Task Has Manual Character
43	WF_RELEVANT	ICLACTIVITY	WF_RELEVANT		☐	ICL_WF_RELEVANT	☐	Activity Management: Relevant for Workflow
44	WF_STATUS	ICLACTIVITY	WF_STATUS		☐	ICL_WF_STATUS	☐	Workflow Status
45	REF_OBJCAT	ICLACTIVITY	REF_OBJCAT		☐	ICL_PARTOBJCAT	☐	Claims Management Object Category
46	REF_OBJECT	ICLACTIVITY	REF_OBJECT		☐	ICL_OBJECT	☐	Claims Management Object
47	REFTASK_SUBCLAIM	ICLACTIVITY	REFTASK_SUBCLAIM		☐	IAM_REFTASK_SUBCL	☐	Subclaim of Reference Task
48	REFTASK_ACTNO	ICLACTIVITY	REFTASK_ACTNO		☐	IAM_REFTASK_ACTIVITYNO	☐	Sequence Number of Reference Task
49	REFTASK_CATEGORY	ICLACTIVITY	REFTASK_CATEGORY		☐	IAM_REFTASK_CAT	☐	Category of Reference Task
50	PARENT_SUBCLAIM	ICLACTIVITY	PARENT_SUBCLAIM		☐	IAM_PARENT_SUBCLAIM	☐	Higher-Level Claim Subobject - Subclaim
51	PARENT_SUBOBJCAT	ICLACTIVITY	PARENT_SUBOBJCAT		☐	IAM_PARENT_SUBOBJCAT	☐	Higher-Level Claim Subobject - Subobject Category
52	PARENT_SUBOBJECT	ICLACTIVITY	PARENT_SUBOBJECT		☐	IAM_PARENT_SUBOBJECT	☐	Higher-Level Claim Subobject - Subobject
53	WI_ID	ICLACTIVITY	WI_ID		☐	SWW_WIID	☐	Work item ID
54	HANDLERTYPE	ICLSUBCL	HANDLERTYPE		☐	ICL_HANDLERTYPE	☐	Object Category of Subclaim Handler
55	CLAIMHANDLER	ICLSUBCL	CLAIMHANDLER		☐	ICL_SUBCLCH	☐	Claim Handler for Subclaim
56	SSTATUS	ICLSUBCL	STATUS		☐	ICL_SUBCL10	☐	Status of Subclaim

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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