ICLCLAIMASSIGN

Transparent Table Application Table

Link: Claim Subobject - Claim Subobject

ICLCLAIMASSIGN is an SAP database table in S/4HANA. Link: Claim Subobject - Claim Subobject. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_InsuranceClaimAssignment view_entity from EXTENSION Claim Subobj Link - Extension
I_InsurClmHandlerAssignment view from BASIC Sachbearbeiterzuordnung
I_InsurClmLinkClaimSubobject view from BASIC Verknüpfung: Fallteilobjekt - Fallteilobjekt
I_InsurClmSubclmAssgmtLinkage view from BASIC Grundsicht für Links: Schaden- und Teilfallzuordnung
I_InsurClmSubclmRoleBsdPerfrmr view from BASIC Sachbearbeiterzuordnung
I_InsurClmSubobjectAssignment view_entity from BASIC Claims - Subobject assignments

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY sguid ICL_SOURCE_GUID SourceUUID
KEY tguid ICL_TARGET_GUID TargetUUID
KEY assigncat ICL_ASSIGN_CAT Link Category
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
sourcetab ICL_SOURCE_TABNAME Source Table Name
targettab ICL_TARGET_TABNAME Target Table Name
tclaim ICL_CLAIM_REF Ref.Claim No.
assigntype ICL_ASSIGN_TYPE_D Link Type
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.

-- Link: Claim Subobject - Claim Subobject
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLCLAIMASSIGN (
    CLIENT,       -- Client [MANDT]
    ACTIVE,       -- Active/Suspense [ICL_ACTIVE]
    CLAIM,        -- Claim Number [ICL_CLAIM]
    SGUID,        -- SourceUUID [ICL_SOURCE_GUID]
    TGUID,        -- TargetUUID [ICL_TARGET_GUID]
    ASSIGNCAT,    -- Link Category [ICL_ASSIGN_CAT]
    CHANGETIME,   -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,    -- Changed By [ICL_CHANGEDBY]
    DELETED,      -- Status [ICL_RECSTATUS]
    SOURCETAB,    -- Source Table Name [ICL_SOURCE_TABNAME]
    TARGETTAB,    -- Target Table Name [ICL_TARGET_TABNAME]
    TCLAIM,       -- Ref.Claim No. [ICL_CLAIM_REF]
    ASSIGNTYPE,   -- Link Type [ICL_ASSIGN_TYPE_D]
    DUMMY_FIELD,  -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SGUID, TGUID, ASSIGNCAT)
);