ICLREF

Transparent Table Application Table
17 Fields 2 CDS Views

Coverage Referral in Claim

ICLREF is an SAP database table in S/4HANA. Coverage Referral in Claim. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmCoverageReferral view_entity from EXTENSION Claim Coverage Ref - Extension
I_InsurClmCoverageReferral view from BASIC Deckungsbedenken bei Fall

Fields (17)

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 item ICL_SCLITEM Claim Item
KEY refno ICL_REFNO Number
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
referral ICL_REFERRAL Cov. Referral
text ICL_REFT Cov. Referral
xmanual ICL_REFNO01 Manually
subobjcat ICL_RSUBOBJCAT Object Category
subobject ICL_RSUBOBJECT Triggering obj.
rejreas ICL_REJREAS OverrulingReasn
rejcom ICL_REJREASC Reason
text_langu ICL_REFL_TEXT_LANGU Language Text

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.

-- Coverage Referral in Claim
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLREF (
    CLIENT,      -- Client [MANDT]
    ACTIVE,      -- Active/Suspense [ICL_ACTIVE]
    CLAIM,       -- Claim Number [ICL_CLAIM]
    SUBCLAIM,    -- Subclaim [ICL_SUBCL]
    ITEM,        -- Claim Item [ICL_SCLITEM]
    REFNO,       -- Number [ICL_REFNO]
    CHANGETIME,  -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,   -- Changed By [ICL_CHANGEDBY]
    DELETED,     -- Status [ICL_RECSTATUS]
    REFERRAL,    -- Cov. Referral [ICL_REFERRAL]
    TEXT,        -- Cov. Referral [ICL_REFT]
    XMANUAL,     -- Manually [ICL_REFNO01]
    SUBOBJCAT,   -- Object Category [ICL_RSUBOBJCAT]
    SUBOBJECT,   -- Triggering obj. [ICL_RSUBOBJECT]
    REJREAS,     -- OverrulingReasn [ICL_REJREAS]
    REJCOM,      -- Reason [ICL_REJREASC]
    TEXT_LANGU,  -- Language Text [ICL_REFL_TEXT_LANGU]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, ITEM, REFNO)
);

Learn More