ICLACTIVITY

Transparent Table Application Table
55 Fields 3 CDS Views

Tasks in Claim

ICLACTIVITY is an SAP database table in S/4HANA. Tasks in Claim. It contains 55 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_InsuranceClaimTask view_entity from EXTENSION Insurance Claim Task - Extension
I_InsurClaimServiceTaskDEX view_entity from BASIC Insurance Claim Task Data Extraction
I_InsurClaimTask view from BASIC Aufgaben bei Fall

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY subclaim ICL_SUBCL Subclaim
KEY actnumber ICL_ACTIVITYNO No.
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
createdby ICL_CREATEDBY Created By
createtime ICL_CREATEUTC Created at
activity ICL_ACTIVITY Task
xmanual ICL_ACTIVITY02 Manually
text ICL_ACTIVITYT Text
duetime ICL_DUETIME Due Time
xdone ICL_XDONE Completed
act_status ICL_ACTLOG_STATUS Task Status
navigate ICL_ACTNAV Navigatn Target
subobjcat ICL_SUBOBJCAT Subobject Cat.
subobject ICL_SUBOBJECTA Subobject
act_assign_state ICL_ASSIGN_STATE Assgmt Status
act_handlertype ICL_HANDLERTYPE Clm Hdlr Cat.
act_handler ICL_ACT_HANDLER Clm Hdlr for Task
act_hndlrtp_grp ICL_HANDLERTYPE2 Clm Hdlr Cat.
act_handler_grp ICL_ACT_HANDLER_GRP CH Gp Task
priority ICL_ACTIVITYPRIO Priority - Old
subactivityused ICL_SUBACTIVITYUSED Activity Used
resubm_time ICL_RESUBM_ACT Resubmission
act_grp_cat IGN_ACT_GRP_CAT Task Type
expression_orig ICL_EXPRESSION_ORIG Expressn Resp.
duedate_time1 ICL_DUEDATE_TIME1 1st Submssn
duedate_time2 ICL_DUEDATE_TIME2 Latest Start
duedate_time3 ICL_DUEDATE_TIME3 Latest End
man_otype ICL_MAN_OTYPE Clm Hdlr Cat.
man_actorid ICL_MAN_ACTORID Claim Handler
priority_wf ICL_TASK_PRIORITY_WF Priority
authgrp ICL_AUTHGRP Auth. Group
cctype ICL_ACT_CCEVENTCAT Clm Bundle Type
task_ccevent ICLE_MESSAGE Task/Log Entry
xsystem_activity IAM_XSYSTEM_ACTIVITY System Activity
manual_task_only IAM_MANUAL_TASK_ONLY Only Manl Task
manual_character IAM_MANUAL_CHARACTER Manl Character
wf_relevant ICL_WF_RELEVANT Workflow
wf_status ICL_WF_STATUS WF Status
ref_objcat ICL_PARTOBJCAT Object Category
ref_object ICL_OBJECT Number
reftask_subclaim IAM_REFTASK_SUBCL Ref.Subclaim
reftask_actno IAM_REFTASK_ACTIVITYNO Ref. Number
reftask_category IAM_REFTASK_CAT Ref. Category
parent_subclaim IAM_PARENT_SUBCLAIM Higher-Level Claim Subobject - Subclaim
parent_subobjcat IAM_PARENT_SUBOBJCAT Higher-Level Claim Subobject - Category
parent_subobject IAM_PARENT_SUBOBJECT Higher-Level Claim Subobject - Object
wi_id SWW_WIID Work Item ID
text_langu ICL_TEXT_LANGU Language Text
xforwarded IAM_BOOLE_D Boole
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tasks in Claim
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLACTIVITY (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    SUBCLAIM,          -- Subclaim [ICL_SUBCL]
    ACTNUMBER,         -- No. [ICL_ACTIVITYNO]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    CREATEDBY,         -- Created By [ICL_CREATEDBY]
    CREATETIME,        -- Created at [ICL_CREATEUTC]
    ACTIVITY,          -- Task [ICL_ACTIVITY]
    XMANUAL,           -- Manually [ICL_ACTIVITY02]
    TEXT,              -- Text [ICL_ACTIVITYT]
    DUETIME,           -- Due Time [ICL_DUETIME]
    XDONE,             -- Completed [ICL_XDONE]
    ACT_STATUS,        -- Task Status [ICL_ACTLOG_STATUS]
    NAVIGATE,          -- Navigatn Target [ICL_ACTNAV]
    SUBOBJCAT,         -- Subobject Cat. [ICL_SUBOBJCAT]
    SUBOBJECT,         -- Subobject [ICL_SUBOBJECTA]
    ACT_ASSIGN_STATE,  -- Assgmt Status [ICL_ASSIGN_STATE]
    ACT_HANDLERTYPE,   -- Clm Hdlr Cat. [ICL_HANDLERTYPE]
    ACT_HANDLER,       -- Clm Hdlr for Task [ICL_ACT_HANDLER]
    ACT_HNDLRTP_GRP,   -- Clm Hdlr Cat. [ICL_HANDLERTYPE2]
    ACT_HANDLER_GRP,   -- CH Gp Task [ICL_ACT_HANDLER_GRP]
    PRIORITY,          -- Priority - Old [ICL_ACTIVITYPRIO]
    SUBACTIVITYUSED,   -- Activity Used [ICL_SUBACTIVITYUSED]
    RESUBM_TIME,       -- Resubmission [ICL_RESUBM_ACT]
    ACT_GRP_CAT,       -- Task Type [IGN_ACT_GRP_CAT]
    EXPRESSION_ORIG,   -- Expressn Resp. [ICL_EXPRESSION_ORIG]
    DUEDATE_TIME1,     -- 1st Submssn [ICL_DUEDATE_TIME1]
    DUEDATE_TIME2,     -- Latest Start [ICL_DUEDATE_TIME2]
    DUEDATE_TIME3,     -- Latest End [ICL_DUEDATE_TIME3]
    MAN_OTYPE,         -- Clm Hdlr Cat. [ICL_MAN_OTYPE]
    MAN_ACTORID,       -- Claim Handler [ICL_MAN_ACTORID]
    PRIORITY_WF,       -- Priority [ICL_TASK_PRIORITY_WF]
    AUTHGRP,           -- Auth. Group [ICL_AUTHGRP]
    CCTYPE,            -- Clm Bundle Type [ICL_ACT_CCEVENTCAT]
    TASK_CCEVENT,      -- Task/Log Entry [ICLE_MESSAGE]
    XSYSTEM_ACTIVITY,  -- System Activity [IAM_XSYSTEM_ACTIVITY]
    MANUAL_TASK_ONLY,  -- Only Manl Task [IAM_MANUAL_TASK_ONLY]
    MANUAL_CHARACTER,  -- Manl Character [IAM_MANUAL_CHARACTER]
    WF_RELEVANT,       -- Workflow [ICL_WF_RELEVANT]
    WF_STATUS,         -- WF Status [ICL_WF_STATUS]
    REF_OBJCAT,        -- Object Category [ICL_PARTOBJCAT]
    REF_OBJECT,        -- Number [ICL_OBJECT]
    REFTASK_SUBCLAIM,  -- Ref.Subclaim [IAM_REFTASK_SUBCL]
    REFTASK_ACTNO,     -- Ref. Number [IAM_REFTASK_ACTIVITYNO]
    REFTASK_CATEGORY,  -- Ref. Category [IAM_REFTASK_CAT]
    PARENT_SUBCLAIM,   -- Higher-Level Claim Subobject - Subclaim [IAM_PARENT_SUBCLAIM]
    PARENT_SUBOBJCAT,  -- Higher-Level Claim Subobject - Category [IAM_PARENT_SUBOBJCAT]
    PARENT_SUBOBJECT,  -- Higher-Level Claim Subobject - Object [IAM_PARENT_SUBOBJECT]
    WI_ID,             -- Work Item ID [SWW_WIID]
    TEXT_LANGU,        -- Language Text [ICL_TEXT_LANGU]
    XFORWARDED,        -- Boole [IAM_BOOLE_D]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, ACTNUMBER)
);

Learn More