ICS_SUBROG SAP table for – Subrogation/Recovery (Header): Shadow Table

Here we would like to draw your attention to ICS_SUBROG 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). ICS_SUBROG is a SAP standard transp table used for storing Subrogation/Recovery (Header): Shadow Table related data in SAP. It comes under the package ICL_SUBROGATION_PE.

SAP ICS_SUBROG table

Table ICS_SUBROG technical data

TableICS_SUBROG
Data storingSubrogation/Recovery (Header): Shadow Table
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_SUBROGATION_PE
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICS_SUBROG 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 ICS_SUBROG 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
  • SUBROG_GUID : Universal Unique Identifier of Subrogation/Recovery
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • 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 : Subrogation/Recovery Attributes
  • TYPE : Type of Subrogation/Recovery
    Its data type is CHAR (Character String) with field length 10
  • REASON : Subrogation/Recovery Reason
    Its data type is CHAR (Character String) with field length 10
  • ESTIMAMOUNT : Estimated Subrogation/Recovery Amount
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Subrogation/Recovery Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • LIABRATE : Liability Rate for Subrogation/Recovery
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PROBABILITY : Subrogation/Recovery Probability
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • BP_SBRG_MAIN : Party Liable
    Its data type is CHAR (Character String) with field length 10
  • LITHGUID : Universal Unique Identifier of Litigation
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Subrogation/Recovery Status
  • SR_STATUS : Subrogation/Recovery Status
    Its data type is CHAR (Character String) with field length 1
  • SENTDATE : Date Sent (Notification of Subrogation/Recovery Activation)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FINISHED : Subrogation/Recovery Status “Completed”
    Its data type is CHAR (Character String) with field length 1
  • CLOSEREASON : Closure Reason for Subrogation/Recovery
    Its data type is CHAR (Character String) with field length 80
  • .INCLUDE : Subrogation/Recovery IDs
  • SUBROG_ID : Number of Subrogation/Recovery
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • SUBROG_CGUID : Subrogation/Recovery: Compressed GUID (Univ.Unique Identif.)
    Its data type is CHAR (Character String) with field length 16