ICLITEMEQ

Transparent Table Application Table
39 Fields 2 CDS Views

Damaged Item

ICLITEMEQ is an SAP database table in S/4HANA. Damaged Item. It contains 39 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmDamagedItem view_entity from EXTENSION Claim Damaged Item - Extension
I_InsurClmDamagedItem view from BASIC Beschädigter Gegenstand

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY damagedobj ICL_DAMOBJEQ Item
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
make ICL_IOBMA Make
model ICL_IOBMODEL Model
constyear ICL_PEQUIP02 Constructn Year
serialno ICL_PEQUIP01 Serial Number
location ICL_SCIAUADR Location where damaged object can be seen
losstype ICL_ITEMAULT Scope of Loss
propuse ICL_IOBUSEL Use
xdamaged ICL_ITEMES01 Damaged
xrecovered ICL_ITEMWA02 Recovered
xpvendor ICL_ITEMAU05 Pref. Vendor
xstolen ICL_ITEMPP01 Stolen
xrental ICL_ITEMPP02 Rental
operable ICL_ITEMEQ01 Operable
estrepairdate ICL_ITEMEQ02 Repair Date
actrepairdate ICL_ITEMEQ03 Actl Rep. Date
whenseen ICL_ITEMEQ04 Inspection Note
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
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.

-- Damaged Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLITEMEQ (
    CLIENT,         -- Client [MANDT]
    ACTIVE,         -- Active/Suspense [ICL_ACTIVE]
    CLAIM,          -- Claim Number [ICL_CLAIM]
    DAMAGEDOBJ,     -- Item [ICL_DAMOBJEQ]
    CHANGETIME,     -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,      -- Changed By [ICL_CHANGEDBY]
    DELETED,        -- Status [ICL_RECSTATUS]
    MAKE,           -- Make [ICL_IOBMA]
    MODEL,          -- Model [ICL_IOBMODEL]
    CONSTYEAR,      -- Constructn Year [ICL_PEQUIP02]
    SERIALNO,       -- Serial Number [ICL_PEQUIP01]
    LOCATION,       -- Location where damaged object can be seen [ICL_SCIAUADR]
    LOSSTYPE,       -- Scope of Loss [ICL_ITEMAULT]
    PROPUSE,        -- Use [ICL_IOBUSEL]
    XDAMAGED,       -- Damaged [ICL_ITEMES01]
    XRECOVERED,     -- Recovered [ICL_ITEMWA02]
    XPVENDOR,       -- Pref. Vendor [ICL_ITEMAU05]
    XSTOLEN,        -- Stolen [ICL_ITEMPP01]
    XRENTAL,        -- Rental [ICL_ITEMPP02]
    OPERABLE,       -- Operable [ICL_ITEMEQ01]
    ESTREPAIRDATE,  -- Repair Date [ICL_ITEMEQ02]
    ACTREPAIRDATE,  -- Actl Rep. Date [ICL_ITEMEQ03]
    WHENSEEN,       -- Inspection Note [ICL_ITEMEQ04]
    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]
    DUMMY_FIELD,    -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, DAMAGEDOBJ)
);

Learn More