SAP ABAP Table V_CLI_INSUR (Generated Table for View)

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in