SAP ABAP Table TDCLI_INSURANCE (Table of Credit Life Insurance Rates)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-BD-MD (Application Component) Master Data
     ⤷ FVVCL_KLV (Package) Credit Life Insurance

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TDCLI_INSURANCE	Table Relationship Diagram
Short Description	Table of Credit Life Insurance Rates

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EXTERNAL_ID	☑	TB_CLI_EXTERNAL_RATE	CHAR08	CHAR	8	0	Key for Insurance Rate
3	.INCLUDE	☐				0	0	Data Record Structure of Table for CLI Rates
4	PARTNER	☐	TB_CLI_INSURANCE_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number for Insurance Company	BUT000
5	RATE	☐	TB_CLI_INSURENCE_RATE	T_CLI_INSURANCE_RATE	CHAR	10	0	Key for Rate at Insurance Company
6	VERSION	☐	TB_CLI_INSURANCE_VERSION	T_CLI_INSURANCE_VERSION	NUMC	3	0	Sequential Version Number for Insurance Rate
7	DESCRIPTION	☐	TB_CLI_DESCRIPTION	T_CLI_UPPER_LOWER_CASE	CHAR	30	0	Description for Insurance Rate
8	DATE_FROM	☐	TB_CLI_DATE_FROM	DATUM	DATS	8	0	Insurance Rate Valid from
9	DATE_TO	☐	TB_CLI_DATE_TO	DATUM	DATS	8	0	Insurance Rate Valid to
10	RISK	☐	TB_CLI_RISK	T_CLI_RISK	CHAR	8	0	Risks to Be Covered by This Rate
11	INS_COMP	☐	TB_CLI_INSURANCE_COMPANY	T_CLI_UPPER_LOWER_CASE	CHAR	30	0	Name of Insurance Company
12	MAX_SUM_INS	☐	TB_CLI_MAX_SUM_INSURED	WERTV8	CURR	15	2	Credit Life Insurance - Maximum Insured Amount
13	CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
14	MAX_RUNTIME	☐	TB_CLI_MAX_RUNTIME	NUM03	NUMC	3	0	Maximum Term for Credit Life Insurance in Months
15	MIN_AGE_FROM	☐	TB_CLI_MIN_FROM_AGE	NUM02	NUMC	2	0	Minimum Entry Age for Credit Life Insurance
16	MAX_AGE_FROM	☐	TB_CLI_MAX_FROM_AGE	NUM02	NUMC	2	0	Maximum Entry Age for Credit Life Insurance
17	MAX_AGE_TO	☐	TB_CLI_MAX_TO_AGE	NUM02	NUMC	2	0	Maximum Age at End of Term for Credit Life Insurance
18	NOT_PER	☐	TB_CLI_NOTICE_PERIOD	NUM1	NUMC	1	0	Notice Period for Credit Life Insurance in Weeks
19	LIMIT_CANC_ORDER	☐	TB_CLI_TIME_CANCELLED_OF_ORDER	NUM01	NUMC	1	0	Rescission Period for Credit Life Insurance in Weeks
20	OCCUPATION	☐	TB_CLI_OCCUPATION_REQUIRED	T_CLI_BOOLE	CHAR	1	0	Occupational Group Required
21	POLICYHOLDER	☐	TB_CLI_TARIFF_FOR_POLICYHOLDER	T_CLI_BOOLE	CHAR	1	0	Rate for Policyholder

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TDCLI_INSURANCE	MANDT	T000	MANDT	KEY	1	CN
2	TDCLI_INSURANCE	PARTNER	BUT000	PARTNER

History

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