ICLNOTE

Transparent Table Application Table
28 Fields 2 CDS Views

Claim Note

ICLNOTE is an SAP database table in S/4HANA. Claim Note. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsuranceClaimNote view_entity from EXTENSION Claim Note - Extension
I_InsurClmNoteExtn view from BASIC Notizen - erweiterte Daten

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY objyr ICL_SOOBJYR Year
KEY objno ICL_SOOBJNO Note number
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
subclaim ICL_SUBCL Subclaim
notetype ICL_NOTETYPE Topic
comcat ICL_COMCAT Category
comtype ICL_COMTYPE Communicat.Type
xtelflag ICL_TELFLAG Outbound
chonam SO_CHO_NAM Changed
comtime ICL_COMTIMES Start Time
comstatus ICL_COMSTATUS Status
comtimee ICL_COMTIMEE End Time
notecaller ICL_NOTECALLER Call From
comdate ICL_COMDATE Date
resubmission ICL_RESUBMISSION Resubmission
authgrp ICL_AUTHGRP_NOTE Auth. Group
prio ICL_PRIO Priority
validstatus ICL_VALIDSTATUS Status Key
assign_guid ICL_ASSIGN_GUID Link UUID
noteid NTE_ID Note ID
_dataaging DATA_TEMPERATURE Data Aging
procurement ICL_PROCUREMENT ClaimItem Gpng
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.

-- Claim Note
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLNOTE (
    CLIENT,        -- Client [MANDT]
    ACTIVE,        -- Active/Suspense [ICL_ACTIVE]
    CLAIM,         -- Claim Number [ICL_CLAIM]
    OBJYR,         -- Year [ICL_SOOBJYR]
    OBJNO,         -- Note number [ICL_SOOBJNO]
    CHANGETIME,    -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,     -- Changed By [ICL_CHANGEDBY]
    DELETED,       -- Status [ICL_RECSTATUS]
    SUBCLAIM,      -- Subclaim [ICL_SUBCL]
    NOTETYPE,      -- Topic [ICL_NOTETYPE]
    COMCAT,        -- Category [ICL_COMCAT]
    COMTYPE,       -- Communicat.Type [ICL_COMTYPE]
    XTELFLAG,      -- Outbound [ICL_TELFLAG]
    CHONAM,        -- Changed [SO_CHO_NAM]
    COMTIME,       -- Start Time [ICL_COMTIMES]
    COMSTATUS,     -- Status [ICL_COMSTATUS]
    COMTIMEE,      -- End Time [ICL_COMTIMEE]
    NOTECALLER,    -- Call From [ICL_NOTECALLER]
    COMDATE,       -- Date [ICL_COMDATE]
    RESUBMISSION,  -- Resubmission [ICL_RESUBMISSION]
    AUTHGRP,       -- Auth. Group [ICL_AUTHGRP_NOTE]
    PRIO,          -- Priority [ICL_PRIO]
    VALIDSTATUS,   -- Status Key [ICL_VALIDSTATUS]
    ASSIGN_GUID,   -- Link UUID [ICL_ASSIGN_GUID]
    NOTEID,        -- Note ID [NTE_ID]
    _DATAAGING,    -- Data Aging [DATA_TEMPERATURE]
    PROCUREMENT,   -- ClaimItem Gpng [ICL_PROCUREMENT]
    DUMMY_FIELD,   -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, OBJYR, OBJNO)
);

Learn More