ICLEACTIVITY

Transparent Table Application Table
41 Fields 1 CDS Views

Tasks in Claim Bundle

ICLEACTIVITY is an SAP database table in S/4HANA. Tasks in Claim Bundle. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmBundleTasks view from BASIC Aufgaben im Fallbündel

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY ccevent ICL_CCEVENT Claim Bundle
KEY actnumber ICLE_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 ICLE_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 ICLE_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
subactivityn ICL_SUBACTIVITYN Activity
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
xsystem_activity IAM_XSYSTEM_ACTIVITY System Activity
wf_status ICL_WF_STATUS WF Status
not_wf_relevant ICLE_NOT_WF_RELEVANT WF-Relevant
wi_id SWW_WIID Work Item ID
manual_task_only IAM_MANUAL_TASK_ONLY Only Manl Task

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 Bundle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLEACTIVITY (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CCEVENT,           -- Claim Bundle [ICL_CCEVENT]
    ACTNUMBER,         -- No. [ICLE_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 [ICLE_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 [ICLE_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]
    SUBACTIVITYN,      -- Activity [ICL_SUBACTIVITYN]
    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]
    XSYSTEM_ACTIVITY,  -- System Activity [IAM_XSYSTEM_ACTIVITY]
    WF_STATUS,         -- WF Status [ICL_WF_STATUS]
    NOT_WF_RELEVANT,   -- WF-Relevant [ICLE_NOT_WF_RELEVANT]
    WI_ID,             -- Work Item ID [SWW_WIID]
    MANUAL_TASK_ONLY,  -- Only Manl Task [IAM_MANUAL_TASK_ONLY]
    PRIMARY KEY (CLIENT, ACTIVE, CCEVENT, ACTNUMBER)
);

Learn More