ICLCLAIM

Transparent Table Application Table
103 Fields 11 CDS Views

Claim

ICLCLAIM is an SAP database table in S/4HANA. Claim. It contains 103 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
E_INS_ClaimServices view_entity from
E_InsuranceClaim view from EXTENSION Kundenerweiterung für ICLCLAIM
E_InsuranceClaim_2 view_entity from EXTENSION Insurance Claim - Extension
E_InsurClmClaimOverview view from EXTENSION Kundenerweiterung für I_InsurClmClaimOverview
I_InsuranceClaim view from BASIC Schaden-/Leistungsfall
I_InsuranceClaim_2 view_entity from BASIC Insurance Claim Details
I_InsuranceClaimAuthorization view from BASIC Berechtigungsfelder für Schadenfall
I_InsurClmHandlerAssignment view inner BASIC Sachbearbeiterzuordnung
I_InsurClmLossReportPayment view from BASIC Zahlungspositionen für Schadendreieck
I_InsurClmResponsibleRole view from BASIC Verantwortliche Rolle
I_InsurClmSubclmRoleBsdPerfrmr view inner BASIC Sachbearbeiterzuordnung

Fields (103)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
createdby ICL_CREATEDBY Created By
createtime ICL_CREATEUTC Created at
achangedby ICL_ACHANGEDBY Last Changed by
achangetime ICL_ACHANGETIME Last Changed At
exclaimnocat ICL_CLAIMNOCAT External No.Category
exclaimno ICL_CLAIMNO External Number
status ICL_CLSTATUS Status
statuschg ICL_STATUSCHG Changed on
sthandler ICL_STHANDLER ClmHandlngActve
stnoclaim ICL_STNOCLAIM No Claim Made
stclosed ICL_STCLOSED Closed
statreason ICL_FORMSET Status Reason
losstype ICL_LOSSTYPE Incident Type
claimtype ICL_CLTYPE Claim Type
cltypeg ICL_CLTYPEG Generation
cltypev ICL_CLTYPEV Clm Type Versn
lossevent ICL_LOSSEVENT CumulativeEvent
polprod ICL_POLPROD Policy Product
generat ICL_GENERAT Generation
version ICL_POLPRODV Version
lrenewal ICL_LRENEWAL Last Renewal
policy ICL_POLICY Contract
losscause ICL_LOSSCAUSE Cause
peril ICL_PERIL Peril
dateloss ICL_LOSSDATE Date of Loss
timeloss ICL_LOSSTIME Time
ltimezone ICL_LTIMEZONE Time Zone
xdateestim ICL_XLOSSDATE Date Estimated
datechanger ICL_DATECHANGER Reason f.Change
lossrepcompa ICL_LOSSREPCOMPA Repd to Insurer
lossrepagent ICL_LOSSREPAGENT Reptd to Agent
lossaddress ICL_LOSSADDRESS Loss Location
xauthrep ICL_XAUTHREP Reported
xsensitive ICL_CLAIMSENS Sensitive Claim
complex ICL_COMPLEX Complexity
juriscountry ICL_JURICOUNTRY C/R Juris.
jurisregion ICL_JURISREGION Jurisd. Region
assign_state ICL_ASSIGN_STATE Assgmt Status
ownertype ICL_OWNERTYPE CH Obj.Type
owner ICL_CLAIMOWNER Clm Hndlr ID
ownertype_grp ICL_OWNERTYPE2 CH Obj.Type
owner_grp ICL_CLAIMOWNER2 CH Group
xcumul ICL_XCUMUL Claim Assigned to an Aggregate
viewfault ICL_VIEWFAULTI Fault
viewfaultph ICL_VIEWFAULTPH PH View ofFault
tpno ICL_TPNO 3rd Party Count
xtpknown ICL_TPKNOWN 3rd party known
covered ICL_COVERED Compensable
authclm ICL_AUTHCLM AuthGroup (VIP)
xclaimb ICL_XCLAIMB EntryClaimB
xnonotif ICL_XNONOTIF Not Notif. Mode
xreserve ICL_XRESERVE Reserve Exists
bentree ICL_BENTREE Ben. Type Tree
bentreeg ICL_BENTREEG Generation
bentreev ICL_BENTREEV Version
wf_exec_time ICL_WF_EXECUTION_TIME Execution Time
wf_status ICL_WF_STATUS WF Status
xdummyclaim ICL_XDUMMYCLAIM Dummy Claim
verchngutc ICL_VERCHNGUTC Read Time
opendate ICL_OPENDATE Opened On
xwithout_product ICL_XWITHOUTPRODUCT_D Without Product
max_itemnr ICL_SCLITEM_NR_MAX Highest ClmItNo
assign_guid ICL_ASSIGN_GUID Link UUID
sif_status ICL_SIF_STATUS_D SIF Status
invstg_status ICL_INVSTG_MATCH_STATUS_D_PE Match Status
effective_dt ICL_EFFECTIVE_DT_D Validity Date
lossrep_dt ICL_LOSSREP_DT_D Date on Request
lumpsumoption ICL_LUMPSUMOPTION_D Option Exercisd
statpension ICL_STATPENSION_D Statut. Pension
withdrawam ICL_WITHDRAWAM_D Withdrawal Amt
withdrawcurr ICL_WITHDRAWCURR_D Currency
withdrawseq ICL_WITHDRAWSEQ_D Withdrawal Seq.
alternateben ICL_ALTERNATEBEN_D Alt.Ben.Values
generatenotif ICL_GENERATENOTIF_D Spec.Risk Notif
notifreason ICL_NOTIFREASON_D SpecRisk NotifR
autfollowup ICL_AUTFOLLOWUP_D Autom.Resubmssn
followup_dt ICL_FOLLOWUP_DT_D Resubmissn Date
processing_dt ICL_PROCESSING_DT_D Processing On
statusobjid J_OBJNR Object number
dunnlevel ICL_DUNNLEVEL_D Dunning Status
cleardate ICL_CLEARDATE_D Paid Up To
prembalanam ICL_PREMBALANAM_D Premium Balance
prembalanamcurr ICL_PREMBALANAMCURR_D Currency
withdrawtype ICL_WITHDRAWTYPE_D Withdrawal Type
react_dt ICL_REACT_DT_D Reactivation
gennotiftime ICL_GENERATENOTIFTIME_D Spec.Risk Mess.
ben_calc_fail ICL_BEN_CALC_FAIL_D Incorrect Benefit Calculation
polsystem ICL_POLSYSTEM_D Policy System
dummy_fnol DUMMY Dummy function in length 1
_dataaging DATA_TEMPERATURE Data Aging
dummy_iclvdm_claim_incl_eew_ps CFD_DUMMY Dummy
dummy_iclvdm_clinq_incl_eew_ps CFD_DUMMY Dummy
fnol_claimnr ICL_CLAIM Claim Number
archive_status TYP_ARCHIVE_STATUS Archiving Status
archive_flud TYP_ARCHIVE_FLUD Resubmission Date
rejection TYP_REJECTION Rejection Reason
dummy_field abap.char

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLCLAIM (
    CLIENT,                          -- Client [MANDT]
    ACTIVE,                          -- Active/Suspense [ICL_ACTIVE]
    CLAIM,                           -- Claim Number [ICL_CLAIM]
    CHANGETIME,                      -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,                       -- Changed By [ICL_CHANGEDBY]
    DELETED,                         -- Status [ICL_RECSTATUS]
    CREATEDBY,                       -- Created By [ICL_CREATEDBY]
    CREATETIME,                      -- Created at [ICL_CREATEUTC]
    ACHANGEDBY,                      -- Last Changed by [ICL_ACHANGEDBY]
    ACHANGETIME,                     -- Last Changed At [ICL_ACHANGETIME]
    EXCLAIMNOCAT,                    -- External No.Category [ICL_CLAIMNOCAT]
    EXCLAIMNO,                       -- External Number [ICL_CLAIMNO]
    STATUS,                          -- Status [ICL_CLSTATUS]
    STATUSCHG,                       -- Changed on [ICL_STATUSCHG]
    STHANDLER,                       -- ClmHandlngActve [ICL_STHANDLER]
    STNOCLAIM,                       -- No Claim Made [ICL_STNOCLAIM]
    STCLOSED,                        -- Closed [ICL_STCLOSED]
    STATREASON,                      -- Status Reason [ICL_FORMSET]
    LOSSTYPE,                        -- Incident Type [ICL_LOSSTYPE]
    CLAIMTYPE,                       -- Claim Type [ICL_CLTYPE]
    CLTYPEG,                         -- Generation [ICL_CLTYPEG]
    CLTYPEV,                         -- Clm Type Versn [ICL_CLTYPEV]
    LOSSEVENT,                       -- CumulativeEvent [ICL_LOSSEVENT]
    POLPROD,                         -- Policy Product [ICL_POLPROD]
    GENERAT,                         -- Generation [ICL_GENERAT]
    VERSION,                         -- Version [ICL_POLPRODV]
    LRENEWAL,                        -- Last Renewal [ICL_LRENEWAL]
    POLICY,                          -- Contract [ICL_POLICY]
    LOSSCAUSE,                       -- Cause [ICL_LOSSCAUSE]
    PERIL,                           -- Peril [ICL_PERIL]
    DATELOSS,                        -- Date of Loss [ICL_LOSSDATE]
    TIMELOSS,                        -- Time [ICL_LOSSTIME]
    LTIMEZONE,                       -- Time Zone [ICL_LTIMEZONE]
    XDATEESTIM,                      -- Date Estimated [ICL_XLOSSDATE]
    DATECHANGER,                     -- Reason f.Change [ICL_DATECHANGER]
    LOSSREPCOMPA,                    -- Repd to Insurer [ICL_LOSSREPCOMPA]
    LOSSREPAGENT,                    -- Reptd to Agent [ICL_LOSSREPAGENT]
    LOSSADDRESS,                     -- Loss Location [ICL_LOSSADDRESS]
    XAUTHREP,                        -- Reported [ICL_XAUTHREP]
    XSENSITIVE,                      -- Sensitive Claim [ICL_CLAIMSENS]
    COMPLEX,                         -- Complexity [ICL_COMPLEX]
    JURISCOUNTRY,                    -- C/R Juris. [ICL_JURICOUNTRY]
    JURISREGION,                     -- Jurisd. Region [ICL_JURISREGION]
    ASSIGN_STATE,                    -- Assgmt Status [ICL_ASSIGN_STATE]
    OWNERTYPE,                       -- CH Obj.Type [ICL_OWNERTYPE]
    OWNER,                           -- Clm Hndlr ID [ICL_CLAIMOWNER]
    OWNERTYPE_GRP,                   -- CH Obj.Type [ICL_OWNERTYPE2]
    OWNER_GRP,                       -- CH Group [ICL_CLAIMOWNER2]
    XCUMUL,                          -- Claim Assigned to an Aggregate [ICL_XCUMUL]
    VIEWFAULT,                       -- Fault [ICL_VIEWFAULTI]
    VIEWFAULTPH,                     -- PH View ofFault [ICL_VIEWFAULTPH]
    TPNO,                            -- 3rd Party Count [ICL_TPNO]
    XTPKNOWN,                        -- 3rd party known [ICL_TPKNOWN]
    COVERED,                         -- Compensable [ICL_COVERED]
    AUTHCLM,                         -- AuthGroup (VIP) [ICL_AUTHCLM]
    XCLAIMB,                         -- EntryClaimB [ICL_XCLAIMB]
    XNONOTIF,                        -- Not Notif. Mode [ICL_XNONOTIF]
    XRESERVE,                        -- Reserve Exists [ICL_XRESERVE]
    BENTREE,                         -- Ben. Type Tree [ICL_BENTREE]
    BENTREEG,                        -- Generation [ICL_BENTREEG]
    BENTREEV,                        -- Version [ICL_BENTREEV]
    WF_EXEC_TIME,                    -- Execution Time [ICL_WF_EXECUTION_TIME]
    WF_STATUS,                       -- WF Status [ICL_WF_STATUS]
    XDUMMYCLAIM,                     -- Dummy Claim [ICL_XDUMMYCLAIM]
    VERCHNGUTC,                      -- Read Time [ICL_VERCHNGUTC]
    OPENDATE,                        -- Opened On [ICL_OPENDATE]
    XWITHOUT_PRODUCT,                -- Without Product [ICL_XWITHOUTPRODUCT_D]
    MAX_ITEMNR,                      -- Highest ClmItNo [ICL_SCLITEM_NR_MAX]
    ASSIGN_GUID,                     -- Link UUID [ICL_ASSIGN_GUID]
    SIF_STATUS,                      -- SIF Status [ICL_SIF_STATUS_D]
    INVSTG_STATUS,                   -- Match Status [ICL_INVSTG_MATCH_STATUS_D_PE]
    EFFECTIVE_DT,                    -- Validity Date [ICL_EFFECTIVE_DT_D]
    LOSSREP_DT,                      -- Date on Request [ICL_LOSSREP_DT_D]
    LUMPSUMOPTION,                   -- Option Exercisd [ICL_LUMPSUMOPTION_D]
    STATPENSION,                     -- Statut. Pension [ICL_STATPENSION_D]
    WITHDRAWAM,                      -- Withdrawal Amt [ICL_WITHDRAWAM_D]
    WITHDRAWCURR,                    -- Currency [ICL_WITHDRAWCURR_D]
    WITHDRAWSEQ,                     -- Withdrawal Seq. [ICL_WITHDRAWSEQ_D]
    ALTERNATEBEN,                    -- Alt.Ben.Values [ICL_ALTERNATEBEN_D]
    GENERATENOTIF,                   -- Spec.Risk Notif [ICL_GENERATENOTIF_D]
    NOTIFREASON,                     -- SpecRisk NotifR [ICL_NOTIFREASON_D]
    AUTFOLLOWUP,                     -- Autom.Resubmssn [ICL_AUTFOLLOWUP_D]
    FOLLOWUP_DT,                     -- Resubmissn Date [ICL_FOLLOWUP_DT_D]
    PROCESSING_DT,                   -- Processing On [ICL_PROCESSING_DT_D]
    STATUSOBJID,                     -- Object number [J_OBJNR]
    DUNNLEVEL,                       -- Dunning Status [ICL_DUNNLEVEL_D]
    CLEARDATE,                       -- Paid Up To [ICL_CLEARDATE_D]
    PREMBALANAM,                     -- Premium Balance [ICL_PREMBALANAM_D]
    PREMBALANAMCURR,                 -- Currency [ICL_PREMBALANAMCURR_D]
    WITHDRAWTYPE,                    -- Withdrawal Type [ICL_WITHDRAWTYPE_D]
    REACT_DT,                        -- Reactivation [ICL_REACT_DT_D]
    GENNOTIFTIME,                    -- Spec.Risk Mess. [ICL_GENERATENOTIFTIME_D]
    BEN_CALC_FAIL,                   -- Incorrect Benefit Calculation [ICL_BEN_CALC_FAIL_D]
    POLSYSTEM,                       -- Policy System [ICL_POLSYSTEM_D]
    DUMMY_FNOL,                      -- Dummy function in length 1 [DUMMY]
    _DATAAGING,                      -- Data Aging [DATA_TEMPERATURE]
    DUMMY_ICLVDM_CLAIM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_ICLVDM_CLINQ_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    FNOL_CLAIMNR,                    -- Claim Number [ICL_CLAIM]
    ARCHIVE_STATUS,                  -- Archiving Status [TYP_ARCHIVE_STATUS]
    ARCHIVE_FLUD,                    -- Resubmission Date [TYP_ARCHIVE_FLUD]
    REJECTION,                       -- Rejection Reason [TYP_REJECTION]
    DUMMY_FIELD,                     -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM)
);

Learn More