ICLDIAGNOSIS

Transparent Table Application Table
32 Fields 4 CDS Views

Diagnoses Made

ICLDIAGNOSIS is an SAP database table in S/4HANA. Diagnoses Made. It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_InsuranceClaimDiagnosis view_entity from EXTENSION Claim Diagnoses - Extension
E_InsuranceClaimDiagnosis_2 view_entity from EXTENSION Claim Diagnoses - Extension
I_InsurClmDiagnosis view from BASIC Grundsicht für ICLDIAGNOSIS
I_InsurClmItemDiagnosis view_entity from BASIC Claim Item Diagnosis

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY patient ICL_DAMOBJBI Injured person
KEY subobjcat ICL_SUBOBJCAT Subobject Cat.
KEY subobject ICL_SUBOBJECTD Subobject
KEY diagno ICL_DIAGNO Diagnosis No.
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
cataid1 ICL_CATAID Catalog
diagid1 ICL_PRIMDIAGID Primary Diagn.
cataid2 ICL_CATAID Catalog
diagid2 ICL_SECDIAGID Secondary Diag.
diagnoparent ICL_DIAGNO_OLD_D Diagnosis No.
description ICL_DESCRIPTION Diagnosis Desc.
enddate ICL_ENDDATE End Date
diagsrccat ICL_PDOCCAT ClmItemGrpngCat
diagsrcid ICL_DIAGSRCID Diag.Srce ID
diagtype ICL_DIAGTYPE Diagnosis Type
localization ICL_LOCALIZATION Localization
severitycode ICL_SEVERITYCODE Severity
morphology ICL_MORPHOLOGY Morphology
excoriation ICL_EXCORIATION Excoriation
guarantee ICL_GUARANTEE Certainty
department ICL_DEPARTMENT Department
diagorder ICL_DIAGORDER Sequence
localization2 ICL_LOCALIZATION2 Localization 2
used4calc ICL_USED4CALC Used f.Grouping
assign_guid ICL_ASSIGN_GUID Link UUID
_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.

-- Diagnoses Made
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLDIAGNOSIS (
    CLIENT,         -- Client [MANDT]
    ACTIVE,         -- Active/Suspense [ICL_ACTIVE]
    CLAIM,          -- Claim Number [ICL_CLAIM]
    PATIENT,        -- Injured person [ICL_DAMOBJBI]
    SUBOBJCAT,      -- Subobject Cat. [ICL_SUBOBJCAT]
    SUBOBJECT,      -- Subobject [ICL_SUBOBJECTD]
    DIAGNO,         -- Diagnosis No. [ICL_DIAGNO]
    CHANGETIME,     -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,      -- Changed By [ICL_CHANGEDBY]
    DELETED,        -- Status [ICL_RECSTATUS]
    CATAID1,        -- Catalog [ICL_CATAID]
    DIAGID1,        -- Primary Diagn. [ICL_PRIMDIAGID]
    CATAID2,        -- Catalog [ICL_CATAID]
    DIAGID2,        -- Secondary Diag. [ICL_SECDIAGID]
    DIAGNOPARENT,   -- Diagnosis No. [ICL_DIAGNO_OLD_D]
    DESCRIPTION,    -- Diagnosis Desc. [ICL_DESCRIPTION]
    ENDDATE,        -- End Date [ICL_ENDDATE]
    DIAGSRCCAT,     -- ClmItemGrpngCat [ICL_PDOCCAT]
    DIAGSRCID,      -- Diag.Srce ID [ICL_DIAGSRCID]
    DIAGTYPE,       -- Diagnosis Type [ICL_DIAGTYPE]
    LOCALIZATION,   -- Localization [ICL_LOCALIZATION]
    SEVERITYCODE,   -- Severity [ICL_SEVERITYCODE]
    MORPHOLOGY,     -- Morphology [ICL_MORPHOLOGY]
    EXCORIATION,    -- Excoriation [ICL_EXCORIATION]
    GUARANTEE,      -- Certainty [ICL_GUARANTEE]
    DEPARTMENT,     -- Department [ICL_DEPARTMENT]
    DIAGORDER,      -- Sequence [ICL_DIAGORDER]
    LOCALIZATION2,  -- Localization 2 [ICL_LOCALIZATION2]
    USED4CALC,      -- Used f.Grouping [ICL_USED4CALC]
    ASSIGN_GUID,    -- Link UUID [ICL_ASSIGN_GUID]
    _DATAAGING,     -- Data Aging [DATA_TEMPERATURE]
    DUMMY_FIELD,    -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, PATIENT, SUBOBJCAT, SUBOBJECT, DIAGNO)
);

Learn More