ICLPOLL
Limit and Deductible in Policy Snapshot
ICLPOLL is an SAP database table in S/4HANA. Limit and Deductible in Policy Snapshot. It contains 32 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_InsurClmLimitDeductible | view_entity | from | EXTENSION | Claim Limit and Deductible - Extension |
| I_InsurClmLimitDeductible | view | from | BASIC | Limit und Selbstbehalt im Vertragsspiegel |
Fields (32)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | active | ICL_ACTIVE | Active/Suspense | |||
| KEY | claim | ICL_CLAIM1 | Policy Snapshot | |||
| KEY | polvnr | ICL_POLVCNTR | Contrct Counter | |||
| KEY | coverage | ICL_POLM | Coverage | |||
| KEY | bentype | ICL_BENTYPE | Benefit Type | |||
| KEY | insuredobj | ICL_INSOBJ | Insured Object | |||
| KEY | priority | ICL_PRIORITY1 | Priority | |||
| changetime | ICL_CHANGEUTC1 | Changed On | ||||
| changedby | ICL_CHANGEDBY | Changed By | ||||
| deleted | ICL_RECSTATUS | Status | ||||
| cmc_rule | ICL_CMC_RULE | Rule | ||||
| limit | ICL_POLB02 | Limit | ||||
| limamt | ICL_LIMAMT | Quantity Limit | ||||
| limunit | ICL_LIMUNIT | Unit of Measure | ||||
| deductible | ICL_POLB03 | Deductible | ||||
| deductamount | ICL_DEDAMT | Dedctble (Qty) | ||||
| deductunit | ICL_DEDUNIT | Unit of Measure | ||||
| xlimit | ICL_XLIMIT | No Limit | ||||
| xlimamt | ICL_XLIMAMT | No Limit (Qty) | ||||
| xdeduc | ICL_XDEDUC | No Deductible | ||||
| xdedamt | ICL_XDEDAMT | No Dedctble (Q) | ||||
| rejreason | ICL_REJREASON2 | Rejection Reasn | ||||
| deductperc | ICL_DEDUCTPERC | Deductible (%) | ||||
| several | ICL_BENTYPE06 | Applicat.Type | ||||
| modftype | ICL_CCMODTYPE | Ddctble ChgType | ||||
| sequence | ICL_PRIORITY3 | Sequence | ||||
| assign_guid | ICL_GUID32 | Guid | ||||
| timerestrict | ICL_TIMERESTRICT_D | Time Restriction | ||||
| xlimitvalue | XLIMITVALUE_D | Indicator Whether ICLPOLL Entry Is a Limit | ||||
| dummy_field | abap.char | |||||
| riskcurr_cd | ICL_RISKCURR | Risk 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.
-- Limit and Deductible in Policy Snapshot
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPOLL (
CLIENT, -- Client [MANDT]
ACTIVE, -- Active/Suspense [ICL_ACTIVE]
CLAIM, -- Policy Snapshot [ICL_CLAIM1]
POLVNR, -- Contrct Counter [ICL_POLVCNTR]
COVERAGE, -- Coverage [ICL_POLM]
BENTYPE, -- Benefit Type [ICL_BENTYPE]
INSUREDOBJ, -- Insured Object [ICL_INSOBJ]
PRIORITY, -- Priority [ICL_PRIORITY1]
CHANGETIME, -- Changed On [ICL_CHANGEUTC1]
CHANGEDBY, -- Changed By [ICL_CHANGEDBY]
DELETED, -- Status [ICL_RECSTATUS]
CMC_RULE, -- Rule [ICL_CMC_RULE]
LIMIT, -- Limit [ICL_POLB02]
LIMAMT, -- Quantity Limit [ICL_LIMAMT]
LIMUNIT, -- Unit of Measure [ICL_LIMUNIT]
DEDUCTIBLE, -- Deductible [ICL_POLB03]
DEDUCTAMOUNT, -- Dedctble (Qty) [ICL_DEDAMT]
DEDUCTUNIT, -- Unit of Measure [ICL_DEDUNIT]
XLIMIT, -- No Limit [ICL_XLIMIT]
XLIMAMT, -- No Limit (Qty) [ICL_XLIMAMT]
XDEDUC, -- No Deductible [ICL_XDEDUC]
XDEDAMT, -- No Dedctble (Q) [ICL_XDEDAMT]
REJREASON, -- Rejection Reasn [ICL_REJREASON2]
DEDUCTPERC, -- Deductible (%) [ICL_DEDUCTPERC]
SEVERAL, -- Applicat.Type [ICL_BENTYPE06]
MODFTYPE, -- Ddctble ChgType [ICL_CCMODTYPE]
SEQUENCE, -- Sequence [ICL_PRIORITY3]
ASSIGN_GUID, -- Guid [ICL_GUID32]
TIMERESTRICT, -- Time Restriction [ICL_TIMERESTRICT_D]
XLIMITVALUE, -- Indicator Whether ICLPOLL Entry Is a Limit [XLIMITVALUE_D]
DUMMY_FIELD, -- abap.char
RISKCURR_CD, -- Risk Currency [ICL_RISKCURR]
PRIMARY KEY (CLIENT, ACTIVE, CLAIM, POLVNR, COVERAGE, BENTYPE, INSUREDOBJ, PRIORITY)
);
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