ICLCCEVENTCO
Multiple Contract Handling - Contract Overview
ICLCCEVENTCO is an SAP database table in S/4HANA. Multiple Contract Handling - Contract Overview. It contains 35 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurClmBndlContractOverview | view | from | BASIC | Mehrerer Verträge–Vertragsübersicht |
Fields (35)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | active | ICL_ACTIVE | Active/Suspense | |||
| KEY | ccevent | ICL_CCEVENT | Claim Bundle | |||
| KEY | contract | ICL_POLICY | Contract | |||
| KEY | assign_guid | ICL_ASSIGN_GUID | Link UUID | |||
| KEY | losstype | ICL_LOSSTYPE | Incident Type | |||
| KEY | parent_contract | ICL_POLICY | Contract | |||
| changetime | ICL_CHANGEUTC1 | Changed On | ||||
| changedby | ICL_CHANGEDBY | Changed By | ||||
| deleted | ICL_RECSTATUS | Status | ||||
| xselect | ICL_SELECT | Sel. | ||||
| lob | ICL_LINEOFBUS | Insurance Line | ||||
| policy | ICL_POLICY_D | Policy | ||||
| contractn | ICL_CONTR_PM_TXT | Contract Name | ||||
| claim_data | CHAR6 | Reserve | ||||
| coverage | ICL_COVERAGENR_TT_D | Coverage No. | ||||
| coveragen | ICL_COVDESCRIP_EXT | Name | ||||
| covtype | ICL_COVTYPE | Coverage Type | ||||
| losstypen | ICL_LOSSTYPEN | IncidentType Nm | ||||
| claim | ICL_CLAIM | Claim Number | ||||
| polprod | ICL_POLPROD | Policy Product | ||||
| generat | ICL_GENERAT | Generation | ||||
| version | ICL_POLPRODV | Version | ||||
| profile_pr_level | ICL_PROFILE_PR_LEVEL_D | BenProcProfile | ||||
| lossdate | ICL_LOSSDATE | Date of Loss | ||||
| losstime | ICL_LOSSTIME | Time | ||||
| begin_date | ICL_VALID_FROM | Valid From | ||||
| end_date | ICL_VALID_TO | Valid To | ||||
| cont_cancel_dt | ICL_VALID_TO | Valid To | ||||
| incident_sequence | ICL_SEQNUM | Item Number | ||||
| withdrawseq | ICL_WITHDRAWSEQ_D | Withdrawal Seq. | ||||
| withdrawamount | ICL_WITHDRAWAM_D | Withdrawal Amt | ||||
| withdrawamountcurr | ICL_WITHDRAWCURR_D | Currency | ||||
| benvalue | ICL_BENVALUE_D | Benefit Value | ||||
| evcurr | ICL_EVCURR | Currency |
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.
-- Multiple Contract Handling - Contract Overview
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLCCEVENTCO (
CLIENT, -- Client [MANDT]
ACTIVE, -- Active/Suspense [ICL_ACTIVE]
CCEVENT, -- Claim Bundle [ICL_CCEVENT]
CONTRACT, -- Contract [ICL_POLICY]
ASSIGN_GUID, -- Link UUID [ICL_ASSIGN_GUID]
LOSSTYPE, -- Incident Type [ICL_LOSSTYPE]
PARENT_CONTRACT, -- Contract [ICL_POLICY]
CHANGETIME, -- Changed On [ICL_CHANGEUTC1]
CHANGEDBY, -- Changed By [ICL_CHANGEDBY]
DELETED, -- Status [ICL_RECSTATUS]
XSELECT, -- Sel. [ICL_SELECT]
LOB, -- Insurance Line [ICL_LINEOFBUS]
POLICY, -- Policy [ICL_POLICY_D]
CONTRACTN, -- Contract Name [ICL_CONTR_PM_TXT]
CLAIM_DATA, -- Reserve [CHAR6]
COVERAGE, -- Coverage No. [ICL_COVERAGENR_TT_D]
COVERAGEN, -- Name [ICL_COVDESCRIP_EXT]
COVTYPE, -- Coverage Type [ICL_COVTYPE]
LOSSTYPEN, -- IncidentType Nm [ICL_LOSSTYPEN]
CLAIM, -- Claim Number [ICL_CLAIM]
POLPROD, -- Policy Product [ICL_POLPROD]
GENERAT, -- Generation [ICL_GENERAT]
VERSION, -- Version [ICL_POLPRODV]
PROFILE_PR_LEVEL, -- BenProcProfile [ICL_PROFILE_PR_LEVEL_D]
LOSSDATE, -- Date of Loss [ICL_LOSSDATE]
LOSSTIME, -- Time [ICL_LOSSTIME]
BEGIN_DATE, -- Valid From [ICL_VALID_FROM]
END_DATE, -- Valid To [ICL_VALID_TO]
CONT_CANCEL_DT, -- Valid To [ICL_VALID_TO]
INCIDENT_SEQUENCE, -- Item Number [ICL_SEQNUM]
WITHDRAWSEQ, -- Withdrawal Seq. [ICL_WITHDRAWSEQ_D]
WITHDRAWAMOUNT, -- Withdrawal Amt [ICL_WITHDRAWAM_D]
WITHDRAWAMOUNTCURR, -- Currency [ICL_WITHDRAWCURR_D]
BENVALUE, -- Benefit Value [ICL_BENVALUE_D]
EVCURR, -- Currency [ICL_EVCURR]
PRIMARY KEY (CLIENT, ACTIVE, CCEVENT, CONTRACT, ASSIGN_GUID, LOSSTYPE, PARENT_CONTRACT)
);
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