ICSITEMRE SAP table for – Damaged Real Estate

Here we would like to draw your attention to ICSITEMRE table in SAP. As we know it is being mainly used with the SAP FS-CM (Claims Management in FS) component which is coming under FS module (Financial Services). ICSITEMRE is a SAP standard transp table used for storing Damaged Real Estate related data in SAP. It comes under the package ICL_CDC.

SAP ICSITEMRE table

Table ICSITEMRE technical data

TableICSITEMRE
Data storingDamaged Real Estate
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSITEMRE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ICSITEMRE table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ACTIVE : Table entry is active (A) or in suspense (S)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • CLAIM : Number of Claim
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • DAMAGEDOBJ : Damaged real estate
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • CHANGETIME : Changed: UTC Date+Time
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Shadow Tables Versioning: Include for Shade Table
  • CHANGEDBY : Changed By
    Its data type is CHAR (Character String) with field length 12
  • DELETED : Database Line Status (Original, Changed, Deleted)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Attributes of ICLITEMRE
  • RESTATEN : Description of Real Estate
    Its data type is CHAR (Character String) with field length 20
  • REMATERIAL : Real Estate Primary Building Material
    Its data type is CHAR (Character String) with field length 2
  • ADDRESS : Address (CAM) of Building
    Its data type is CHAR (Character String) with field length 10
  • DATEADDR : Date on which Address Changed (Move)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONSTYEAR : Construction Year (Year Completed) of Real Estate
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LOSSTYPE : Scope of Loss
    Its data type is CHAR (Character String) with field length 1
  • XVENDOR : Flag: Willing to Use Preferred Vendor?
    Its data type is CHAR (Character String) with field length 1
  • RB_FCHANGE : Radio button for formal change of insured obj. to dam.obj.
    Its data type is CHAR (Character String) with field length 1
  • RB_NADDR : Button: Damaged Object Has New/Other Address to Insd Object
    Its data type is CHAR (Character String) with field length 1
  • XTOTDAMAGE : Flag: Total Loss
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Attributes of ICLITEMRE – Salvage
  • XOWNERRET : Flag: Retained by Owner?
    Its data type is CHAR (Character String) with field length 1
  • EVALDATE : Evaluation Date for Salvage
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DETERMDATE : Date: Damaged Objected Determined as Salvage
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ESTACV : Salvage: Average Salvage Potential
    Its data type is CURR (Currency Field) with field length 15
  • SALVVALUE : Salvage Value as Amount of Money
    Its data type is CURR (Currency Field) with field length 15
  • CURR : Currency of Actual Cash Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HISTRATE : History Rate in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ASSIGNDATE : Salvage: Date Assigned to Salvage Company
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RETRVDATE : Salvage: Arrival Date at Salvage Yard
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTLEDATE : Salvage: Settlement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SOLDDATE : Date Salvage Item Sold
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TITLERECV : Date on Which Insurer Received Title
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NOTE : Note on Salvage
    Its data type is CHAR (Character String) with field length 50
  • SEL_LOCATION : Location of Damaged Object
    Its data type is CHAR (Character String) with field length 1