ICSITEMEQ SAP table for – Damaged Item

Here we would like to draw your attention to ICSITEMEQ 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). ICSITEMEQ is a SAP standard transp table used for storing Damaged Item related data in SAP. It comes under the package ICL_CDC.

SAP ICSITEMEQ table

Table ICSITEMEQ technical data

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

SAP ICSITEMEQ 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 ICSITEMEQ 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 Item
    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 ICLITEMEQ
  • MAKE : Make of Insurable Object
    Its data type is CHAR (Character String) with field length 4
  • MODEL : Insurable Object Model
    Its data type is CHAR (Character String) with field length 4
  • CONSTYEAR : Construction Year of (Home Contents) Item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SERIALNO : Serial Number of (Home Contents) Item
    Its data type is CHAR (Character String) with field length 12
  • LOCATION : Location where damaged object can be seen
    Its data type is CHAR (Character String) with field length 10
  • LOSSTYPE : Scope of Loss
    Its data type is CHAR (Character String) with field length 1
  • PROPUSE : Use at Time of Loss/Claim
    Its data type is CHAR (Character String) with field length 2
  • XDAMAGED : Flag: Damaged?
    Its data type is CHAR (Character String) with field length 1
  • XRECOVERED : Flag: Stolen Object Recovered?
    Its data type is CHAR (Character String) with field length 1
  • XPVENDOR : Flag: Willing to Use Preferred Vendor?
    Its data type is CHAR (Character String) with field length 1
  • XSTOLEN : Flag: Stolen?
    Its data type is CHAR (Character String) with field length 1
  • XRENTAL : Flag: Rental?
    Its data type is CHAR (Character String) with field length 1
  • OPERABLE : Home Contents/Object Operable?
    Its data type is CHAR (Character String) with field length 1
  • ESTREPAIRDATE : Estimated Repair Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTREPAIRDATE : Actual Repair Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WHENSEEN : Note on Inspection
    Its data type is CHAR (Character String) with field length 25
  • XTOTDAMAGE : Flag: Total Loss
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Attributes of ICLITEMEQ – 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