SAP ABAP Table M_TICL167 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_TICL167	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	BENTREEN	☐	ICL_BENTREEN	TEXT30	CHAR	30	0	Name of Benefit Type Tree
7	BENTREEGN	☐	ICL_BENTREEGN	TEXT50	CHAR	50	0	Name of Generation of Benefit Type Tree
8	VERNAME	☐	ICL_BENTREEVN	TEXT50	CHAR	50	0	Name of Version of Benefit Type Tree
9	ENTRYEXPRESSION	☐	ICL_ENTRY_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Entry Value	TBRF150
10	INSURED_SUM	☐	ICL_POLB07	ICL_ITAMT	CURR	15	2	Sum Insured
11	SUMEXPRESSION	☐	ICL_SUM_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Sum Insured	TBRF150
12	MINSUM	☐	ICL_POLB09	ICL_ITAMT	CURR	15	2	Minimum Sum Insured
13	MINEXPRESSION	☐	ICL_MIN_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating the Minimum of Sum Insured	TBRF150
14	MAXSUM	☐	ICL_POLB08	ICL_ITAMT	CURR	15	2	Maximum Sum Insured
15	MAXEXPRESSION	☐	ICL_MAX_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Maximum of Sum Insured	TBRF150
16	CALCEXPRESSION	☐	ICL_CALC_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Payout Amount	TBRF150
17	CALCSHORT	☐	BRF_SHORT_TEXT	BRF_SHORT_TEXT	CHAR	80	0	BRF: General Short Text
18	RBENTYPE	☐	ICL_BENTYPE2	ICL_BENTYPE	CHAR	10	0	Benefit Type of Reference Benefit Type in Contract	TICL055
19	RBENTYPENAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
20	RCOVTYPE	☐	ICL_COVTYPE2	ICL_COVTYPE	CHAR	10	0	Coverage Type of Reference Coverage Type in Contract	TICL322
21	COVNAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
22	PERCENT	☐	ICL_REFSUMP	ICL_PERCENT	DEC	5	2	Reference Sum Insured in Percent
23	CURR	☐	ICL_BENTREE01	WAERS	CUKY	5	0	Currency for All Amount Fields of Benefit Type Tree	TCURC
24	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	M_TICL167	BENTREE	TICL160	BENTREE	KEY	1	CN
2	M_TICL167	BENTYPE	TICL162	BENTYPE	KEY	1	CN
3	M_TICL167	CALCEXPRESSION	TBRF150	EXPRESSION
4	M_TICL167	CLIENT	T000	MANDT	KEY	1	CN
5	M_TICL167	CURR	TCURC	WAERS
6	M_TICL167	ENTRYEXPRESSION	TBRF150	EXPRESSION
7	M_TICL167	GENERAT	TICL160	VERSION	KEY	1	CN
8	M_TICL167	MAXEXPRESSION	TBRF150	EXPRESSION
9	M_TICL167	MINEXPRESSION	TBRF150	EXPRESSION
10	M_TICL167	RBENTYPE	TICL055	BENTYPE	REF	C	CN
11	M_TICL167	RCOVTYPE	TICL322	COVTYPE	REF	C	CN
12	M_TICL167	SUMEXPRESSION	TBRF150	EXPRESSION
13	M_TICL167	VERSION	TICL161	VERSION	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in