ICLDENTAL

Transparent Table Application Table
17 Fields 2 CDS Views

Dental Diagnosis and Dental Treatment

ICLDENTAL is an SAP database table in S/4HANA. Dental Diagnosis and Dental Treatment. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmDamagedObjDental view_entity from EXTENSION Dntl Diagnosis and Treatment - Extension
I_InsurClmDamagedObjectDental view from BASIC Beschädigtes Objekt Zahn

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY dobj ICL_DAMOBJBI Injured person
KEY subobjcat ICL_SUBOBJCAT Subobject Cat.
KEY subobject ICL_SUBOBJECTD Subobject
KEY dentalno ICL_DENTALNO Seq.TreatmntNo.
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
tooth ICL_TOOTH Tooth Number
finding ICL_FINDING Findings
sub_planning ICL_SUBSIDIZABLE Treatment Plan
nsub_planning ICL_NOTSUBSIDIZABLE Cost Overrun
srccat ICL_PDOCCAT ClmItemGrpngCat
srcid ICL_DIAGSRCID Diag.Srce ID
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.

-- Dental Diagnosis and Dental Treatment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLDENTAL (
    CLIENT,         -- Client [MANDT]
    ACTIVE,         -- Active/Suspense [ICL_ACTIVE]
    CLAIM,          -- Claim Number [ICL_CLAIM]
    DOBJ,           -- Injured person [ICL_DAMOBJBI]
    SUBOBJCAT,      -- Subobject Cat. [ICL_SUBOBJCAT]
    SUBOBJECT,      -- Subobject [ICL_SUBOBJECTD]
    DENTALNO,       -- Seq.TreatmntNo. [ICL_DENTALNO]
    CHANGETIME,     -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,      -- Changed By [ICL_CHANGEDBY]
    DELETED,        -- Status [ICL_RECSTATUS]
    TOOTH,          -- Tooth Number [ICL_TOOTH]
    FINDING,        -- Findings [ICL_FINDING]
    SUB_PLANNING,   -- Treatment Plan [ICL_SUBSIDIZABLE]
    NSUB_PLANNING,  -- Cost Overrun [ICL_NOTSUBSIDIZABLE]
    SRCCAT,         -- ClmItemGrpngCat [ICL_PDOCCAT]
    SRCID,          -- Diag.Srce ID [ICL_DIAGSRCID]
    DUMMY_FIELD,    -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, DOBJ, SUBOBJCAT, SUBOBJECT, DENTALNO)
);

Learn More