ICLCCEVENT

Transparent Table Application Table
47 Fields 2 CDS Views

Claim Bundle

ICLCCEVENT is an SAP database table in S/4HANA. Claim Bundle. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsuranceClaimBundle view_entity from EXTENSION Insurance Claim Bundle - Extension
I_ClaimBundle view from BASIC Fallbündel

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY ccevent ICL_CCEVENT Claim Bundle
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
createdby ICL_CREATEDBY Created By
createtime ICL_CREATEUTC Created at
cctype ICL_CCEVENTCAT Clm Bundle Type
subtype ICL_CCEVENTTY ClmBndleSubType
curr ICL_CCEVENTCUR Currency
limit ICL_CCEVENTLIM Reserve
limite ICL_CCEVENTLIME Expense Reserve
code ICL_CCEVENTCODE External Name
name ICL_CCEVENTNAME Name
rangefrom ICL_CCEVENTFROM Date From
rangeto ICL_CCEVENTTO Date To
hotline ICL_CCEVENTTEL Phone
locatype ICL_CCEVENTLOCA Location Type
status ICLE_BUNDLE_STATUS_D Status
bundlecause ICL_BUNDLECAUSE Bundle Reason
owner ICL_BUNDLEOWNER Claim Handler
invoiceref_bulk ICL_INVOICEREF_BULK Ext CollInvNo.
externalref_bulk ICL_EXTERNALREF_BULK Ext.Coll.Ref.
issuedate ICL_ISSUEDATE_INVBULK Invoice Date
amount_total ICL_AMOUNT_BULKINV_TOTAL NetTotal (CI)
paymentlevel ICL_PAYMENTLEVEL Payment Level
datasource ICL_DATASOURCE Data Origin
receivedate ICL_RECEIVEDATE Date Received
clminprocess ICL_CLMSTATUS_INPROCESS In Process
released ICL_STATUS_RELEASED Released
cancel ICL_STATUS_CANCEL Cancelled
inprocess ICL_STATUS_INPROCESS In Process
clminproc_cntr ICL_CLMSTATUS_INPROCESS_CNTR Open Claims
sthandler ICLE_STHANDLER Procssng Active
wf_status ICL_WF_STATUS WF Status
ccsbrbndl ICL_CCSBRBNDL Coll.Subro/Rcvr
ccsbrtype ICL_CCSBRTYPE SubroClaim Type
chreasonsbr ICL_CHREASONSBR Change Reason
billingdate ICL_BILLINGDATE Billing Date
resubdate ICL_RESUBDATE Resubmission
sbrnotifdate ICL_SBRNOTIFDATE SubroClm RptdOn
achangedby ICL_ACHANGEDBY Last Changed by
achangetime ICL_ACHANGETIME Last Changed At
archive_status TYP_ARCHIVE_STATUS Archiving Status
archive_flud TYP_ARCHIVE_FLUD Resubmission Date
rejection TYP_REJECTION Rejection Reason

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.

-- Claim Bundle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLCCEVENT (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CCEVENT,           -- Claim Bundle [ICL_CCEVENT]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    CREATEDBY,         -- Created By [ICL_CREATEDBY]
    CREATETIME,        -- Created at [ICL_CREATEUTC]
    CCTYPE,            -- Clm Bundle Type [ICL_CCEVENTCAT]
    SUBTYPE,           -- ClmBndleSubType [ICL_CCEVENTTY]
    CURR,              -- Currency [ICL_CCEVENTCUR]
    LIMIT,             -- Reserve [ICL_CCEVENTLIM]
    LIMITE,            -- Expense Reserve [ICL_CCEVENTLIME]
    CODE,              -- External Name [ICL_CCEVENTCODE]
    NAME,              -- Name [ICL_CCEVENTNAME]
    RANGEFROM,         -- Date From [ICL_CCEVENTFROM]
    RANGETO,           -- Date To [ICL_CCEVENTTO]
    HOTLINE,           -- Phone [ICL_CCEVENTTEL]
    LOCATYPE,          -- Location Type [ICL_CCEVENTLOCA]
    STATUS,            -- Status [ICLE_BUNDLE_STATUS_D]
    BUNDLECAUSE,       -- Bundle Reason [ICL_BUNDLECAUSE]
    OWNER,             -- Claim Handler [ICL_BUNDLEOWNER]
    INVOICEREF_BULK,   -- Ext CollInvNo. [ICL_INVOICEREF_BULK]
    EXTERNALREF_BULK,  -- Ext.Coll.Ref. [ICL_EXTERNALREF_BULK]
    ISSUEDATE,         -- Invoice Date [ICL_ISSUEDATE_INVBULK]
    AMOUNT_TOTAL,      -- NetTotal (CI) [ICL_AMOUNT_BULKINV_TOTAL]
    PAYMENTLEVEL,      -- Payment Level [ICL_PAYMENTLEVEL]
    DATASOURCE,        -- Data Origin [ICL_DATASOURCE]
    RECEIVEDATE,       -- Date Received [ICL_RECEIVEDATE]
    CLMINPROCESS,      -- In Process [ICL_CLMSTATUS_INPROCESS]
    RELEASED,          -- Released [ICL_STATUS_RELEASED]
    CANCEL,            -- Cancelled [ICL_STATUS_CANCEL]
    INPROCESS,         -- In Process [ICL_STATUS_INPROCESS]
    CLMINPROC_CNTR,    -- Open Claims [ICL_CLMSTATUS_INPROCESS_CNTR]
    STHANDLER,         -- Procssng Active [ICLE_STHANDLER]
    WF_STATUS,         -- WF Status [ICL_WF_STATUS]
    CCSBRBNDL,         -- Coll.Subro/Rcvr [ICL_CCSBRBNDL]
    CCSBRTYPE,         -- SubroClaim Type [ICL_CCSBRTYPE]
    CHREASONSBR,       -- Change Reason [ICL_CHREASONSBR]
    BILLINGDATE,       -- Billing Date [ICL_BILLINGDATE]
    RESUBDATE,         -- Resubmission [ICL_RESUBDATE]
    SBRNOTIFDATE,      -- SubroClm RptdOn [ICL_SBRNOTIFDATE]
    ACHANGEDBY,        -- Last Changed by [ICL_ACHANGEDBY]
    ACHANGETIME,       -- Last Changed At [ICL_ACHANGETIME]
    ARCHIVE_STATUS,    -- Archiving Status [TYP_ARCHIVE_STATUS]
    ARCHIVE_FLUD,      -- Resubmission Date [TYP_ARCHIVE_FLUD]
    REJECTION,         -- Rejection Reason [TYP_REJECTION]
    PRIMARY KEY (CLIENT, ACTIVE, CCEVENT)
);

Learn More