ICLDIPL

Transparent Table Application Table
18 Fields 1 CDS Views

Distribution Plan

ICLDIPL is an SAP database table in S/4HANA. Distribution Plan. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmDistrPlan view_entity from BASIC Verteilungsplan

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY dipl_id ICL_MI_DIPL_ID ID
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
dipl_name ICL_MI_DIPL_NAME Distributn Plan
dipl_descr ICL_MI_DIPL_DESCR Description
valfr_ts ICL_MI_VALFR_TS Valid From
valto_ts ICL_MI_VALTO_TS Valid To
diplty ICL_MI_DIPLTY DistrbPlanType
prio ICL_MI_PRIO Priority
curr ICL_MI_CURR Currency
polvnr ICL_POLVCNTR Contrct Counter
covtype ICL_COVTYPE Coverage Type
xdist_res ICL_MI_DIST_RES Reserve Distribution
xforeign_lead ICL_MI_FOREIGN_LEAD External Lead

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.

-- Distribution Plan
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLDIPL (
    CLIENT,         -- Client [MANDT]
    ACTIVE,         -- Active/Suspense [ICL_ACTIVE]
    CLAIM,          -- Claim Number [ICL_CLAIM]
    DIPL_ID,        -- ID [ICL_MI_DIPL_ID]
    CHANGETIME,     -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,      -- Changed By [ICL_CHANGEDBY]
    DELETED,        -- Status [ICL_RECSTATUS]
    DIPL_NAME,      -- Distributn Plan [ICL_MI_DIPL_NAME]
    DIPL_DESCR,     -- Description [ICL_MI_DIPL_DESCR]
    VALFR_TS,       -- Valid From [ICL_MI_VALFR_TS]
    VALTO_TS,       -- Valid To [ICL_MI_VALTO_TS]
    DIPLTY,         -- DistrbPlanType [ICL_MI_DIPLTY]
    PRIO,           -- Priority [ICL_MI_PRIO]
    CURR,           -- Currency [ICL_MI_CURR]
    POLVNR,         -- Contrct Counter [ICL_POLVCNTR]
    COVTYPE,        -- Coverage Type [ICL_COVTYPE]
    XDIST_RES,      -- Reserve Distribution [ICL_MI_DIST_RES]
    XFOREIGN_LEAD,  -- External Lead [ICL_MI_FOREIGN_LEAD]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, DIPL_ID)
);

Learn More