ICLDIAGNDRAFT3

Transparent Table Application Table
40 Fields 1 CDS Views

Draft Table for Entity R_INS_ClaimItemDiagnosisTP

ICLDIAGNDRAFT3 is an SAP database table in S/4HANA. Draft Table for Entity R_INS_ClaimItemDiagnosisTP. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_INS_ClaimItemDiagnosisDraft view_entity from BASIC Claim Item Diagnosis - Draft

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY insurclmactive ICL_ACTIVE Active/Suspense
KEY insuranceclaim ICL_CLAIM Claim Number
KEY insurclminjuredpersonnumber ICL_DAMOBJBI Injured person
KEY insurclmsubobjectcategory ICL_SUBOBJCAT Subobject Cat.
KEY insurclmdmgdsubobject ICL_SUBOBJECTD Subobject
KEY insurclmdiagnosisnmbr ICL_DIAGNO Diagnosis No.
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
lastchangedatetime ICL_ACHANGETIME_FIORI Last Changed At
lastchangedbyuser ICL_CHANGEDBY Changed By
insurclmdatabaselinestatus ICL_RECSTATUS Status
insurclmcatalogcode ICL_CATAID Catalog
insurclmdiagnosiscode ICL_PRIMDIAGID Primary Diagn.
insurclmbusinesspartner ICL_PART Participant
insurclmsecdryctlgcode ICL_CATAID Catalog
insurclmsecdrydiagncode ICL_SECDIAGID Secondary Diag.
insurclmprevdiagnnmbr ICL_DIAGNO_OLD_D Diagnosis No.
insurclmdiagnosisdescription ICL_DESCRIPTION Diagnosis Desc.
insuranceclaimdiagnosisenddate ICL_ENDDATE End Date
insurclmitemgroupingcategory ICL_PDOCCAT ClmItemGrpngCat
insurclmdiagnosissourceid ICL_DIAGSRCID Diag.Srce ID
insurclmdiagnosistypecode ICL_DIAGTYPE Diagnosis Type
insurclmlocalizedside ICL_LOCALIZATION Localization
insurclmsvrtyofdiagncode ICL_SEVERITYCODE Severity
insurclmdiagnmorphologycode ICL_MORPHOLOGY Morphology
insurclmdiagnexcoriationcode ICL_EXCORIATION Excoriation
insurclmdiagnguaranteecode ICL_GUARANTEE Certainty
insurclmdeptofhosp ICL_DEPARTMENT Department
insurclaimdiagnsequence ICL_DIAGORDER Sequence
insurclmsecdrylcldside ICL_LOCALIZATION2 Localization 2
insurclmisusdforgrpg ICL_USED4CALC Used f.Grouping
insurclmassignuuid ICL_ASSIGN_GUID Link UUID
dummy_field abap.char
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft Table for Entity R_INS_ClaimItemDiagnosisTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLDIAGNDRAFT3 (
    MANDT,                           -- Client [MANDT]
    INSURCLMACTIVE,                  -- Active/Suspense [ICL_ACTIVE]
    INSURANCECLAIM,                  -- Claim Number [ICL_CLAIM]
    INSURCLMINJUREDPERSONNUMBER,     -- Injured person [ICL_DAMOBJBI]
    INSURCLMSUBOBJECTCATEGORY,       -- Subobject Cat. [ICL_SUBOBJCAT]
    INSURCLMDMGDSUBOBJECT,           -- Subobject [ICL_SUBOBJECTD]
    INSURCLMDIAGNOSISNMBR,           -- Diagnosis No. [ICL_DIAGNO]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    LASTCHANGEDATETIME,              -- Last Changed At [ICL_ACHANGETIME_FIORI]
    LASTCHANGEDBYUSER,               -- Changed By [ICL_CHANGEDBY]
    INSURCLMDATABASELINESTATUS,      -- Status [ICL_RECSTATUS]
    INSURCLMCATALOGCODE,             -- Catalog [ICL_CATAID]
    INSURCLMDIAGNOSISCODE,           -- Primary Diagn. [ICL_PRIMDIAGID]
    INSURCLMBUSINESSPARTNER,         -- Participant [ICL_PART]
    INSURCLMSECDRYCTLGCODE,          -- Catalog [ICL_CATAID]
    INSURCLMSECDRYDIAGNCODE,         -- Secondary Diag. [ICL_SECDIAGID]
    INSURCLMPREVDIAGNNMBR,           -- Diagnosis No. [ICL_DIAGNO_OLD_D]
    INSURCLMDIAGNOSISDESCRIPTION,    -- Diagnosis Desc. [ICL_DESCRIPTION]
    INSURANCECLAIMDIAGNOSISENDDATE,  -- End Date [ICL_ENDDATE]
    INSURCLMITEMGROUPINGCATEGORY,    -- ClmItemGrpngCat [ICL_PDOCCAT]
    INSURCLMDIAGNOSISSOURCEID,       -- Diag.Srce ID [ICL_DIAGSRCID]
    INSURCLMDIAGNOSISTYPECODE,       -- Diagnosis Type [ICL_DIAGTYPE]
    INSURCLMLOCALIZEDSIDE,           -- Localization [ICL_LOCALIZATION]
    INSURCLMSVRTYOFDIAGNCODE,        -- Severity [ICL_SEVERITYCODE]
    INSURCLMDIAGNMORPHOLOGYCODE,     -- Morphology [ICL_MORPHOLOGY]
    INSURCLMDIAGNEXCORIATIONCODE,    -- Excoriation [ICL_EXCORIATION]
    INSURCLMDIAGNGUARANTEECODE,      -- Certainty [ICL_GUARANTEE]
    INSURCLMDEPTOFHOSP,              -- Department [ICL_DEPARTMENT]
    INSURCLAIMDIAGNSEQUENCE,         -- Sequence [ICL_DIAGORDER]
    INSURCLMSECDRYLCLDSIDE,          -- Localization 2 [ICL_LOCALIZATION2]
    INSURCLMISUSDFORGRPG,            -- Used f.Grouping [ICL_USED4CALC]
    INSURCLMASSIGNUUID,              -- Link UUID [ICL_ASSIGN_GUID]
    DUMMY_FIELD,                     -- abap.char
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, INSURCLMACTIVE, INSURANCECLAIM, INSURCLMINJUREDPERSONNUMBER, INSURCLMSUBOBJECTCATEGORY, INSURCLMDMGDSUBOBJECT, INSURCLMDIAGNOSISNMBR, DRAFTUUID)
);

Learn More