SAP ABAP Table ICSPOLS (Sums Insured and Calculations in 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	ICSPOLS	Table Relationship Diagram
Short Description	Sums Insured and Calculations in 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	COVERAGE	☑	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
6	BENTYPE	☑	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
7	INSUREDOBJ	☑	ICL_INSOBJ	ICL_INSOBJ	NUMC	4	0	Insured Object Number	*
8	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Attributes of ICLPOLS
13	ENTRYEXPRESSION	☐	ICL_ENTRY_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Entry Value	TBRF150
14	INSURED_SUM	☐	ICL_POLB07	ICL_ITAMT	CURR	15	2	Sum Insured
15	XINSSUM	☐	ICL_XINSSUM	XFELD	CHAR	1	0	Read Sum Insured from Customizing if Amount = 0
16	SUMEXPRESSION	☐	ICL_SUM_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Sum Insured	TBRF150
17	MINSUM	☐	ICL_POLB09	ICL_ITAMT	CURR	15	2	Minimum Sum Insured
18	MINEXPRESSION	☐	ICL_MIN_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating the Minimum of Sum Insured	TBRF150
19	MAXSUM	☐	ICL_POLB08	ICL_ITAMT	CURR	15	2	Maximum Sum Insured
20	MAXEXPRESSION	☐	ICL_MAX_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Maximum of Sum Insured	TBRF150
21	CALCEXPRESSION	☐	ICL_CALC_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Payout Amount	TBRF150
22	XCALCEXP	☐	ICL_XCALCEXP	XFELD	CHAR	1	0	Read Calculation Rule from Customizing If Entry Is Empty
23	RBENTYPE	☐	ICL_BENTYPE2	ICL_BENTYPE	CHAR	10	0	Benefit Type of Reference Benefit Type in Contract	*
24	RCOVTYPE	☐	ICL_COVTYPE2	ICL_COVTYPE	CHAR	10	0	Coverage Type of Reference Coverage Type in Contract	*
25	PERCENT	☐	ICL_REFSUMP	ICL_PERCENT	DEC	5	2	Reference Sum Insured in Percent
26	SUMCALCORDER	☐	ICL_SUM_CALCULATION	ICL_SUM_EXPRESSION	CHAR	1	0	Calculation Rule for Sum Insured
27	ASSIGN_GUID	☐	ICL_GUID32	SYSUUID_C	CHAR	32	0	GUID of Length 32

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSPOLS	BENTYPE	TICL055	BENTYPE
2	ICSPOLS	CALCEXPRESSION	TBRF150	EXPRESSION
3	ICSPOLS	CHANGEDBY	USR02	BNAME
4	ICSPOLS	CLAIM	ICLCLAIM	CLAIM
5	ICSPOLS	CLIENT	T000	MANDT
6	ICSPOLS	ENTRYEXPRESSION	TBRF150	EXPRESSION
7	ICSPOLS	MAXEXPRESSION	TBRF150	EXPRESSION
8	ICSPOLS	MINEXPRESSION	TBRF150	EXPRESSION
9	ICSPOLS	SUMEXPRESSION	TBRF150	EXPRESSION

History

Last changed by/on	SAP	20110901
SAP Release Created in	473