ICLITEMAU

Transparent Table Application Table
78 Fields 3 CDS Views

Damaged Vehicle

ICLITEMAU is an SAP database table in S/4HANA. Damaged Vehicle. It contains 78 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_InsuranceClaimDamagedVehicle view_entity from EXTENSION Insurance Claim Damaged Veh - Extension
I_InsurClm1stNotifDmgdVeh view from BASIC Schadenmeldung - Beschädigtes Fahrzeug
I_InsurClmDamagedVeh view from BASIC Beschädigtes Fahrzeug

Fields (78)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY damagedobj ICL_DAMOBJAU Damaged vehicle
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
propmake ICL_IOBMA Make
propmodel ICL_IOBMODEL Model
modelty ICL_IOBTY Category
vin ICL_VIN Vehicle ID No.
platecountry LAND1 Country/Reg.
plateregion REGIO Region
plateno ICL_LICENSE Plate Number
constyear ICL_CONSTYEAR Constructn Year
firstreg ICL_NOLDOAU04 Registration
capacity ICL_CAPACITY Engine Capacity
capunit ICL_CAPUNIT Unit of measure
color ICL_COLOR Color
gear ICL_GEAR Gear Type
xthirdparty ICL_XLIAB Liability
location ICL_SCIAUADR Location where damaged object can be seen
inspdate ICL_INSPDATE Inspection Date
whenseen ICL_ITEMAU10 Inspection Note
purptrip ICL_PURPTRIP Purpose of trip
leasing ICL_LEASING Leasing
xperm ICL_ITEMAU01 Drivers License
xdam ICL_ITEMAU02 Damaged
xvehicit ICL_ITEMAU03 Vehicle Cited
xdrivcit ICL_ITEMAU04 Driver cited
xpvendor ICL_ITEMAU05 Pref. Vendor
xparked ICL_ITEMAU06 Vehicle Parked
xpre ICL_ITEMAU07 Preexistng Dam.
drivable ICL_ITEMAUDR Not Roadworthy
mileage ICL_MILEAGE Mileage
mileageunit ICL_MILEAGEUNIT Unit
treadf ICL_TREADF Front tread
treadr ICL_TREADR Rear tread
treadunit ICL_TREADUNIT Unit
pcv ICL_PCV Vehicle Value
pcvcurr ICL_PCVCURR Currency
owphrel ICL_OWPHREL Rel. Owner/PH
xtotdamage ICL_ITEMAU11 Total Loss
xstolen ICL_ITEMPP01 Stolen
xrecovered ICL_ITEMWA02 Recovered
recoverdate ICL_RECOVERDATE Recovery Date
month_from ICL_MONTHFROM Month From
month_to ICL_MONTHTO Month to
ownerchange ICL_OWNERCHANGE Last Owner Chge
generalinsp ICL_INSPECTION Next Mand.Insp.
curr ICL_ACVCURR Currency
salvvalue ICL_SALVVALUE Salvage Value
estacv ICL_SALVESTACV Avge Potential
evaldate ICL_SALVEVALDT Evaluation Date
determdate ICL_SALVDETRDT DmgdObj DetmDte
dateatrpr ICL_DTATRPR Arrival Date
rptdtocb ICL_RPTDTOCB Dte Rptd Police
solddate ICL_SALVSOLDD Date Sold
xownerret ICL_SALVOWNRET Owner Retained
histrate ICL_HISTRATEI History Rate
dailyrate ICL_DAILYRATESALV StandgChrgeSalv
assigndate ICL_ASSIGNDT Date Assigned
retrvdate ICL_RETRVDT Arrival Date
settledate ICL_SETTLEMENTDT Settlement Date
stocknum ICL_SALVSTOCK Stock Number
yardloc ICL_SALVYARDLOC Salvor Location
titletosalv ICL_SALVTITLEST Title to Salvor
titlefmsalv ICL_SALVTITLERC Title w.Salvor
titletostate ICL_TITLTOSTAT Title to State
titlefmstate ICL_TITLFRMST Title Recvd
titlerecv ICL_TITLTOINS Date Received
certficatedt ICL_PROVCERTDT Certificate Dte
refno ICL_SCLITEMREF Reference no.
pdref ICL_PDREF Purchasing Doc.
pdpos ICL_PDPOS Item Number
ref_loccat ICL_EXTSVCS_REFCAT Ref. Location
ptype ICL_PTYPE Procurem.Trans.
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 Vehicle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLITEMAU (
    CLIENT,        -- Client [MANDT]
    ACTIVE,        -- Active/Suspense [ICL_ACTIVE]
    CLAIM,         -- Claim Number [ICL_CLAIM]
    DAMAGEDOBJ,    -- Damaged vehicle [ICL_DAMOBJAU]
    CHANGETIME,    -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,     -- Changed By [ICL_CHANGEDBY]
    DELETED,       -- Status [ICL_RECSTATUS]
    PROPMAKE,      -- Make [ICL_IOBMA]
    PROPMODEL,     -- Model [ICL_IOBMODEL]
    MODELTY,       -- Category [ICL_IOBTY]
    VIN,           -- Vehicle ID No. [ICL_VIN]
    PLATECOUNTRY,  -- Country/Reg. [LAND1]
    PLATEREGION,   -- Region [REGIO]
    PLATENO,       -- Plate Number [ICL_LICENSE]
    CONSTYEAR,     -- Constructn Year [ICL_CONSTYEAR]
    FIRSTREG,      -- Registration [ICL_NOLDOAU04]
    CAPACITY,      -- Engine Capacity [ICL_CAPACITY]
    CAPUNIT,       -- Unit of measure [ICL_CAPUNIT]
    COLOR,         -- Color [ICL_COLOR]
    GEAR,          -- Gear Type [ICL_GEAR]
    XTHIRDPARTY,   -- Liability [ICL_XLIAB]
    LOCATION,      -- Location where damaged object can be seen [ICL_SCIAUADR]
    INSPDATE,      -- Inspection Date [ICL_INSPDATE]
    WHENSEEN,      -- Inspection Note [ICL_ITEMAU10]
    PURPTRIP,      -- Purpose of trip [ICL_PURPTRIP]
    LEASING,       -- Leasing [ICL_LEASING]
    XPERM,         -- Drivers License [ICL_ITEMAU01]
    XDAM,          -- Damaged [ICL_ITEMAU02]
    XVEHICIT,      -- Vehicle Cited [ICL_ITEMAU03]
    XDRIVCIT,      -- Driver cited [ICL_ITEMAU04]
    XPVENDOR,      -- Pref. Vendor [ICL_ITEMAU05]
    XPARKED,       -- Vehicle Parked [ICL_ITEMAU06]
    XPRE,          -- Preexistng Dam. [ICL_ITEMAU07]
    DRIVABLE,      -- Not Roadworthy [ICL_ITEMAUDR]
    MILEAGE,       -- Mileage [ICL_MILEAGE]
    MILEAGEUNIT,   -- Unit [ICL_MILEAGEUNIT]
    TREADF,        -- Front tread [ICL_TREADF]
    TREADR,        -- Rear tread [ICL_TREADR]
    TREADUNIT,     -- Unit [ICL_TREADUNIT]
    PCV,           -- Vehicle Value [ICL_PCV]
    PCVCURR,       -- Currency [ICL_PCVCURR]
    OWPHREL,       -- Rel. Owner/PH [ICL_OWPHREL]
    XTOTDAMAGE,    -- Total Loss [ICL_ITEMAU11]
    XSTOLEN,       -- Stolen [ICL_ITEMPP01]
    XRECOVERED,    -- Recovered [ICL_ITEMWA02]
    RECOVERDATE,   -- Recovery Date [ICL_RECOVERDATE]
    MONTH_FROM,    -- Month From [ICL_MONTHFROM]
    MONTH_TO,      -- Month to [ICL_MONTHTO]
    OWNERCHANGE,   -- Last Owner Chge [ICL_OWNERCHANGE]
    GENERALINSP,   -- Next Mand.Insp. [ICL_INSPECTION]
    CURR,          -- Currency [ICL_ACVCURR]
    SALVVALUE,     -- Salvage Value [ICL_SALVVALUE]
    ESTACV,        -- Avge Potential [ICL_SALVESTACV]
    EVALDATE,      -- Evaluation Date [ICL_SALVEVALDT]
    DETERMDATE,    -- DmgdObj DetmDte [ICL_SALVDETRDT]
    DATEATRPR,     -- Arrival Date [ICL_DTATRPR]
    RPTDTOCB,      -- Dte Rptd Police [ICL_RPTDTOCB]
    SOLDDATE,      -- Date Sold [ICL_SALVSOLDD]
    XOWNERRET,     -- Owner Retained [ICL_SALVOWNRET]
    HISTRATE,      -- History Rate [ICL_HISTRATEI]
    DAILYRATE,     -- StandgChrgeSalv [ICL_DAILYRATESALV]
    ASSIGNDATE,    -- Date Assigned [ICL_ASSIGNDT]
    RETRVDATE,     -- Arrival Date [ICL_RETRVDT]
    SETTLEDATE,    -- Settlement Date [ICL_SETTLEMENTDT]
    STOCKNUM,      -- Stock Number [ICL_SALVSTOCK]
    YARDLOC,       -- Salvor Location [ICL_SALVYARDLOC]
    TITLETOSALV,   -- Title to Salvor [ICL_SALVTITLEST]
    TITLEFMSALV,   -- Title w.Salvor [ICL_SALVTITLERC]
    TITLETOSTATE,  -- Title to State [ICL_TITLTOSTAT]
    TITLEFMSTATE,  -- Title Recvd [ICL_TITLFRMST]
    TITLERECV,     -- Date Received [ICL_TITLTOINS]
    CERTFICATEDT,  -- Certificate Dte [ICL_PROVCERTDT]
    REFNO,         -- Reference no. [ICL_SCLITEMREF]
    PDREF,         -- Purchasing Doc. [ICL_PDREF]
    PDPOS,         -- Item Number [ICL_PDPOS]
    REF_LOCCAT,    -- Ref. Location [ICL_EXTSVCS_REFCAT]
    PTYPE,         -- Procurem.Trans. [ICL_PTYPE]
    SEL_LOCATION,  -- Location [ICL_INSPLOC]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, DAMAGEDOBJ)
);

Learn More