SAP ABAP Table CMS_STR_LIF_INS_MAP_CRT (Life insurance data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RIG (Application Component) Rights
     ⤷ CMS_OMS_RIG (Package) Collateral Management Rights

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_LIF_INS_MAP_CRT	Table Relationship Diagram
Short Description	Life insurance data

Delivery and Maintenance

Pool/cluster
Delivery Class
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	INS_ID	☐	CMS_DTE_INS_ID	CMS_MOV_ID	CHAR	40	0	Insurance ID
2	INS_DESC	☐	CMS_DTE_INS_DESC	CMS_INS_DESC	CHAR	30	0	Insurance Description
3	INSUR_TAX_DB	☐	CMS_DTE_INS_TAX_DB	CMS_INS_FLG	CHAR	1	0	Insurance tax to the debit of the bank
4	SETLMNT_TYPE	☐	CMS_DTE_INS_SETLMNT_TYPE	CMS_ATT_ID_TYP	CHAR	6	0	Type of settlement
5	PRM_RT	☐	CMS_DTE_INS_PRM_RT	CMS_INS_PRM_RT	DEC	10	7	Premium Rate
6	INSUR_PREMIUM	☐	CMS_DTE_INS_PRM	CMS_AMOUNT	CURR	17	2	Insurance Premium
7	INSUR_PRM_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	*
8	INSUR_TAX_RT	☐	CMS_DTE_INS_TAX_RT	CMS_INS_PRM_RT	DEC	10	7	Insurance tax rate (in %)
9	INSUR_TAX_AMT	☐	CMS_DTE_INS_TAX_AMT	CMS_AMOUNT	CURR	17	2	Insurance tax amount
10	INSUR_TAX_CURR	☐	CMS_DTE_INS_TAX_CURR	WAERS	CUKY	5	0	Tax Currency	*
11	SCOPE_INS_COVER	☐	CMS_DTE_INS_COVER	CMS_INS_COVER	CHAR	6	0	not used -> package has to be changed CMS_OMS_INS
12	EXT_ITM_NO	☐	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
13	EXT_REFERENCE	☐	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
14	TARRIF	☐	CMS_DTE_INS_TARRIF	CMS_INS_TARRIF	CHAR	30	0	Insurance tariff
15	CONTRACT_STRT_DT	☐	CMS_DTE_INS_CNTRT_STRT_DT	DATUM	DATS	8	0	Contract begin date
16	CONTRACT_END_DT	☐	CMS_DTE_INS_CNTRT_END_DT	DATUM	DATS	8	0	Contract end date
17	CONTRACT_CON_DT	☐	CMS_DTE_INS_CNTRT_CON_DT	DATUM	DATS	8	0	Date of conclusion of contract
18	INSUR_STATUS	☐	CMS_DTE_INS_STATUS	CMS_ATT_ID_TYP	CHAR	6	0	Status of insurance
19	INSUR_STATUS_DT	☐	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
20	FOP	☐	CMS_DTE_INS_FOP	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Frequency of Payment
21	FREQ_UNIT	☐	CMS_DTE_INS_FREQ_UNIT	CMS_INS_IND_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation
22	SUM_ONE_TM_CON	☐	CMS_DTE_INS_SUM_ONE_TM_CON	CMS_AMOUNT	CURR	17	2	Sum of one time contribution
23	ONE_TM_CON_CKY	☐	CMS_DTE_INS_ONE_TM_CON_CKY	WAERS	CUKY	5	0	Currency	TCURC
24	DYNAMICS	☐	CMS_DTE_INS_DYNAMICS	CMS_INS_FLG	CHAR	1	0	Dynamics
25	PER_DYNAMICS	☐	CMS_DTE_INS_PER_DYNAMICS	CMS_SEC_PCT	DEC	10	6	Percentage of the dynamics
26	TERMIN_PRD	☐	CMS_DTE_INS_TERMIN_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Termination period
27	TERM_PRD_UNIT	☐	CMS_DTE_INS_TERM_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of termination period
28	RECALL_PRD	☐	CMS_DTE_INS_RECALL_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Recall period
29	RECALL_PRD_UNIT	☐	CMS_DTE_INS_RECALL_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of Recall Period
30	INS_SUM_SRVL	☐	CMS_DTE_INS_SUM_IN_SURVIVAL	CMS_AMOUNT	CURR	17	2	Insurance sum incase of survival
31	INS_SUM_SRVL_CKY	☐	CMS_DTE_INS_SUM_IN_SURVIVL_CKY	WAERS	CUKY	5	0	Insurance survival Currency	TCURC
32	INS_SUM_DTH	☐	CMS_DTE_INS_SUM_IN_DEATH	CMS_AMOUNT	CURR	17	2	Insurance sum in case of death
33	INS_SUM_DTH_CKY	☐	CMS_DTE_INS_SUM_IN_DEATH_CKY	WAERS	CUKY	5	0	Death benefit currency	TCURC
34	INS_BENF_EXP	☐	CMS_DTE_INS_PROB_BENF	CMS_AMOUNT	CURR	17	2	Probable benefit on expiry
35	INS_BENF_EXP_CKY	☐	CMS_DTE_INS_PROB_BENF_CKY	WAERS	CUKY	5	0	Currency for probable benefit on expiry	TCURC
36	DT_PROB_BEN_EXP	☐	CMS_DTE_INS_DT_PRO_BEN_EXP	DATUM	DATS	8	0	Date of probable benefit on expiry
37	INSUR_SUM	☐	CMS_DTE_INS_SUM	CMS_AMOUNT	CURR	17	2	Insurance Sum
38	INSUR_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_LIF_INS_MAP_CRT	INS_BENF_EXP_CKY	TCURC	WAERS	REF	1	CN
2	CMS_STR_LIF_INS_MAP_CRT	INS_SUM_DTH_CKY	TCURC	WAERS	REF	1	CN
3	CMS_STR_LIF_INS_MAP_CRT	INS_SUM_SRVL_CKY	TCURC	WAERS	REF	1	CN
4	CMS_STR_LIF_INS_MAP_CRT	ONE_TM_CON_CKY	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20060313
SAP Release Created in	500