ICSITEMRE

Damaged Real Estate | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
DAMAGEDOBJ FK Damaged real estate
CHANGETIME Changed: Date + Time
Column Name Description
💲 Currency of Actual Cash Value (CURR):
ESTACV Salvage: Average Salvage Potential
SALVVALUE Salvage Value as Amount of Money
Column Name Description
Column Name Description
DATEADDR Date on which Address Changed (Move)
EVALDATE Evaluation Date for Salvage
DETERMDATE Date: Damaged Objected Determined as Salvage
ASSIGNDATE Salvage: Date Assigned to Salvage Company
RETRVDATE Salvage: Arrival Date at Salvage Yard
SETTLEDATE Salvage: Settlement Date
SOLDDATE Date Salvage Item Sold
TITLERECV Date on Which Insurer Received Title
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
XVENDOR Flag: Willing to Use Preferred Vendor? Show values
RB_FCHANGE Radio button for formal change of insured obj. to dam.obj. Show values
RB_NADDR Button: Damaged Object Has New/Other Address to Insd Object Show values
XTOTDAMAGE Flag: Total Loss Show values
XOWNERRET Flag: Retained by Owner? Show values
SEL_LOCATION Location of Damaged Object Show values
Column Name Description Domain name
RESTATEN Description of Real Estate TEXT20
CONSTYEAR Construction Year (Year Completed) of Real Estate BU_YEAR
HISTRATE History Rate in Percent ICL_PERCENT
NOTE Note on Salvage TEXT50
Master Data Relations Join Conditions
Address (CAM) of Building
  • Address (CAM) of Building
  • ?
  • ?
  • ICSITEMRE.CLIENT == ADRC.CLIENT
  • ICSITEMRE.ADDRESS == ADRC.ADDRNUMBER
  • ICSITEMRE.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICSITEMRE.[column in domain "AD_NATION"] == ADRC.NATION
Changed By
  • ICSITEMRE.CLIENT == USR02.MANDT
  • ICSITEMRE.CHANGEDBY == USR02.BNAME
Client ICSITEMRE.CLIENT == T000.MANDT
Currency of Actual Cash Value
  • ICSITEMRE.CLIENT == TCURC.MANDT
  • ICSITEMRE.CURR == TCURC.WAERS
Scope of Loss
  • Scope of Loss
  • Client
  • ?
  • ICSITEMRE.LOSSTYPE == TICL101.LOSSTYPE
  • ICSITEMRE.CLIENT == TICL101.CLIENT
  • ICSITEMRE.[column in domain "ICL_DAMCAT"] == TICL101.DAMCAT
Real Estate Primary Building Material
  • ICSITEMRE.CLIENT == TICL304.CLIENT
  • ICSITEMRE.REMATERIAL == TICL304.REMATERIAL