ICLPOL

Transparent Table Application Table
48 Fields 2 CDS Views

Policy Snapshot

ICLPOL is an SAP database table in S/4HANA. Policy Snapshot. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmPolicySnapshot view_entity from EXTENSION Claim Policy Snapshot - Extension
I_InsurClmPolicySnapshot view from BASIC Vertragsspiegel

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM1 Policy Snapshot
KEY polvnr ICL_POLVCNTR Contrct Counter
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
importstatus ICL_POLIMPSTAT Import Status
validdata ICL_POLVALIDDATA Data Status
manchange ICL_POLMANCHNG Chngd Manually
validfrom ICL_POL01 Vers.Valid From
validto ICL_POL02 Vers.Valid To
srcchange ICL_POL03 Changed On
issued ICL_ISSUED Issued On
inception ICL_INCEPTION Inception
expiry ICL_EXPIRY End
curr ICL_POLB01 Currency
juriscountry ICL_JURICOUNTRY C/R Juris.
jurisregion ICL_JURISREGION Jurisd. Region
ncbonus ICL_NCBONUS ClaimFree Disc.
distchan ICL_DISTCHAN Distr. Channel
policy ICL_POLICY Contract
polprod ICL_POLPROD Policy Product
lrenewal ICL_LRENEWAL Last Renewal
polobj_cd ICL_POLOBJ_CD ID of PM Insurance Object in CD
benexclper ICL_BENEXCLPER Ben.Exclsn Per.
policy_pm ICL_PMI_POLEX Policy
polex_pm ICL_POLEX_PM External Policy
policy_pm_txt ICL_POLICY_PM_TXT Policy Name
contr_pm_txt ICL_CONTR_PM_TXT Contract Name
profile_pr_level ICL_PROFILE_PR_LEVEL_D BenProcProfile
assign_guid ICL_GUID32 Guid
clause ICL_CLAUSE_INFO_D Clauses
polprodn ICL_POLPRODN Policy Product
inscond_gen ICL_CONDGEN_D GenInsurCondtns
inscond_genn ICL_CONDTEXT_D Description
inscond_spec ICL_CONDSPEC_D Specl InsurCond
inscond_specn ICL_CONDTEXT_D Description
bukrs BUKRS Company Code
gesnr ICL_GESNR_D BP Company Code
plineofbus ICL_LINEOFBUS Insurance Line
mainmatur_dt ICL_MAINMATUR_DT_D Main Due Date
duedate ICL_DUEDATE_D Due Date
requeststatus ICL_REQUESTSTATUS_D Request Status
text_langu ICL_POL_TEXT_LANGU Language Text
multi_currency_category ICL_MULTI_CURRENCY_CAT Multi-Currency
_dataaging DATA_TEMPERATURE Data Aging
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.

-- Policy Snapshot
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPOL (
    CLIENT,                   -- Client [MANDT]
    ACTIVE,                   -- Active/Suspense [ICL_ACTIVE]
    CLAIM,                    -- Policy Snapshot [ICL_CLAIM1]
    POLVNR,                   -- Contrct Counter [ICL_POLVCNTR]
    CHANGETIME,               -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,                -- Changed By [ICL_CHANGEDBY]
    DELETED,                  -- Status [ICL_RECSTATUS]
    IMPORTSTATUS,             -- Import Status [ICL_POLIMPSTAT]
    VALIDDATA,                -- Data Status [ICL_POLVALIDDATA]
    MANCHANGE,                -- Chngd Manually [ICL_POLMANCHNG]
    VALIDFROM,                -- Vers.Valid From [ICL_POL01]
    VALIDTO,                  -- Vers.Valid To [ICL_POL02]
    SRCCHANGE,                -- Changed On [ICL_POL03]
    ISSUED,                   -- Issued On [ICL_ISSUED]
    INCEPTION,                -- Inception [ICL_INCEPTION]
    EXPIRY,                   -- End [ICL_EXPIRY]
    CURR,                     -- Currency [ICL_POLB01]
    JURISCOUNTRY,             -- C/R Juris. [ICL_JURICOUNTRY]
    JURISREGION,              -- Jurisd. Region [ICL_JURISREGION]
    NCBONUS,                  -- ClaimFree Disc. [ICL_NCBONUS]
    DISTCHAN,                 -- Distr. Channel [ICL_DISTCHAN]
    POLICY,                   -- Contract [ICL_POLICY]
    POLPROD,                  -- Policy Product [ICL_POLPROD]
    LRENEWAL,                 -- Last Renewal [ICL_LRENEWAL]
    POLOBJ_CD,                -- ID of PM Insurance Object in CD [ICL_POLOBJ_CD]
    BENEXCLPER,               -- Ben.Exclsn Per. [ICL_BENEXCLPER]
    POLICY_PM,                -- Policy [ICL_PMI_POLEX]
    POLEX_PM,                 -- External Policy [ICL_POLEX_PM]
    POLICY_PM_TXT,            -- Policy Name [ICL_POLICY_PM_TXT]
    CONTR_PM_TXT,             -- Contract Name [ICL_CONTR_PM_TXT]
    PROFILE_PR_LEVEL,         -- BenProcProfile [ICL_PROFILE_PR_LEVEL_D]
    ASSIGN_GUID,              -- Guid [ICL_GUID32]
    CLAUSE,                   -- Clauses [ICL_CLAUSE_INFO_D]
    POLPRODN,                 -- Policy Product [ICL_POLPRODN]
    INSCOND_GEN,              -- GenInsurCondtns [ICL_CONDGEN_D]
    INSCOND_GENN,             -- Description [ICL_CONDTEXT_D]
    INSCOND_SPEC,             -- Specl InsurCond [ICL_CONDSPEC_D]
    INSCOND_SPECN,            -- Description [ICL_CONDTEXT_D]
    BUKRS,                    -- Company Code [BUKRS]
    GESNR,                    -- BP Company Code [ICL_GESNR_D]
    PLINEOFBUS,               -- Insurance Line [ICL_LINEOFBUS]
    MAINMATUR_DT,             -- Main Due Date [ICL_MAINMATUR_DT_D]
    DUEDATE,                  -- Due Date [ICL_DUEDATE_D]
    REQUESTSTATUS,            -- Request Status [ICL_REQUESTSTATUS_D]
    TEXT_LANGU,               -- Language Text [ICL_POL_TEXT_LANGU]
    MULTI_CURRENCY_CATEGORY,  -- Multi-Currency [ICL_MULTI_CURRENCY_CAT]
    _DATAAGING,               -- Data Aging [DATA_TEMPERATURE]
    DUMMY_FIELD,              -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, POLVNR)
);

Learn More