1. Home
  2. Resources
  3. SAP Tables
  4. ICL_ACTVTY_CLAIM - Generated Table for View

SAP Table ICL_ACTVTY_CLAIM

Generated Table for View

ICL_ACTVTY_CLAIM (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ICL_ACTVTY_CLAIM to other SAP tables.

ICL_ACTVTY_CLAIM table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ACTIVE Table entry is active (A) or in suspense (S) ICL_ACTIVE CHAR 1 0
A Table Entry Is Active
S Table Entry Is in Suspense
CLAIM Number of Claim ICL_CLAIM ICLCLAIM CHAR 17 0
SUBCLAIM Subclaim ICL_SUBCL ICLSUBCL CHAR 3 0
ACTNUMBER Sequence Number of Activity ICL_ACTIVITYNO NUMC 4 0
CHANGETIME Changed: Date + Time ICL_CHANGEUTC1 DEC 15 0
CHANGEDBY Changed By ICL_CHANGEDBY USR02 CHAR 12 0
DELETED Database Line Status (Original, Changed, Deleted) ICL_RECSTATUS CHAR 1 0
O Original
C Changed
X Deleted
CREATEDBY Created By ICL_CREATEDBY USR02 CHAR 12 0
CREATETIME Created: Date + Time ICL_CREATEUTC DEC 15 0
ACTIVITY Activity Management: Task ICL_ACTIVITY TICL044 CHAR 6 0
XMANUAL Activity Set Manually ICL_ACTIVITY02 CHAR 1 0
X Yes
NULL No
TEXT Task Name ICL_ACTIVITYT CHAR 128 0
DUETIME Due Time ICL_DUETIME DEC 15 0
XDONE Task Completed ICL_XDONE CHAR 1 0
X Yes
NULL No
ACT_STATUS Activity Management: Status of a Task ICL_ACTLOG_STATUS CHAR 1 0
0 Unknown
1 Anomalous, Not Yet Displayed
2 Anomalous, Awaiting Activity
3 Anomalous, Awaiting End
5 Completed, Awaiting Expiry of Validity
7 Completed, Validity Expired
8 Log Entry
9 Invalid
V Completed, Validity Reset Early
NAVIGATE Navigation Target ICL_ACTNAV TICL019 CHAR 4 0
SUBOBJCAT Claim Subobject Category ICL_SUBOBJCAT TICL013 CHAR 2 0
SUBOBJECT ID of Claim Subobject for Navigation ICL_SUBOBJECTA CHAR 16 0
ACT_ASSIGN_STATE Assignment Status of a Claim Subobject ICL_ASSIGN_STATE CHAR 2 0
NULL Undefined: Should Not Appear in Operative System
UU Group and Claim Handler Not Assigned
AU Group Assigned Automatically, Claim Handler Not Assigned
MU Group Assigned Manually, Claim Handler Not Assigned
XU Group Incorrect, Claim Handler Not Assigned
UA Group Not Assigned, Claim Handler Assigned Automatically
AA Groupe and Claim Handler Assigned Automatically
MA Group Assigned Manually, Claim Hdler Assigned Automatically
XA Group Incorrect, Claim Handler Assigned Automatically
UM Group Not Assigned, Claim Handler Assigned Manually
AM Group Assigned Automatically, Claim Handler Assgnd Manually
MM Group and Claim Handler Assigned Manually
XM Group Incorrect, Claim Handler Assigned Manually
UX Group Not Assigned, Claim Handler Assigned Incorrectly
AX Group Assigned Automatically, Claim Hdler Assigned Incorrect
MX Group Assigned Manually, Claim Hdler Assigned Incorrectly
XX Group and Claim Handler Assigned Incorrectly
ACT_HANDLERTYPE Object Category of Subclaim Handler ICL_HANDLERTYPE CHAR 2 0
ACT_HANDLER Claim Handler for Task ICL_ACT_HANDLER CHAR 12 0
ACT_HNDLRTP_GRP Object Category of Subclaim Handler Group ICL_HANDLERTYPE2 CHAR 2 0
ACT_HANDLER_GRP Claim Handler Group for Task ICL_ACT_HANDLER_GRP CHAR 12 0
PRIORITY (Do Not Use For Timebeing) Priority of Task ICL_ACTIVITYPRIO NUMC 3 0
SUBACTIVITYUSED Activity Used to Process the Task ICL_SUBACTIVITYUSED TICL039 CHAR 6 0
RESUBM_TIME Resubmission of a Task ICL_RESUBM_ACT DEC 15 0
ACT_GRP_CAT Activity Management: Task Type IGN_ACT_GRP_CAT TICL037 CHAR 2 0
EXPRESSION_ORIG Expression Responsible for Anomaly (Control Predicate) ICL_EXPRESSION_ORIG CHAR 20 0
DUEDATE_TIME1 Date/Time for First Submission in Workplace ICL_DUEDATE_TIME1 DEC 15 0
DUEDATE_TIME2 Date/Time for Latest Start of Task ICL_DUEDATE_TIME2 DEC 15 0
DUEDATE_TIME3 Date/Time for Latest End of Task ICL_DUEDATE_TIME3 DEC 15 0
MAN_OTYPE Manual Task: Claim Handler Category ICL_MAN_OTYPE T779O CHAR 2 0
MAN_ACTORID Proposed Handler for This Manual Task ICL_MAN_ACTORID CHAR 12 0
PRIORITY_WF Activity Management: Priority of Task - Workflow ICL_TASK_PRIORITY_WF NUMC 1 0
1 1 Highest - Express
2 2 Very high
3 3 Higher
4 4 High
5 5 Medium
6 6 Low
7 7 Lower
8 8 Very low
9 9 Lowest
AUTHGRP Authorization Group ICL_AUTHGRP CHAR 4 0
CCTYPE Claim Bundle Type ICL_ACT_CCEVENTCAT TICL001 CHAR 2 0
TASK_CCEVENT Claim Bundle: Task/Log Entry ICLE_MESSAGE TICL950 CHAR 6 0
XSYSTEM_ACTIVITY Activity Is System Activity IAM_XSYSTEM_ACTIVITY CHAR 1 0
NULL False, No, 0 ...
X True, Yes, 1 ...
MANUAL_TASK_ONLY Purely Manual Task IAM_MANUAL_TASK_ONLY CHAR 1 0
NULL False, No, 0 ...
X True, Yes, 1 ...
MANUAL_CHARACTER Task Has Manual Character IAM_MANUAL_CHARACTER CHAR 1 0
NULL False, No, 0 ...
X True, Yes, 1 ...
WF_RELEVANT Activity Management: Relevant for Workflow ICL_WF_RELEVANT CHAR 1 0
NULL Version Through 4.71
X Workflow
N Not Workflow
WF_STATUS Workflow Status ICL_WF_STATUS NUMC 1 0
1 Workflow Not Started
2 Workflow Started
3 Workflow Completed
4 Workflow Started Again
REF_OBJCAT Claims Management Object Category ICL_PARTOBJCAT CHAR 2 0
REF_OBJECT Claims Management Object ICL_OBJECT CHAR 17 0
REFTASK_SUBCLAIM Subclaim of Reference Task IAM_REFTASK_SUBCL CHAR 3 0
REFTASK_ACTNO Sequence Number of Reference Task IAM_REFTASK_ACTIVITYNO NUMC 4 0
REFTASK_CATEGORY Category of Reference Task IAM_REFTASK_CAT CHAR 2 0
N Successor
V Predecessor
Z Interim Completion
PARENT_SUBCLAIM Higher-Level Claim Subobject - Subclaim IAM_PARENT_SUBCLAIM CHAR 3 0
PARENT_SUBOBJCAT Higher-Level Claim Subobject - Subobject Category IAM_PARENT_SUBOBJCAT CHAR 2 0
PARENT_SUBOBJECT Higher-Level Claim Subobject - Subobject IAM_PARENT_SUBOBJECT CHAR 16 0
WI_ID Work item ID SWW_WIID NUMC 12 0
TEXT_LANGU Language Key of Field for Name of Task ICL_TEXT_LANGU LANG 1 0
XFORWARDED Space = false, 'X' = true IAM_BOOLE_D CHAR 1 0
NULL False, No, 0 ...
X True, Yes, 1 ...
OWNERTYPE Object Type of Claim Handler ICL_OWNERTYPE T778O CHAR 2 0
OWNER ID of Claim Handler ICL_CLAIMOWNER CHAR 12 0
STATUS Status of Claim ICL_CLSTATUS TICL140 CHAR 2 0

ICL_ACTVTY_CLAIM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ICL_ACTVTY_CLAIM ACTIVITY SYST MANDT TICL044 Claims Management Activity or Prompting Message CLIENT
ICL_ACTVTY_CLAIM ACTIVITY ICL_ACTVTY_CLAIM ACTIVITY TICL044 Claims Management Activity or Prompting Message MESSAGE
ICL_ACTVTY_CLAIM ACT_GRP_CAT SYST MANDT TICL037 Activity Management: Task Type CLIENT
ICL_ACTVTY_CLAIM ACT_GRP_CAT ICL_ACTVTY_CLAIM ACT_GRP_CAT TICL037 Activity Management: Task Type ACT_GRP_CAT
ICL_ACTVTY_CLAIM CCTYPE SYST MANDT TICL001 Claim Bundle Type CLIENT
ICL_ACTVTY_CLAIM CCTYPE ICL_ACTVTY_CLAIM CCTYPE TICL001 Claim Bundle Type CCTYPE
ICL_ACTVTY_CLAIM CHANGEDBY ICL_ACTVTY_CLAIM CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICL_ACTVTY_CLAIM CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICL_ACTVTY_CLAIM CLAIM 'A' ICLCLAIM Claim ACTIVE
ICL_ACTVTY_CLAIM CLAIM ICL_ACTVTY_CLAIM CLAIM ICLCLAIM Claim CLAIM
ICL_ACTVTY_CLAIM CLAIM ICL_ACTVTY_CLAIM CLIENT ICLCLAIM Claim CLIENT
ICL_ACTVTY_CLAIM CLIENT ICL_ACTVTY_CLAIM CLIENT T000 Clients MANDT
ICL_ACTVTY_CLAIM CREATEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICL_ACTVTY_CLAIM CREATEDBY ICL_ACTVTY_CLAIM CREATEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICL_ACTVTY_CLAIM MAN_OTYPE SYST MANDT T779O Object Types Allowed for Rule Resolution MANDT
ICL_ACTVTY_CLAIM MAN_OTYPE ICL_ACTVTY_CLAIM MAN_OTYPE T779O Object Types Allowed for Rule Resolution OTYPE
ICL_ACTVTY_CLAIM NAVIGATE SYST MANDT TICL019 Navigation Targets in Claim CLIENT
ICL_ACTVTY_CLAIM NAVIGATE ICL_ACTVTY_CLAIM NAVIGATE TICL019 Navigation Targets in Claim ACTNAV
ICL_ACTVTY_CLAIM OWNERTYPE ICL_ACTVTY_CLAIM CLIENT T778O Object Types MANDT
ICL_ACTVTY_CLAIM OWNERTYPE ICL_ACTVTY_CLAIM OWNERTYPE T778O Object Types OTYPE
ICL_ACTVTY_CLAIM STATUS ICL_ACTVTY_CLAIM STATUS TICL140 Claim Status / Subclaim Status STATUS
ICL_ACTVTY_CLAIM STATUS SYST MANDT TICL140 Claim Status / Subclaim Status CLIENT
ICL_ACTVTY_CLAIM SUBACTIVITYUSED * TICL039 Claims Management - Assignment Activity to Task CLTYPE
ICL_ACTVTY_CLAIM SUBACTIVITYUSED ICL_ACTVTY_CLAIM ACTIVITY TICL039 Claims Management - Assignment Activity to Task MESSAGE
ICL_ACTVTY_CLAIM SUBACTIVITYUSED ICL_ACTVTY_CLAIM SUBACTIVITYUSED TICL039 Claims Management - Assignment Activity to Task SUBACTIVITY
ICL_ACTVTY_CLAIM SUBACTIVITYUSED SYST MANDT TICL039 Claims Management - Assignment Activity to Task CLIENT
ICL_ACTVTY_CLAIM SUBCLAIM ICL_ACTVTY_CLAIM SUBCLAIM ICLSUBCL Subclaim SUBCLAIM
ICL_ACTVTY_CLAIM SUBCLAIM ICL_ACTVTY_CLAIM CLIENT ICLSUBCL Subclaim CLIENT
ICL_ACTVTY_CLAIM SUBCLAIM 'A' ICLSUBCL Subclaim ACTIVE
ICL_ACTVTY_CLAIM SUBCLAIM ICL_ACTVTY_CLAIM CLAIM ICLSUBCL Subclaim CLAIM
ICL_ACTVTY_CLAIM SUBOBJCAT ICL_ACTVTY_CLAIM CLIENT TICL013 Claims Management Subobject Category CLIENT
ICL_ACTVTY_CLAIM SUBOBJCAT 'C' TICL013 Claims Management Subobject Category OBJCAT
ICL_ACTVTY_CLAIM SUBOBJCAT ICL_ACTVTY_CLAIM SUBOBJCAT TICL013 Claims Management Subobject Category SUBOBJCAT
ICL_ACTVTY_CLAIM TASK_CCEVENT SYST MANDT TICL950 Claim Bundle: Task or Prompting Message CLIENT
ICL_ACTVTY_CLAIM TASK_CCEVENT 'ICLE' TICL950 Claim Bundle: Task or Prompting Message APPLCLASS
ICL_ACTVTY_CLAIM TASK_CCEVENT ICL_ACTVTY_CLAIM TASK_CCEVENT TICL950 Claim Bundle: Task or Prompting Message MESSAGE