SAP ABAP Table ICL_ACTVTY_SUBCL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure ICL_ACTVTY_SUBCL   Table Relationship Diagram
Short Description Generated Table for View    
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 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 CHANGEDBY ICL_CHANGEDBY XUBNAME CHAR 12   0   Changed By USR02
8 DELETED ICL_RECSTATUS ICL_RECSTATUS CHAR 1   0   Database Line Status (Original, Changed, Deleted)  
9 CREATEDBY ICL_CREATEDBY XUBNAME CHAR 12   0   Created By USR02
10 CREATETIME ICL_CREATEUTC ICL_TIMESTAMP DEC 15   0   Created: UTC Date+Time  
11 ACTIVITY ICL_ACTIVITY ICL_MESSAGE CHAR 6   0   Activity Management: Task TICL044
12 XMANUAL ICL_ACTIVITY02 XFELD CHAR 1   0   Activity Set Manually  
13 TEXT ICL_ACTIVITYT ICL_ACTIVITY_TEXT CHAR 128   0   Task Name  
14 DUETIME ICL_DUETIME ICL_TIMESTAMP DEC 15   0   Due Time  
15 XDONE ICL_XDONE XFELD CHAR 1   0   Task Completed  
16 ACT_STATUS ICL_ACTLOG_STATUS ICL_ACTLOG_STATUS CHAR 1   0   Activity Management: Status of a Task  
17 NAVIGATE ICL_ACTNAV ICL_ACTNAV CHAR 4   0   Navigation Target TICL019
18 SUBOBJCAT ICL_SUBOBJCAT ICL_SUBOBJCAT CHAR 2   0   Claim Subobject Category TICL013
19 SUBOBJECT ICL_SUBOBJECTA ICL_SUBOBJECT CHAR 16   0   ID of Claim Subobject for Navigation  
20 ACT_ASSIGN_STATE ICL_ASSIGN_STATE ICL_ASSIGN_STATE CHAR 2   0   Assignment Status of a Claim Subobject  
21 ACT_HANDLERTYPE ICL_HANDLERTYPE OTYPE CHAR 2   0   Object Category of Subclaim Handler  
22 ACT_HANDLER ICL_ACT_HANDLER XUBNAME CHAR 12   0   Claim Handler for Task  
23 ACT_HNDLRTP_GRP ICL_HANDLERTYPE2 OTYPE CHAR 2   0   Object Category of Subclaim Handler Group  
24 ACT_HANDLER_GRP ICL_ACT_HANDLER_GRP XUBNAME CHAR 12   0   Claim Handler Group for Task  
25 PRIORITY ICL_ACTIVITYPRIO NUMC3 NUMC 3   0   (Do Not Use For Timebeing) Priority of Task  
26 SUBACTIVITYUSED ICL_SUBACTIVITYUSED ICL_SUBACTIVITY CHAR 6   0   Activity Used to Process the Task TICL039
27 RESUBM_TIME ICL_RESUBM_ACT ICL_TIMESTAMP DEC 15   0   Resubmission of a Task  
28 ACT_GRP_CAT IGN_ACT_GRP_CAT IGN_ACT_GRP_CAT CHAR 2   0   Activity Management: Task Type TICL037
29 EXPRESSION_ORIG ICL_EXPRESSION_ORIG BRF_EXPRESSION CHAR 20   0   Expression Responsible for Anomaly (Control Predicate)  
30 DUEDATE_TIME1 ICL_DUEDATE_TIME1 ICL_TIMESTAMP DEC 15   0   Date/Time for First Submission in Workplace  
31 DUEDATE_TIME2 ICL_DUEDATE_TIME2 ICL_TIMESTAMP DEC 15   0   Date/Time for Latest Start of Task  
32 DUEDATE_TIME3 ICL_DUEDATE_TIME3 ICL_TIMESTAMP DEC 15   0   Date/Time for Latest End of Task  
33 MAN_OTYPE ICL_MAN_OTYPE OTYPE CHAR 2   0   Manual Task: Claim Handler Category T779O
34 MAN_ACTORID ICL_MAN_ACTORID HROBJID_12 CHAR 12   0   Proposed Handler for This Manual Task  
35 PRIORITY_WF ICL_TASK_PRIORITY_WF SWD_PRIORI NUMC 1   0   Activity Management: Priority of Task - Workflow  
36 AUTHGRP ICL_AUTHGRP ICL_AUTHGRP CHAR 4   0   Authorization Group  
37 CCTYPE ICL_ACT_CCEVENTCAT ICL_CCEVENTCAT CHAR 2   0   Claim Bundle Type TICL001
38 TASK_CCEVENT ICLE_MESSAGE ICLE_MESSAGE CHAR 6   0   Claim Bundle: Task/Log Entry TICL950
39 XSYSTEM_ACTIVITY IAM_XSYSTEM_ACTIVITY IAM_BOOLE_D CHAR 1   0   Activity Is System Activity  
40 MANUAL_TASK_ONLY IAM_MANUAL_TASK_ONLY IAM_BOOLE_D CHAR 1   0   Purely Manual Task  
41 MANUAL_CHARACTER IAM_MANUAL_CHARACTER IAM_BOOLE_D CHAR 1   0   Task Has Manual Character  
42 WF_RELEVANT ICL_WF_RELEVANT ICL_KIND CHAR 1   0   Activity Management: Relevant for Workflow  
43 WF_STATUS ICL_WF_STATUS ICL_WF_STATUS NUMC 1   0   Workflow Status  
44 REF_OBJCAT ICL_PARTOBJCAT ICL_PARTOBJCAT CHAR 2   0   Claims Management Object Category  
45 REF_OBJECT ICL_OBJECT ICL_OBJECT CHAR 17   0   Claims Management Object  
46 REFTASK_SUBCLAIM IAM_REFTASK_SUBCL ICL_SUBCL CHAR 3   0   Subclaim of Reference Task  
47 REFTASK_ACTNO IAM_REFTASK_ACTIVITYNO ICL_ACTIVITYNO NUMC 4   0   Sequence Number of Reference Task  
48 REFTASK_CATEGORY IAM_REFTASK_CAT IAM_REFTASK_CAT CHAR 2   0   Category of Reference Task  
49 PARENT_SUBCLAIM IAM_PARENT_SUBCLAIM ICL_SUBCL CHAR 3   0   Higher-Level Claim Subobject - Subclaim  
50 PARENT_SUBOBJCAT IAM_PARENT_SUBOBJCAT ICL_SUBOBJCAT CHAR 2   0   Higher-Level Claim Subobject - Subobject Category  
51 PARENT_SUBOBJECT IAM_PARENT_SUBOBJECT ICL_SUBOBJECT CHAR 16   0   Higher-Level Claim Subobject - Subobject  
52 WI_ID SWW_WIID SWW_WIID NUMC 12   0   Work item ID  
53 HANDLERTYPE ICL_HANDLERTYPE OTYPE CHAR 2   0   Object Category of Subclaim Handler T778O
54 CLAIMHANDLER ICL_SUBCLCH XUBNAME CHAR 12   0   Claim Handler for Subclaim USR02
55 SSTATUS ICL_SUBCL10 ICL_STATUS CHAR 2   0   Status of Subclaim TICL140
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ICL_ACTVTY_SUBCL ACTIVITY TICL044 MESSAGE    
2 ICL_ACTVTY_SUBCL ACT_GRP_CAT TICL037 ACT_GRP_CAT    
3 ICL_ACTVTY_SUBCL CCTYPE TICL001 CCTYPE    
4 ICL_ACTVTY_SUBCL CHANGEDBY USR02 BNAME    
5 ICL_ACTVTY_SUBCL CLAIM ICLCLAIM CLAIM    
6 ICL_ACTVTY_SUBCL CLAIMHANDLER USR02 BNAME    
7 ICL_ACTVTY_SUBCL CLIENT T000 MANDT    
8 ICL_ACTVTY_SUBCL CREATEDBY USR02 BNAME    
9 ICL_ACTVTY_SUBCL HANDLERTYPE T778O OTYPE REF C CN
10 ICL_ACTVTY_SUBCL MAN_OTYPE T779O OTYPE    
11 ICL_ACTVTY_SUBCL NAVIGATE TICL019 ACTNAV    
12 ICL_ACTVTY_SUBCL SSTATUS TICL140 STATUS    
13 ICL_ACTVTY_SUBCL SUBACTIVITYUSED TICL039 SUBACTIVITY    
14 ICL_ACTVTY_SUBCL SUBCLAIM ICLSUBCL SUBCLAIM    
15 ICL_ACTVTY_SUBCL SUBOBJCAT TICL013 SUBOBJCAT    
16 ICL_ACTVTY_SUBCL TASK_CCEVENT TICL950 MESSAGE    
History
Last changed by/on SAP  20110901 
SAP Release Created in