ICSPOL SAP table for – Policy Snapshot

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

SAP ICSPOL table

Table ICSPOL technical data

TableICSPOL
Data storingPolicy Snapshot
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_POLICY
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSPOL 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 ICSPOL 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
  • 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 ICLPOL
  • IMPORTSTATUS : Import Status of Policy Snapshot
    Its data type is CHAR (Character String) with field length 1
  • VALIDDATA : Overview of Data in Policy Snapshot
    Its data type is CHAR (Character String) with field length 1
  • MANCHANGE : Policy Snapshot Changed Manually
    Its data type is CHAR (Character String) with field length 1
  • VALIDFROM : Contract Version: Valid-From Date
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • VALIDTO : Contract Version: Valid To Date
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SRCCHANGE : UTC Date and Time of Version Change in Policy System
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ISSUED : Date of Issue
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • INCEPTION : Inception of Contract
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • EXPIRY : End Date and Time of Contract
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CURR : Currency of Limit and Deductible
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • JURISCOUNTRY : Jurisdiction Country
    Its data type is CHAR (Character String) with field length 3
  • JURISREGION : Jurisdiction Region
    Its data type is CHAR (Character String) with field length 3
  • NCBONUS : Claim-Free Discount
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DISTCHAN : Insurance Distribution Channel
    Its data type is CHAR (Character String) with field length 1
  • POLICY : Contract Number
    Its data type is CHAR (Character String) with field length 17
  • POLPROD : Policy Product
    Its data type is CHAR (Character String) with field length 6
  • LRENEWAL : Last Renewal of Contract Before Claim Date/Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • POLOBJ_CD : ID of PM Insurance Object in CD
    Its data type is CHAR (Character String) with field length 20
  • BENEXCLPER : Benefit Exclusion Period
    Its data type is CHAR (Character String) with field length 1
  • POLICY_PM : Number of Policy in FS-PM
    Its data type is CHAR (Character String) with field length 17
  • POLEX_PM : External Policy
    Its data type is CHAR (Character String) with field length 17
  • POLICY_PM_TXT : Short Name of Policy
    Its data type is CHAR (Character String) with field length 50
  • CONTR_PM_TXT : Short Name of PM Contract
    Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • PROFILE_PR_LEVEL : Benefit Processing Profile at Product Level
    Its data type is CHAR (Character String) with field length 5
  • ASSIGN_GUID : GUID of Length 32
    Its data type is CHAR (Character String) with field length 32
  • CLAUSE : Information on Existence of Clauses in Policy Snapshot
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • POLPRODN : Name of Policy Product
    Its data type is CHAR (Character String) with field length 30
  • INSCOND_GEN : General Insurance Conditions
    Its data type is CHAR (Character String) with field length 10
  • INSCOND_GENN : Description of Insurance Conditions
    Its data type is CHAR (Character String) with field length 50
  • INSCOND_SPEC : Special Insurance Condition
    Its data type is CHAR (Character String) with field length 10
  • INSCOND_SPECN : Description of Insurance Conditions
    Its data type is CHAR (Character String) with field length 50
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GESNR : Business Partner of Company Code
    Its data type is CHAR (Character String) with field length 10
  • PLINEOFBUS : Insurance Line of Business
    Its data type is CHAR (Character String) with field length 3