ICLPOLORE

Transparent Table Application Table
15 Fields 2 CDS Views

Insured Building

ICLPOLORE is an SAP database table in S/4HANA. Insured Building. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmPlcySnpshtInsrdBldng view_entity from EXTENSION Claim Insrd Bldng - Extension
I_InsurClmPlcySnpshtInsrdBuild view from BASIC Versichertes Gebäude des Vertragsspiegels

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM1 Policy Snapshot
KEY polvnr ICL_POLVCNTR Contrct Counter
KEY insuredobj ICL_IRESTATE Building
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
restaten ICL_RESTATEN Description
rematerial ICL_REMATERIAL Prim. material
address ICL_READDRESS Address Number
constyear ICL_RESTATE02 Constructn Year
rearea ICL_IOBAREA_D Area
rearea_unit ICL_AREAUNIT_D Unit of Measure
dummy_field_polore 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.

-- Insured Building
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPOLORE (
    CLIENT,              -- Client [MANDT]
    ACTIVE,              -- Active/Suspense [ICL_ACTIVE]
    CLAIM,               -- Policy Snapshot [ICL_CLAIM1]
    POLVNR,              -- Contrct Counter [ICL_POLVCNTR]
    INSUREDOBJ,          -- Building [ICL_IRESTATE]
    CHANGETIME,          -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,           -- Changed By [ICL_CHANGEDBY]
    DELETED,             -- Status [ICL_RECSTATUS]
    RESTATEN,            -- Description [ICL_RESTATEN]
    REMATERIAL,          -- Prim. material [ICL_REMATERIAL]
    ADDRESS,             -- Address Number [ICL_READDRESS]
    CONSTYEAR,           -- Constructn Year [ICL_RESTATE02]
    REAREA,              -- Area [ICL_IOBAREA_D]
    REAREA_UNIT,         -- Unit of Measure [ICL_AREAUNIT_D]
    DUMMY_FIELD_POLORE,  -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, POLVNR, INSUREDOBJ)
);

Learn More