SAP ABAP Table TICL167 (Benefit Type Tree: Sum Insured and Calculation Rules)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TICL167	Table Relationship Diagram
Short Description	Benefit Type Tree: Sum Insured and Calculation Rules

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	BENTREE	☑	ICL_BENTREE	ICL_BENTREE	CHAR	8	0	Benefit Type Tree	TICL160
3	GENERAT	☑	ICL_BENTREEG	ICL_BENTREEG	NUMC	5	0	Generation of Benefit Type Tree	TICL160
4	VERSION	☑	ICL_BENTREEV	ICL_BENTREEV	NUMC	5	0	Version of Benefit Type Tree	TICL161
5	BENTYPE	☑	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL162
6	ENTRYEXPRESSION	☐	ICL_ENTRY_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Entry Value	TBRF150
7	INSURED_SUM	☐	ICL_POLB07	ICL_ITAMT	CURR	15	2	Sum Insured
8	SUMEXPRESSION	☐	ICL_SUM_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Sum Insured	TBRF150
9	MINSUM	☐	ICL_POLB09	ICL_ITAMT	CURR	15	2	Minimum Sum Insured
10	MINEXPRESSION	☐	ICL_MIN_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating the Minimum of Sum Insured	TBRF150
11	MAXSUM	☐	ICL_POLB08	ICL_ITAMT	CURR	15	2	Maximum Sum Insured
12	MAXEXPRESSION	☐	ICL_MAX_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Maximum of Sum Insured	TBRF150
13	CALCEXPRESSION	☐	ICL_CALC_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Payout Amount	TBRF150
14	RBENTYPE	☐	ICL_BENTYPE2	ICL_BENTYPE	CHAR	10	0	Benefit Type of Reference Benefit Type in Contract	TICL055
15	RCOVTYPE	☐	ICL_COVTYPE2	ICL_COVTYPE	CHAR	10	0	Coverage Type of Reference Coverage Type in Contract	TICL322
16	PERCENT	☐	ICL_REFSUMP	ICL_PERCENT	DEC	5	2	Reference Sum Insured in Percent
17	SUMCALCORDER	☐	ICL_SUM_CALCULATION	ICL_SUM_EXPRESSION	CHAR	1	0	Calculation Rule for Sum Insured

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TICL167	BENTREE	TICL160	BENTREE	KEY	1	CN
2	TICL167	BENTYPE	TICL162	BENTYPE	KEY	1	CN
3	TICL167	CALCEXPRESSION	TBRF150	EXPRESSION
4	TICL167	CLIENT	T000	MANDT	KEY	1	CN
5	TICL167	ENTRYEXPRESSION	TBRF150	EXPRESSION
6	TICL167	GENERAT	TICL160	VERSION	KEY	1	CN
7	TICL167	MAXEXPRESSION	TBRF150	EXPRESSION
8	TICL167	MINEXPRESSION	TBRF150	EXPRESSION
9	TICL167	RBENTYPE	TICL055	BENTYPE	REF	C	CN
10	TICL167	RCOVTYPE	TICL322	COVTYPE	REF	C	CN
11	TICL167	SUMEXPRESSION	TBRF150	EXPRESSION
12	TICL167	VERSION	TICL161	VERSION	KEY	1	CN

History

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