SAP ABAP Table ICSPOL (Policy Snapshot)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_POLICY (Package) Policy Snapshot and Interface to Policy

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSPOL	Table Relationship Diagram
Short Description	Policy Snapshot

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☑	ICL_CLAIM1	ICL_CLAIM	CHAR	17	0	Policy Snapshot for Claim	ICLCLAIM
4	POLVNR	☑	ICL_POLVCNTR	ICL_POLVCNTR	NUMC	2	0	Counter of Contract Version	*
5	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
7	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
8	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
9	.INCLUDE	☐				0	0	Attributes of ICLPOL
10	IMPORTSTATUS	☐	ICL_POLIMPSTAT	ICL_POLIMPSTAT	CHAR	1	0	Import Status of Policy Snapshot
11	VALIDDATA	☐	ICL_POLVALIDDATA	ICL_POLVALIDDATA	CHAR	1	0	Overview of Data in Policy Snapshot
12	MANCHANGE	☐	ICL_POLMANCHNG	BOOLE	CHAR	1	0	Policy Snapshot Changed Manually
13	VALIDFROM	☐	ICL_POL01	ICL_TIMESTAMP	DEC	15	0	Contract Version: Valid-From Date
14	VALIDTO	☐	ICL_POL02	ICL_TIMESTAMP	DEC	15	0	Contract Version: Valid To Date
15	SRCCHANGE	☐	ICL_POL03	ICL_TIMESTAMP	DEC	15	0	UTC Date and Time of Version Change in Policy System
16	ISSUED	☐	ICL_ISSUED	ICL_TIMESTAMP	DEC	15	0	Date of Issue
17	INCEPTION	☐	ICL_INCEPTION	ICL_TIMESTAMP	DEC	15	0	Inception of Contract
18	EXPIRY	☐	ICL_EXPIRY	ICL_TIMESTAMP	DEC	15	0	End Date and Time of Contract
19	CURR	☐	ICL_POLB01	WAERS	CUKY	5	0	Currency of Limit and Deductible	TCURC
20	JURISCOUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	*
21	JURISREGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	*
22	NCBONUS	☐	ICL_NCBONUS	ICL_NCBONUS1	NUMC	3	0	Claim-Free Discount
23	DISTCHAN	☐	ICL_DISTCHAN	ICL_DISTCHAN	CHAR	1	0	Insurance Distribution Channel	TICL500
24	POLICY	☐	ICL_POLICY	ICL_POLICY	CHAR	17	0	Contract Number
25	POLPROD	☐	ICL_POLPROD	ICL_POLPROD	CHAR	6	0	Policy Product	TICL320
26	LRENEWAL	☐	ICL_LRENEWAL	ICL_TIMESTAMP	DEC	15	0	Last Renewal of Contract Before Claim Date/Time
27	POLOBJ_CD	☐	ICL_POLOBJ_CD	INSOBJECT_MD	CHAR	20	0	ID of PM Insurance Object in CD	*
28	BENEXCLPER	☐	ICL_BENEXCLPER	ICL_BENEXCLPER	CHAR	1	0	Benefit Exclusion Period
29	POLICY_PM	☐	ICL_PMI_POLEX	ICL_POLICY	CHAR	17	0	Number of Policy in FS-PM
30	POLEX_PM	☐	ICL_POLEX_PM	ICL_POLICY	CHAR	17	0	External Policy
31	POLICY_PM_TXT	☐	ICL_POLICY_PM_TXT	ICL_PMI_POLICY_PM_TXT	CHAR	50	0	Short Name of Policy
32	CONTR_PM_TXT	☐	ICL_CONTR_PM_TXT	ICL_PMI_CONTR_PM_TXT	CHAR	50	0	Short Name of PM Contract
33	.INCLUDE	☐				0	0
34	PROFILE_PR_LEVEL	☐	ICL_PROFILE_PR_LEVEL_D	ICL_PROFILE_PR_LEVEL	CHAR	5	0	Benefit Processing Profile at Product Level	*
35	ASSIGN_GUID	☐	ICL_GUID32	SYSUUID_C	CHAR	32	0	GUID of Length 32
36	CLAUSE	☐	ICL_CLAUSE_INFO_D	ICL_CLAUSE_INFO	NUMC	1	0	Information on Existence of Clauses in Policy Snapshot
37	POLPRODN	☐	ICL_POLPRODN	TEXT30	CHAR	30	0	Name of Policy Product
38	INSCOND_GEN	☐	ICL_CONDGEN_D		CHAR	10	0	General Insurance Conditions
39	INSCOND_GENN	☐	ICL_CONDTEXT_D		CHAR	50	0	Description of Insurance Conditions
40	INSCOND_SPEC	☐	ICL_CONDSPEC_D		CHAR	10	0	Special Insurance Condition
41	INSCOND_SPECN	☐	ICL_CONDTEXT_D		CHAR	50	0	Description of Insurance Conditions
42	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
43	GESNR	☐	ICL_GESNR_D	BU_PARTNER	CHAR	10	0	Business Partner of Company Code	*
44	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSPOL	CHANGEDBY	USR02	BNAME
2	ICSPOL	CLAIM	ICLCLAIM	CLAIM
3	ICSPOL	CLIENT	T000	MANDT
4	ICSPOL	CURR	TCURC	WAERS
5	ICSPOL	DISTCHAN	TICL500	DISTCHAN
6	ICSPOL	POLPROD	TICL320	POLPROD

History

Last changed by/on	SAP	20110901
SAP Release Created in