1. Home
  2. Resources
  3. SAP Tables
  4. ICLPOL - Policy Snapshot

SAP Table ICLPOL

Policy Snapshot

ICLPOL (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 ICLPOL to other SAP tables.

ICLPOL 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 NUMC 2 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
IMPORTSTATUS Import Status of Policy Snapshot ICL_POLIMPSTAT CHAR 1 0
NULL No import
N Contract Not Found
F Import Error
S Contract Imported
VALIDDATA Overview of Data in Policy Snapshot ICL_POLVALIDDATA CHAR 1 0
NULL No Data
F Data Contains Errors
P Data Contains Gaps
D Default Data
C All Data
H Only Header File (Contract Data Not Saved)
MANCHANGE Policy Snapshot Changed Manually ICL_POLMANCHNG CHAR 1 0
X TRUE
NULL FALSE
VALIDFROM Contract Version: Valid-From Date ICL_POL01 DEC 15 0
VALIDTO Contract Version: Valid To Date ICL_POL02 DEC 15 0
SRCCHANGE Date and Time of Version Change in Policy System ICL_POL03 DEC 15 0
ISSUED Date of Issue ICL_ISSUED DEC 15 0
INCEPTION Inception of Contract ICL_INCEPTION DEC 15 0
EXPIRY End Date and Time of Contract ICL_EXPIRY DEC 15 0
CURR Currency of Limit and Deductible ICL_POLB01 TCURC CUKY 5 0
JURISCOUNTRY Jurisdiction Country ICL_JURICOUNTRY T005 CHAR 3 0
JURISREGION Jurisdiction Region ICL_JURISREGION T005S CHAR 3 0
NCBONUS Claim-Free Discount ICL_NCBONUS NUMC 3 0
DISTCHAN Insurance Distribution Channel ICL_DISTCHAN TICL500 CHAR 1 0
POLICY Contract Number ICL_POLICY CHAR 17 0
POLPROD Policy Product ICL_POLPROD TICL320 CHAR 6 0
LRENEWAL Last Renewal of Contract Before Claim Date/Time ICL_LRENEWAL DEC 15 0
POLOBJ_CD ID of PM Insurance Object in CD ICL_POLOBJ_CD CHAR 20 0
BENEXCLPER Benefit Exclusion Period ICL_BENEXCLPER CHAR 1 0
NULL No
X Yes
POLICY_PM Number of Policy in FS-PM ICL_PMI_POLEX CHAR 17 0
POLEX_PM External Policy ICL_POLEX_PM CHAR 17 0
POLICY_PM_TXT Short Name of Policy ICL_POLICY_PM_TXT CHAR 50 0
CONTR_PM_TXT Short Name of PM Contract ICL_CONTR_PM_TXT CHAR 50 0
PROFILE_PR_LEVEL Benefit Processing Profile at Product Level ICL_PROFILE_PR_LEVEL_D CHAR 5 0
ASSIGN_GUID GUID of Length 32 ICL_GUID32 CHAR 32 0
CLAUSE Information on Existence of Clauses in Policy Snapshot ICL_CLAUSE_INFO_D NUMC 1 0
0 No Clauses
1 Only Standard Clauses
2 Clauses Differing From Standard
POLPRODN Name of Policy Product ICL_POLPRODN CHAR 30 0
INSCOND_GEN General Insurance Conditions ICL_CONDGEN_D CHAR 10 0
INSCOND_GENN Description of Insurance Conditions ICL_CONDTEXT_D CHAR 50 0
INSCOND_SPEC Special Insurance Condition ICL_CONDSPEC_D CHAR 10 0
INSCOND_SPECN Description of Insurance Conditions ICL_CONDTEXT_D CHAR 50 0
BUKRS Company Code BUKRS CHAR 4 0
GESNR Business Partner of Company Code ICL_GESNR_D CHAR 10 0
PLINEOFBUS Insurance Line of Business ICL_LINEOFBUS CHAR 3 0
MAINMATUR_DT Main Due Date ICL_MAINMATUR_DT_D CHAR 4 0
DUEDATE Due Date ICL_DUEDATE_D DATS 8 0
REQUESTSTATUS Contract Request Status (Content: A = Request, P = Policy) ICL_REQUESTSTATUS_D CHAR 1 0
TEXT_LANGU Language Key of Policy Snapshot ICL_POL_TEXT_LANGU LANG 1 0

ICLPOL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ICLPOL CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLPOL CHANGEDBY ICLPOL CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLPOL CLAIM ICLPOL CLIENT ICLCLAIM Claim CLIENT
ICLPOL CLAIM 'A' ICLCLAIM Claim ACTIVE
ICLPOL CLAIM ICLPOL CLAIM ICLCLAIM Claim CLAIM
ICLPOL CLIENT ICLPOL CLIENT T000 Clients MANDT
ICLPOL CURR ICLPOL CLIENT TCURC Currency Codes MANDT
ICLPOL CURR ICLPOL CURR TCURC Currency Codes WAERS
ICLPOL DISTCHAN ICLPOL CLIENT TICL500 Insurance Distribution Channel CLIENT
ICLPOL DISTCHAN ICLPOL DISTCHAN TICL500 Insurance Distribution Channel DISTCHAN
ICLPOL JURISCOUNTRY ICLPOL CLIENT T005 Countries MANDT
ICLPOL JURISCOUNTRY ICLPOL JURISCOUNTRY T005 Countries LAND1
ICLPOL JURISREGION ICLPOL JURISREGION T005S Taxes: Region (Province) Key BLAND
ICLPOL JURISREGION ICLPOL CLIENT T005S Taxes: Region (Province) Key MANDT
ICLPOL JURISREGION ICLPOL JURISCOUNTRY T005S Taxes: Region (Province) Key LAND1
ICLPOL POLPROD SYST MANDT TICL320 Policy Product Generation CLIENT
ICLPOL POLPROD ICLPOL POLPROD TICL320 Policy Product Generation POLPROD
ICLPOL POLPROD * TICL320 Policy Product Generation VERSION