ICLPOL - Policy Snapshot

Policy Snapshot information is stored in SAP table ICLPOL.
It is part of development package ICL_POLICY in software component FS-CM. This development package consists of objects that can be grouped under "Policy Snapshot and Interface to Policy".

Fields for table ICLPOL

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
ACTIVETable entry is active (A) or in suspense (S)XICL_ACTIVECHAR2
CLAIMPolicy Snapshot for ClaimXICL_CLAIM1CHAR34ICLCLAIM
POLVNRCounter of Contract VersionXICL_POLVCNTRNUMC4
.INCLUDEICL_INCL_VER50
CHANGETIMEChanged: Date + TimeICL_CHANGEUTC1DEC8
CHANGEDBYChanged ByICL_CHANGEDBYCHAR24USR02
DELETEDDatabase Line Status (Original, Changed, Deleted)ICL_RECSTATUSCHAR2
.INCLUDEICS_POL0
IMPORTSTATUSImport Status of Policy SnapshotICL_POLIMPSTATCHAR2
VALIDDATAOverview of Data in Policy SnapshotICL_POLVALIDDATACHAR2
MANCHANGEPolicy Snapshot Changed ManuallyICL_POLMANCHNGCHAR2
VALIDFROMContract Version: Valid-From DateICL_POL01DEC8
VALIDTOContract Version: Valid To DateICL_POL02DEC8
SRCCHANGEDate and Time of Version Change in Policy SystemICL_POL03DEC8
ISSUEDDate of IssueICL_ISSUEDDEC8
INCEPTIONInception of ContractICL_INCEPTIONDEC8
EXPIRYEnd Date and Time of ContractICL_EXPIRYDEC8
CURRCurrency of Limit and DeductibleICL_POLB01CUKY10TCURC
JURISCOUNTRYCountry/Region of JurisdictionICL_JURICOUNTRYCHAR6T005
JURISREGIONJurisdiction RegionICL_JURISREGIONCHAR6T005S
NCBONUSClaim-Free DiscountICL_NCBONUSNUMC6
DISTCHANInsurance Distribution ChannelICL_DISTCHANCHAR2TICL500
POLICYContract NumberICL_POLICYCHAR34
POLPRODPolicy ProductICL_POLPRODCHAR12TICL320
LRENEWALLast Renewal of Contract Before Claim Date/TimeICL_LRENEWALDEC8
POLOBJ_CDID of PM Insurance Object in CDICL_POLOBJ_CDCHAR40*
BENEXCLPERBenefit Exclusion PeriodICL_BENEXCLPERCHAR2
POLICY_PMNumber of Policy in FS-PMICL_PMI_POLEXCHAR34
POLEX_PMExternal PolicyICL_POLEX_PMCHAR34
POLICY_PM_TXTShort Name of PolicyICL_POLICY_PM_TXTCHAR100
CONTR_PM_TXTShort Name of PM ContractICL_CONTR_PM_TXTCHAR100
.INCLUDECI_ICS_POL0
PROFILE_PR_LEVELBenefit Processing Profile at Product LevelICL_PROFILE_PR_LEVEL_DCHAR10
ASSIGN_GUIDGUID of Length 32ICL_GUID32CHAR64
CLAUSEInformation on Existence of Clauses in Policy SnapshotICL_CLAUSE_INFO_DNUMC2
POLPRODNName of Policy ProductICL_POLPRODNCHAR60
INSCOND_GENGeneral Insurance ConditionsICL_CONDGEN_DCHAR20
INSCOND_GENNDescription of Insurance ConditionsICL_CONDTEXT_DCHAR100
INSCOND_SPECSpecial Insurance ConditionICL_CONDSPEC_DCHAR20
INSCOND_SPECNDescription of Insurance ConditionsICL_CONDTEXT_DCHAR100
BUKRSCompany CodeBUKRSCHAR8
GESNRBusiness Partner of Company CodeICL_GESNR_DCHAR20*
PLINEOFBUSInsurance Line of BusinessICL_LINEOFBUSCHAR6*
.INCLUDEICL_POL_AS_DB0
MAINMATUR_DTMain Due DateICL_MAINMATUR_DT_DCHAR8
DUEDATEDue DateICL_DUEDATE_DDATS16
REQUESTSTATUSContract Request Status (Content: A = Request, P = Policy)ICL_REQUESTSTATUS_DCHAR2
TEXT_LANGULanguage Key of Policy SnapshotICL_POL_TEXT_LANGULANG2*
MULTI_CURRENCY_CATEGORYMulti-Currency CategoryICL_MULTI_CURRENCY_CATINT11
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy