ICLCLAIMDRAFT1

Transparent Table Application Table
104 Fields 1 CDS Views

Draft table for entity R_INS_CLAIMSERVICESTP

ICLCLAIMDRAFT1 is an SAP database table in S/4HANA. Draft table for entity R_INS_CLAIMSERVICESTP. It contains 104 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_INS_ClaimServicesDraft view_entity from BASIC Insurance Claim - Draft

Fields (104)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY insurclmactive ICL_ACTIVE Active/Suspense
KEY insuranceclaim ICL_CLAIM Claim Number
KEY draftuuid SDRAFT_UUID Draft Document ID
changedondatetime ICL_ACHANGETIME_FIORI Last Changed At
lastchangedbyuser ICL_CHANGEDBY Changed By
insurclmdatabaselinestatus ICL_RECSTATUS Status
createdbyuser ICL_CREATEDBY Created By
creationdatetime ICL_CREATEUTC_FIORI Created At
insurclmwholeclmchgdby ICL_ACHANGEDBY Last Changed by
insurclmwholeclmchgdtetme ICL_ACHANGETIME_FIORI Last Changed At
insurclmexternalnumbercategory ICL_CLAIMNOCAT External No.Category
insuranceclaimexternalnumber ICL_CLAIMNO External Number
insurclmlifecycsts ICL_CLSTATUS Status
insurclmstschgdondtetime ICL_ACHANGETIME_FIORI Last Changed At
insuranceclaimisstatushandler ICL_STHANDLER ClmHandlngActve
insuranceclaimisnoclaimmade ICL_STNOCLAIM No Claim Made
insuranceclaimisstatusclosed ICL_STCLOSED Closed
insurclmstatreason ICL_FORMSET Status Reason
insurclmincdnttype ICL_LOSSTYPE Incident Type
insurclmtype ICL_CLTYPE Claim Type
insurclmtypegeneration ICL_CLTYPEG Generation
insurclmtypevers ICL_CLTYPEV Clm Type Versn
insuranceclaimbundlelossevent ICL_LOSSEVENT CumulativeEvent
insurclmpolicyproduct ICL_POLPROD Policy Product
insurclmpolicyprodgeneration ICL_GENERAT Generation
insurclmpolicyproductversion ICL_POLPRODV Version
insurclmcontractlastrenewal ICL_LRENEWAL_FIORI Last Renewal
insurancecontract ICL_POLICY Contract
insurclmcauseofloss ICL_LOSSCAUSE Cause
insuranceclaimreinsuranceperil ICL_PERIL Peril
insurclmdateofloss ICL_LOSSDATE Date of Loss
insurclmtimeofloss ICL_LOSSTIME Time
insurclmtimezoneofloss ICL_LTIMEZONE Time Zone
insuranceclaimisdateestimate ICL_XLOSSDATE Date Estimated
insuranceclaimdatechangereason ICL_DATECHANGER Reason f.Change
insurclmreporteddate ICL_LOSSREPCOMPA Repd to Insurer
insurclmagentreporteddate ICL_LOSSREPAGENT Reptd to Agent
insurclmlosslocaddressid ICL_LOSSADDRESS Loss Location
insurclmisrptdtoauth ICL_XAUTHREP Reported
insurclmsensitiveclaim ICL_CLAIMSENS Sensitive Claim
insurclmcomplexity ICL_COMPLEX Complexity
insurclmjurisdictioncountry ICL_JURICOUNTRY C/R Juris.
insurclmjurisdictionregion ICL_JURISREGION Jurisd. Region
insurclmactyassgmtsts ICL_ASSIGN_STATE Assgmt Status
insuranceclaimownertype ICL_OWNERTYPE CH Obj.Type
insuranceclaimowner ICL_CLAIMOWNER Clm Hndlr ID
insuranceclaimownertypegroup ICL_OWNERTYPE2 CH Obj.Type
insuranceclaimownergroup ICL_CLAIMOWNER2 CH Group
insuranceclaimiscumulative ICL_XCUMUL Claim Assigned to an Aggregate
insuranceclaimviewfault ICL_VIEWFAULTI Fault
insurclmvwfaultplcyhldr ICL_VIEWFAULTPH PH View ofFault
insurclmisthirdpartyknown ICL_TPKNOWN 3rd party known
insurclmcovered ICL_COVERED Compensable
insurclmauthzngrp ICL_AUTHCLM AuthGroup (VIP)
insurclmisentrinpaytamtauthzns ICL_XCLAIMB EntryClaimB
insuranceclaimisnonotif ICL_XNONOTIF Not Notif. Mode
insuranceclaimisreserve ICL_XRESERVE Reserve Exists
insurclmbenefittypetree ICL_BENTREE Ben. Type Tree
insurclmbnfttypetreegeneration ICL_BENTREEG Generation
insurclmbnfttypetreeversion ICL_BENTREEV Version
insurclmwrkflwexecdtetme ICL_LRENEWAL_FIORI Last Renewal
insurclmworkflowstatus ICL_WF_STATUS WF Status
insurclmisdummyclaim ICL_XDUMMYCLAIM Dummy Claim
insurclmversionchangetime ICL_VERCHNGUTC_FIORI Read Time
insurclmopendate ICL_OPENDATE Opened On
insurclmiswithoutproduct ICL_XWITHOUTPRODUCT_D Without Product
insuranceclaimmaxitemnumber ICL_SCLITEM_NR_MAX Highest ClmItNo
insurclmassignuuid ICL_ASSIGN_GUID Link UUID
insurclmsecondinjuryfundstatus ICL_SIF_STATUS_D SIF Status
insurclmincdntinvstgnsts ICL_INVSTG_MATCH_STATUS_D_PE Match Status
insuranceclaimeffectivedate ICL_EFFECTIVE_DT_D Validity Date
insuranceclaimlossrepdate ICL_LOSSREP_DT_D Date on Request
insuranceclaimislumpsumoption ICL_LUMPSUMOPTION_D Option Exercisd
insurclmstatutorypensiontype ICL_STATPENSION_D Statut. Pension
insurclmwithdrawamt ICL_WITHDRAWAM_D Withdrawal Amt
insurclmwithdrawcrcy ICL_WITHDRAWCURR_D Currency
insurclmwthdrwlsqnc ICL_WITHDRAWSEQ_D Withdrawal Seq.
insuranceclaimalternatebenefit ICL_ALTERNATEBEN_D Alt.Ben.Values
insuranceclaimspecialrisknotif ICL_GENERATENOTIF_D Spec.Risk Notif
insuranceclaimnotifreason ICL_NOTIFREASON_D SpecRisk NotifR
insuranceclaimautoresubmission ICL_AUTFOLLOWUP_D Autom.Resubmssn
insuranceclaimfollowupdate ICL_FOLLOWUP_DT_D Resubmissn Date
insuranceclaimprocessingdate ICL_PROCESSING_DT_D Processing On
insuranceclaimstatusobjectnmbr J_OBJNR Object number
insuranceclaimdunningstatus ICL_DUNNLEVEL_D Dunning Status
insuranceclaimcleardate ICL_CLEARDATE_D Paid Up To
insurclmpremiumbalanceamount ICL_PREMBALANAM_D Premium Balance
insurclmpremiumbalancecurrency ICL_PREMBALANAMCURR_D Currency
insuranceclaimwithdrawaltype ICL_WITHDRAWTYPE_D Withdrawal Type
insuranceclaimreactdate ICL_REACT_DT_D Reactivation
insurclmspecialriskmsgdatetime ICL_LRENEWAL_FIORI Last Renewal
insurclmincrrtbnftcalcdatetime ICL_LRENEWAL_FIORI Last Renewal
insuranceclaimpolicysystem ICL_POLSYSTEM_D Policy System
insuranceclaimdraftidentifier ICL_CLAIM Claim Number
insurclmarchivingstatus TYP_ARCHIVE_STATUS Archiving Status
insurclmarchresubmsndte TYP_ARCHIVE_FLUD Resubmission Date
insurclmarchrjcnrsn TYP_REJECTION Rejection Reason
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_INS_CLAIMSERVICESTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLCLAIMDRAFT1 (
    MANDT,                           -- Client [MANDT]
    INSURCLMACTIVE,                  -- Active/Suspense [ICL_ACTIVE]
    INSURANCECLAIM,                  -- Claim Number [ICL_CLAIM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    CHANGEDONDATETIME,               -- Last Changed At [ICL_ACHANGETIME_FIORI]
    LASTCHANGEDBYUSER,               -- Changed By [ICL_CHANGEDBY]
    INSURCLMDATABASELINESTATUS,      -- Status [ICL_RECSTATUS]
    CREATEDBYUSER,                   -- Created By [ICL_CREATEDBY]
    CREATIONDATETIME,                -- Created At [ICL_CREATEUTC_FIORI]
    INSURCLMWHOLECLMCHGDBY,          -- Last Changed by [ICL_ACHANGEDBY]
    INSURCLMWHOLECLMCHGDTETME,       -- Last Changed At [ICL_ACHANGETIME_FIORI]
    INSURCLMEXTERNALNUMBERCATEGORY,  -- External No.Category [ICL_CLAIMNOCAT]
    INSURANCECLAIMEXTERNALNUMBER,    -- External Number [ICL_CLAIMNO]
    INSURCLMLIFECYCSTS,              -- Status [ICL_CLSTATUS]
    INSURCLMSTSCHGDONDTETIME,        -- Last Changed At [ICL_ACHANGETIME_FIORI]
    INSURANCECLAIMISSTATUSHANDLER,   -- ClmHandlngActve [ICL_STHANDLER]
    INSURANCECLAIMISNOCLAIMMADE,     -- No Claim Made [ICL_STNOCLAIM]
    INSURANCECLAIMISSTATUSCLOSED,    -- Closed [ICL_STCLOSED]
    INSURCLMSTATREASON,              -- Status Reason [ICL_FORMSET]
    INSURCLMINCDNTTYPE,              -- Incident Type [ICL_LOSSTYPE]
    INSURCLMTYPE,                    -- Claim Type [ICL_CLTYPE]
    INSURCLMTYPEGENERATION,          -- Generation [ICL_CLTYPEG]
    INSURCLMTYPEVERS,                -- Clm Type Versn [ICL_CLTYPEV]
    INSURANCECLAIMBUNDLELOSSEVENT,   -- CumulativeEvent [ICL_LOSSEVENT]
    INSURCLMPOLICYPRODUCT,           -- Policy Product [ICL_POLPROD]
    INSURCLMPOLICYPRODGENERATION,    -- Generation [ICL_GENERAT]
    INSURCLMPOLICYPRODUCTVERSION,    -- Version [ICL_POLPRODV]
    INSURCLMCONTRACTLASTRENEWAL,     -- Last Renewal [ICL_LRENEWAL_FIORI]
    INSURANCECONTRACT,               -- Contract [ICL_POLICY]
    INSURCLMCAUSEOFLOSS,             -- Cause [ICL_LOSSCAUSE]
    INSURANCECLAIMREINSURANCEPERIL,  -- Peril [ICL_PERIL]
    INSURCLMDATEOFLOSS,              -- Date of Loss [ICL_LOSSDATE]
    INSURCLMTIMEOFLOSS,              -- Time [ICL_LOSSTIME]
    INSURCLMTIMEZONEOFLOSS,          -- Time Zone [ICL_LTIMEZONE]
    INSURANCECLAIMISDATEESTIMATE,    -- Date Estimated [ICL_XLOSSDATE]
    INSURANCECLAIMDATECHANGEREASON,  -- Reason f.Change [ICL_DATECHANGER]
    INSURCLMREPORTEDDATE,            -- Repd to Insurer [ICL_LOSSREPCOMPA]
    INSURCLMAGENTREPORTEDDATE,       -- Reptd to Agent [ICL_LOSSREPAGENT]
    INSURCLMLOSSLOCADDRESSID,        -- Loss Location [ICL_LOSSADDRESS]
    INSURCLMISRPTDTOAUTH,            -- Reported [ICL_XAUTHREP]
    INSURCLMSENSITIVECLAIM,          -- Sensitive Claim [ICL_CLAIMSENS]
    INSURCLMCOMPLEXITY,              -- Complexity [ICL_COMPLEX]
    INSURCLMJURISDICTIONCOUNTRY,     -- C/R Juris. [ICL_JURICOUNTRY]
    INSURCLMJURISDICTIONREGION,      -- Jurisd. Region [ICL_JURISREGION]
    INSURCLMACTYASSGMTSTS,           -- Assgmt Status [ICL_ASSIGN_STATE]
    INSURANCECLAIMOWNERTYPE,         -- CH Obj.Type [ICL_OWNERTYPE]
    INSURANCECLAIMOWNER,             -- Clm Hndlr ID [ICL_CLAIMOWNER]
    INSURANCECLAIMOWNERTYPEGROUP,    -- CH Obj.Type [ICL_OWNERTYPE2]
    INSURANCECLAIMOWNERGROUP,        -- CH Group [ICL_CLAIMOWNER2]
    INSURANCECLAIMISCUMULATIVE,      -- Claim Assigned to an Aggregate [ICL_XCUMUL]
    INSURANCECLAIMVIEWFAULT,         -- Fault [ICL_VIEWFAULTI]
    INSURCLMVWFAULTPLCYHLDR,         -- PH View ofFault [ICL_VIEWFAULTPH]
    INSURCLMISTHIRDPARTYKNOWN,       -- 3rd party known [ICL_TPKNOWN]
    INSURCLMCOVERED,                 -- Compensable [ICL_COVERED]
    INSURCLMAUTHZNGRP,               -- AuthGroup (VIP) [ICL_AUTHCLM]
    INSURCLMISENTRINPAYTAMTAUTHZNS,  -- EntryClaimB [ICL_XCLAIMB]
    INSURANCECLAIMISNONOTIF,         -- Not Notif. Mode [ICL_XNONOTIF]
    INSURANCECLAIMISRESERVE,         -- Reserve Exists [ICL_XRESERVE]
    INSURCLMBENEFITTYPETREE,         -- Ben. Type Tree [ICL_BENTREE]
    INSURCLMBNFTTYPETREEGENERATION,  -- Generation [ICL_BENTREEG]
    INSURCLMBNFTTYPETREEVERSION,     -- Version [ICL_BENTREEV]
    INSURCLMWRKFLWEXECDTETME,        -- Last Renewal [ICL_LRENEWAL_FIORI]
    INSURCLMWORKFLOWSTATUS,          -- WF Status [ICL_WF_STATUS]
    INSURCLMISDUMMYCLAIM,            -- Dummy Claim [ICL_XDUMMYCLAIM]
    INSURCLMVERSIONCHANGETIME,       -- Read Time [ICL_VERCHNGUTC_FIORI]
    INSURCLMOPENDATE,                -- Opened On [ICL_OPENDATE]
    INSURCLMISWITHOUTPRODUCT,        -- Without Product [ICL_XWITHOUTPRODUCT_D]
    INSURANCECLAIMMAXITEMNUMBER,     -- Highest ClmItNo [ICL_SCLITEM_NR_MAX]
    INSURCLMASSIGNUUID,              -- Link UUID [ICL_ASSIGN_GUID]
    INSURCLMSECONDINJURYFUNDSTATUS,  -- SIF Status [ICL_SIF_STATUS_D]
    INSURCLMINCDNTINVSTGNSTS,        -- Match Status [ICL_INVSTG_MATCH_STATUS_D_PE]
    INSURANCECLAIMEFFECTIVEDATE,     -- Validity Date [ICL_EFFECTIVE_DT_D]
    INSURANCECLAIMLOSSREPDATE,       -- Date on Request [ICL_LOSSREP_DT_D]
    INSURANCECLAIMISLUMPSUMOPTION,   -- Option Exercisd [ICL_LUMPSUMOPTION_D]
    INSURCLMSTATUTORYPENSIONTYPE,    -- Statut. Pension [ICL_STATPENSION_D]
    INSURCLMWITHDRAWAMT,             -- Withdrawal Amt [ICL_WITHDRAWAM_D]
    INSURCLMWITHDRAWCRCY,            -- Currency [ICL_WITHDRAWCURR_D]
    INSURCLMWTHDRWLSQNC,             -- Withdrawal Seq. [ICL_WITHDRAWSEQ_D]
    INSURANCECLAIMALTERNATEBENEFIT,  -- Alt.Ben.Values [ICL_ALTERNATEBEN_D]
    INSURANCECLAIMSPECIALRISKNOTIF,  -- Spec.Risk Notif [ICL_GENERATENOTIF_D]
    INSURANCECLAIMNOTIFREASON,       -- SpecRisk NotifR [ICL_NOTIFREASON_D]
    INSURANCECLAIMAUTORESUBMISSION,  -- Autom.Resubmssn [ICL_AUTFOLLOWUP_D]
    INSURANCECLAIMFOLLOWUPDATE,      -- Resubmissn Date [ICL_FOLLOWUP_DT_D]
    INSURANCECLAIMPROCESSINGDATE,    -- Processing On [ICL_PROCESSING_DT_D]
    INSURANCECLAIMSTATUSOBJECTNMBR,  -- Object number [J_OBJNR]
    INSURANCECLAIMDUNNINGSTATUS,     -- Dunning Status [ICL_DUNNLEVEL_D]
    INSURANCECLAIMCLEARDATE,         -- Paid Up To [ICL_CLEARDATE_D]
    INSURCLMPREMIUMBALANCEAMOUNT,    -- Premium Balance [ICL_PREMBALANAM_D]
    INSURCLMPREMIUMBALANCECURRENCY,  -- Currency [ICL_PREMBALANAMCURR_D]
    INSURANCECLAIMWITHDRAWALTYPE,    -- Withdrawal Type [ICL_WITHDRAWTYPE_D]
    INSURANCECLAIMREACTDATE,         -- Reactivation [ICL_REACT_DT_D]
    INSURCLMSPECIALRISKMSGDATETIME,  -- Last Renewal [ICL_LRENEWAL_FIORI]
    INSURCLMINCRRTBNFTCALCDATETIME,  -- Last Renewal [ICL_LRENEWAL_FIORI]
    INSURANCECLAIMPOLICYSYSTEM,      -- Policy System [ICL_POLSYSTEM_D]
    INSURANCECLAIMDRAFTIDENTIFIER,   -- Claim Number [ICL_CLAIM]
    INSURCLMARCHIVINGSTATUS,         -- Archiving Status [TYP_ARCHIVE_STATUS]
    INSURCLMARCHRESUBMSNDTE,         -- Resubmission Date [TYP_ARCHIVE_FLUD]
    INSURCLMARCHRJCNRSN,             -- Rejection Reason [TYP_REJECTION]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, INSURCLMACTIVE, INSURANCECLAIM, DRAFTUUID)
);

Learn More