ICSPOL - Policy Snapshot

Policy Snapshot information is stored in SAP table ICSPOL.
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 ICSPOL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
ACTIVE	Table entry is active (A) or in suspense (S)	X	ICL_ACTIVE	CHAR	2
CLAIM	Policy Snapshot for Claim	X	ICL_CLAIM1	CHAR	34	ICLCLAIM
POLVNR	Counter of Contract Version	X	ICL_POLVCNTR	NUMC	4
CHANGETIME	Changed: Date + Time	X	ICL_CHANGEUTC1	DEC	8
.INCLUDE				ICL_INCL_VER6	0
CHANGEDBY	Changed By		ICL_CHANGEDBY	CHAR	24	USR02
DELETED	Database Line Status (Original, Changed, Deleted)		ICL_RECSTATUS	CHAR	2
.INCLUDE				ICS_POL	0
IMPORTSTATUS	Import Status of Policy Snapshot		ICL_POLIMPSTAT	CHAR	2
VALIDDATA	Overview of Data in Policy Snapshot		ICL_POLVALIDDATA	CHAR	2
MANCHANGE	Policy Snapshot Changed Manually		ICL_POLMANCHNG	CHAR	2
VALIDFROM	Contract Version: Valid-From Date		ICL_POL01	DEC	8
VALIDTO	Contract Version: Valid To Date		ICL_POL02	DEC	8
SRCCHANGE	Date and Time of Version Change in Policy System		ICL_POL03	DEC	8
ISSUED	Date of Issue		ICL_ISSUED	DEC	8
INCEPTION	Inception of Contract		ICL_INCEPTION	DEC	8
EXPIRY	End Date and Time of Contract		ICL_EXPIRY	DEC	8
CURR	Currency of Limit and Deductible		ICL_POLB01	CUKY	10	TCURC
JURISCOUNTRY	Country/Region of Jurisdiction		ICL_JURICOUNTRY	CHAR	6	*
JURISREGION	Jurisdiction Region		ICL_JURISREGION	CHAR	6	*
NCBONUS	Claim-Free Discount		ICL_NCBONUS	NUMC	6
DISTCHAN	Insurance Distribution Channel		ICL_DISTCHAN	CHAR	2	TICL500
POLICY	Contract Number		ICL_POLICY	CHAR	34
POLPROD	Policy Product		ICL_POLPROD	CHAR	12	TICL320
LRENEWAL	Last Renewal of Contract Before Claim Date/Time		ICL_LRENEWAL	DEC	8
POLOBJ_CD	ID of PM Insurance Object in CD		ICL_POLOBJ_CD	CHAR	40	*
BENEXCLPER	Benefit Exclusion Period		ICL_BENEXCLPER	CHAR	2
POLICY_PM	Number of Policy in FS-PM		ICL_PMI_POLEX	CHAR	34
POLEX_PM	External Policy		ICL_POLEX_PM	CHAR	34
POLICY_PM_TXT	Short Name of Policy		ICL_POLICY_PM_TXT	CHAR	100
CONTR_PM_TXT	Short Name of PM Contract		ICL_CONTR_PM_TXT	CHAR	100
.INCLUDE				CI_ICS_POL	0
PROFILE_PR_LEVEL	Benefit Processing Profile at Product Level		ICL_PROFILE_PR_LEVEL_D	CHAR	10
ASSIGN_GUID	GUID of Length 32		ICL_GUID32	CHAR	64
CLAUSE	Information on Existence of Clauses in Policy Snapshot		ICL_CLAUSE_INFO_D	NUMC	2
POLPRODN	Name of Policy Product		ICL_POLPRODN	CHAR	60
INSCOND_GEN	General Insurance Conditions		ICL_CONDGEN_D	CHAR	20
INSCOND_GENN	Description of Insurance Conditions		ICL_CONDTEXT_D	CHAR	100
INSCOND_SPEC	Special Insurance Condition		ICL_CONDSPEC_D	CHAR	20
INSCOND_SPECN	Description of Insurance Conditions		ICL_CONDTEXT_D	CHAR	100
BUKRS	Company Code		BUKRS	CHAR	8
GESNR	Business Partner of Company Code		ICL_GESNR_D	CHAR	20	*
PLINEOFBUS	Insurance Line of Business		ICL_LINEOFBUS	CHAR	6	*
.INCLUDE				ICL_POL_AS_DB	0
MAINMATUR_DT	Main Due Date		ICL_MAINMATUR_DT_D	CHAR	8
DUEDATE	Due Date		ICL_DUEDATE_D	DATS	16
REQUESTSTATUS	Contract Request Status (Content: A = Request, P = Policy)		ICL_REQUESTSTATUS_D	CHAR	2
TEXT_LANGU	Language Key of Policy Snapshot		ICL_POL_TEXT_LANGU	LANG	2	*
MULTI_CURRENCY_CATEGORY	Multi-Currency Category		ICL_MULTI_CURRENCY_CAT	INT1	1
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16