ICLITEMRE

Transparent Table Application Table
31 Fields 1 CDS Views

Damaged Real Estate

ICLITEMRE is an SAP database table in S/4HANA. Damaged Real Estate. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmDamagedProperty view from BASIC Schadenobjekte

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY damagedobj ICL_DAMOBJRE Buildings
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
dateaddr ICL_ADDRESSCH Move Date
constyear ICL_RESTATE02 Constructn Year
losstype ICL_ITEMAULT Scope of Loss
xvendor ICL_ITEMAU05 Pref. Vendor
rb_fchange ICL_RB_FCHANGE Formal change
rb_naddr ICL_RB_NEW New Address
xtotdamage ICL_ITEMAU11 Total Loss
xownerret ICL_SALVOWNRET Owner Retained
evaldate ICL_SALVEVALDT Evaluation Date
determdate ICL_SALVDETRDT DmgdObj DetmDte
estacv ICL_SALVESTACV Avge Potential
salvvalue ICL_SALVVALUE Salvage Value
curr ICL_ACVCURR Currency
histrate ICL_HISTRATEI History Rate
assigndate ICL_ASSIGNDT Date Assigned
retrvdate ICL_RETRVDT Arrival Date
settledate ICL_SETTLEMENTDT Settlement Date
solddate ICL_SALVSOLDD Date Sold
titlerecv ICL_TITLTOINS Date Received
note ICL_SALVAGE_NOTE Notes
sel_location ICL_INSPLOC Location

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.

-- Damaged Real Estate
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLITEMRE (
    CLIENT,        -- Client [MANDT]
    ACTIVE,        -- Active/Suspense [ICL_ACTIVE]
    CLAIM,         -- Claim Number [ICL_CLAIM]
    DAMAGEDOBJ,    -- Buildings [ICL_DAMOBJRE]
    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]
    DATEADDR,      -- Move Date [ICL_ADDRESSCH]
    CONSTYEAR,     -- Constructn Year [ICL_RESTATE02]
    LOSSTYPE,      -- Scope of Loss [ICL_ITEMAULT]
    XVENDOR,       -- Pref. Vendor [ICL_ITEMAU05]
    RB_FCHANGE,    -- Formal change [ICL_RB_FCHANGE]
    RB_NADDR,      -- New Address [ICL_RB_NEW]
    XTOTDAMAGE,    -- Total Loss [ICL_ITEMAU11]
    XOWNERRET,     -- Owner Retained [ICL_SALVOWNRET]
    EVALDATE,      -- Evaluation Date [ICL_SALVEVALDT]
    DETERMDATE,    -- DmgdObj DetmDte [ICL_SALVDETRDT]
    ESTACV,        -- Avge Potential [ICL_SALVESTACV]
    SALVVALUE,     -- Salvage Value [ICL_SALVVALUE]
    CURR,          -- Currency [ICL_ACVCURR]
    HISTRATE,      -- History Rate [ICL_HISTRATEI]
    ASSIGNDATE,    -- Date Assigned [ICL_ASSIGNDT]
    RETRVDATE,     -- Arrival Date [ICL_RETRVDT]
    SETTLEDATE,    -- Settlement Date [ICL_SETTLEMENTDT]
    SOLDDATE,      -- Date Sold [ICL_SALVSOLDD]
    TITLERECV,     -- Date Received [ICL_TITLTOINS]
    NOTE,          -- Notes [ICL_SALVAGE_NOTE]
    SEL_LOCATION,  -- Location [ICL_INSPLOC]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, DAMAGEDOBJ)
);

Learn More