ICLCLAIMASSIGN
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA