ICSITEMRE - Damaged Real Estate

Damaged Real Estate information is stored in SAP table ICSITEMRE.
It is part of development package ICL_CDC in software component FS-CM. This development package consists of objects that can be grouped under "FS-CM: Data Capture".

Fields for table ICSITEMRE

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
ACTIVETable entry is active (A) or in suspense (S)XICL_ACTIVECHAR2
CLAIMNumber of ClaimXICL_CLAIMCHAR34ICLCLAIM
DAMAGEDOBJDamaged real estateXICL_DAMOBJRENUMC8ICLDAMOBJ
CHANGETIMEChanged: Date + TimeXICL_CHANGEUTC1DEC8
.INCLUDEICL_INCL_VER60
CHANGEDBYChanged ByICL_CHANGEDBYCHAR24USR02
DELETEDDatabase Line Status (Original, Changed, Deleted)ICL_RECSTATUSCHAR2
.INCLUDEICS_ITEMRE0
RESTATENDescription of Real EstateICL_RESTATENCHAR40
REMATERIALReal Estate Primary Building MaterialICL_REMATERIALCHAR4TICL304
ADDRESSAddress (CAM) of BuildingICL_READDRESSCHAR20ADRC
DATEADDRDate on which Address Changed (Move)ICL_ADDRESSCHDATS16
CONSTYEARConstruction Year (Year Completed) of Real EstateICL_RESTATE02NUMC8
LOSSTYPEScope of LossICL_ITEMAULTCHAR2TICL101
XVENDORFlag: Willing to Use Preferred Vendor?ICL_ITEMAU05CHAR2
RB_FCHANGERadio button for formal change of insured obj. to dam.obj.ICL_RB_FCHANGECHAR2
RB_NADDRButton: Damaged Object Has New/Other Address to Insd ObjectICL_RB_NEWCHAR2
XTOTDAMAGEFlag: Total LossICL_ITEMAU11CHAR2
.INCLUDEICS_ITEMSALVRE0
XOWNERRETFlag: Retained by Owner?ICL_SALVOWNRETCHAR2
EVALDATEEvaluation Date for SalvageICL_SALVEVALDTDATS16
DETERMDATEDate: Damaged Objected Determined as SalvageICL_SALVDETRDTDATS16
ESTACVSalvage: Average Salvage PotentialICL_SALVESTACVCURR8
SALVVALUESalvage Value as Amount of MoneyICL_SALVVALUECURR8
CURRCurrency of Actual Cash ValueICL_ACVCURRCUKY10TCURC
HISTRATEHistory Rate in PercentICL_HISTRATEIDEC3
ASSIGNDATESalvage: Date Assigned to Salvage CompanyICL_ASSIGNDTDATS16
RETRVDATESalvage: Arrival Date at Salvage YardICL_RETRVDTDATS16
SETTLEDATESalvage: Settlement DateICL_SETTLEMENTDTDATS16
SOLDDATEDate Salvage Item SoldICL_SALVSOLDDDATS16
TITLERECVDate on Which Insurer Received TitleICL_TITLTOINSDATS16
NOTENote on SalvageICL_SALVAGE_NOTECHAR100
SEL_LOCATIONLocation of Damaged ObjectICL_INSPLOCCHAR2
Privacy Policy