1. Home
  2. Resources
  3. SAP Tables
  4. ICLPOLM - Coverage in Policy Snapshot

SAP Table ICLPOLM

Coverage in Policy Snapshot

ICLPOLM (Coverage in Policy Snapshot) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ICLPOLM to other SAP tables.

ICLPOLM table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ACTIVE Table entry is active (A) or in suspense (S) ICL_ACTIVE CHAR 1 0
A Table Entry Is Active
S Table Entry Is in Suspense
CLAIM Policy Snapshot for Claim ICL_CLAIM1 ICLCLAIM CHAR 17 0
POLVNR Counter of Contract Version ICL_POLVCNTR ICLPOL NUMC 2 0
COVERAGE Coverage ICL_POLM CHAR 4 0
CHANGETIME Changed: Date + Time ICL_CHANGEUTC1 DEC 15 0
CHANGEDBY Changed By ICL_CHANGEDBY USR02 CHAR 12 0
DELETED Database Line Status (Original, Changed, Deleted) ICL_RECSTATUS CHAR 1 0
O Original
C Changed
X Deleted
COVTYPE Coverage Type ICL_COVTYPE TICL322 CHAR 10 0
EXTCOV Extended Openable Coverage ICL_POLM1 CHAR 4 0
INCEPTION Coverage Inception Date ICL_INCEPTION1 DEC 15 0
EXPIRY Coverage End Date ICL_EXPIRY1 DEC 15 0
CEDED Reinsurance Type ICL_CEDED TICL095 CHAR 2 0
STATUS Coverage Status ICL_COVSTATUS CHAR 1 0
NULL Current
1 Waiting Period
2 Pending
AWPERIODEND End (Date and Time) of General Probationary Periods ICL_AWPERIODEND DEC 15 0
BWPERIODEND End (Date and Time) of Special Probationary Periods ICL_BWPERIODEND DEC 15 0
SERVCATID ID of a Benefits, Services and Fees Catalog ICL_SERVCATID CHAR 10 0
PROFILE_EP_LEVEL Benefit Processing Profile at Elementary Product Level ICL_PROFILE_EP_LEVEL_D CHAR 5 0
ASSIGN_GUID GUID of Length 32 ICL_GUID32 CHAR 32 0
COVTYPEN Name of Coverage Type ICL_COVTYPEN CHAR 50 0
COVERAGEN Name of Coverage ICL_COVERAGEN_D CHAR 50 0
BRCHNR Class of Business ICL_BRCHNR_D CHAR 24 0
RICOV_GD RI GUID of Coverage ICL_RICOVGD_D CHAR 22 0
CAPPENSOPT Lump Sum or Annuity Option ICL_CAPPENSOPT_D CHAR 3 0
01 No Option
02 Annuity Option Agreed
03 Annuity Option Exercised
04 Lump Sum Option Agreed
05 Lump Sum Option Exercised
GUROP Guaranteed Option for Payout/Extension ICL_GUROP_D CHAR 3 0
COVPAC_EXT_ID External Contract Package Key ICL_COVPAC_EXT_ID_D CHAR 5 0
COVERAGE_EXT_ID External FS-PM Coverage Key ICL_COVERAGE_EXT_ID_D CHAR 5 0
MONETARYCOMP Minimum Value of Monetary Compensation Reached ICL_MONETARYCOMP_D CHAR 1 0
PAYROLLVAR Settlement Variant for Annuity Disbursement ICL_PAYROLLVAR_D NUMC 3 0
001 Synchronous (Proportional Benefit)
002 Asynchronous (Full Benefit)
DISBURSETYPE Disbursement Category for Annuity Disbursement ICL_DISBURSETYPE_D NUMC 3 0
001 At Start of Period
002 At End of Period
COVERAGENR_TT Unique Coverage Number ICL_COVERAGENR_TT_D CHAR 17 0

ICLPOLM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ICLPOLM CEDED ICLPOLM CLIENT TICL095 Reinsurance Type CLIENT
ICLPOLM CEDED ICLPOLM CEDED TICL095 Reinsurance Type CEDED
ICLPOLM CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLPOLM CHANGEDBY ICLPOLM CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLPOLM CLAIM ICLPOLM CLIENT ICLCLAIM Claim CLIENT
ICLPOLM CLAIM ICLPOLM ACTIVE ICLCLAIM Claim ACTIVE
ICLPOLM CLAIM ICLPOLM CLAIM ICLCLAIM Claim CLAIM
ICLPOLM CLIENT ICLPOLM CLIENT T000 Clients MANDT
ICLPOLM COVTYPE ICLPOLM COVTYPE TICL322 Coverage Type COVTYPE
ICLPOLM COVTYPE ICLPOLM CLIENT TICL322 Coverage Type CLIENT
ICLPOLM POLVNR ICLPOLM POLVNR ICLPOL Policy Snapshot POLVNR
ICLPOLM POLVNR ICLPOLM CLIENT ICLPOL Policy Snapshot CLIENT
ICLPOLM POLVNR ICLPOLM ACTIVE ICLPOL Policy Snapshot ACTIVE
ICLPOLM POLVNR ICLPOLM CLAIM ICLPOL Policy Snapshot CLAIM