ICSPOLS SAP table for – Sums Insured and Calculations in Policy Snapshot

Here we would like to draw your attention to ICSPOLS 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). ICSPOLS is a SAP standard transp table used for storing Sums Insured and Calculations in Policy Snapshot related data in SAP. It comes under the package ICL_POLICY.

SAP ICSPOLS table

Table ICSPOLS technical data

TableICSPOLS
Data storingSums Insured and Calculations in Policy Snapshot
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_POLICY
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSPOLS 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 ICSPOLS 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 : Policy Snapshot for Claim
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • POLVNR : Counter of Contract Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • COVERAGE : Coverage
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BENTYPE : Benefit Type
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INSUREDOBJ : Insured Object Number
    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 ICLPOLS
  • ENTRYEXPRESSION : BRF Expression for Calculating Entry Value
    Its data type is CHAR (Character String) with field length 20
  • INSURED_SUM : Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • XINSSUM : Read Sum Insured from Customizing if Amount = 0
    Its data type is CHAR (Character String) with field length 1
  • SUMEXPRESSION : BRF Expression for Calculating Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • MINSUM : Minimum Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • MINEXPRESSION : BRF Expression for Calculating the Minimum of Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • MAXSUM : Maximum Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • MAXEXPRESSION : BRF Expression for Calculating Maximum of Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • CALCEXPRESSION : BRF Expression for Calculating Payout Amount
    Its data type is CHAR (Character String) with field length 20
  • XCALCEXP : Read Calculation Rule from Customizing If Entry Is Empty
    Its data type is CHAR (Character String) with field length 1
  • RBENTYPE : Benefit Type of Reference Benefit Type in Contract
    Its data type is CHAR (Character String) with field length 10
  • RCOVTYPE : Coverage Type of Reference Coverage Type in Contract
    Its data type is CHAR (Character String) with field length 10
  • PERCENT : Reference Sum Insured in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SUMCALCORDER : Calculation Rule for Sum Insured
    Its data type is CHAR (Character String) with field length 1
  • ASSIGN_GUID : GUID of Length 32
    Its data type is CHAR (Character String) with field length 32