SAP ABAP Table CMS_STR_INS_MAP (All insurance properties exposed to other systems)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RIG (Application Component) Rights
     ⤷ CMS_INS_SERVICE (Package) CMS: Insurance Service

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_INS_MAP	Table Relationship Diagram
Short Description	All insurance properties exposed to other systems

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_GUID	☐	CMS_DTE_INS_GUID	SYSUUID	RAW	16	0	Insurance GUID
2	INS_TYP	☐	CMS_DTE_INS_TYPE	CMS_MOV_TYP	CHAR	6	0	Insurance Type	*
3	INS_CODE	☐	CMS_DTE_INS_CODE	CMS_INS_CODE	CHAR	6	0	Insurance Product Code
4	INS_DESC	☐	CMS_DTE_INS_DESC	CMS_INS_DESC	CHAR	30	0	Insurance Description
5	INSUR_SUM	☐	CMS_DTE_INS_SUM	CMS_AMOUNT	CURR	17	2	Insurance Sum
6	INSUR_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
7	MAX_COVER_AMT	☐	CMS_DTE_INS_MAX_COVER_AMT	CMS_AMOUNT	CURR	17	2	Maximum Coverage Amount
8	MIN_COVER_AMT	☐	CMS_DTE_INS_MIN_COVER_AMT	CMS_AMOUNT	CURR	17	2	Minimum Coverage Amount
9	PRM_RT	☐	CMS_DTE_INS_PRM_RT	CMS_INS_PRM_RT	DEC	10	7	Premium Rate
10	INSUR_PREMIUM	☐	CMS_DTE_INS_PRM	CMS_AMOUNT	CURR	17	2	Insurance Premium
11	FOP	☐	CMS_DTE_INS_FOP	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Frequency of Payment
12	FREQ_UNIT	☐	CMS_DTE_INS_FREQ_UNIT	CMS_INS_IND_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation
13	POLICY_NUMBER	☐	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
14	CONTRACT_STRT_DT	☐	CMS_DTE_INS_CNTRT_STRT_DT	DATUM	DATS	8	0	Contract begin date
15	CONTRACT_END_DT	☐	CMS_DTE_INS_CNTRT_END_DT	DATUM	DATS	8	0	Contract end date
16	CONTRACT_CON_DT	☐	CMS_DTE_INS_CNTRT_CON_DT	DATUM	DATS	8	0	Date of conclusion of contract
17	AUTO_CANCEL_DT	☐	CMS_DTE_INS_AUTO_CANCEL_DT	CMS_DATE	DATS	8	0	Auto Cancellation Date for an Insurance Policy
18	POLICY_STATUS	☐	CMS_DTE_INS_POLICY_STATUS	CMS_INS_POLICY_STATUS	CHAR	2	0	Insurance Policy Status
19	INSUR_STATUS_DT	☐	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
20	INACTIVE_REASON	☐	CMS_DTE_INS_INACTIVE_REASON	CMS_INS_INACTIVE_REASON	CHAR	2	0	Reason for inactivating insurance policy	*
21	RECALL_PRD	☐	CMS_DTE_INS_RECALL_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Recall period
22	RECALL_PRD_UNIT	☐	CMS_DTE_INS_RECALL_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of Recall Period
23	ORIG_COUNTRY	☐	CMS_DTE_INS_ORIG_COUNTRY	LAND1	CHAR	3	0	Country where Insurance was purchased	*
24	ORIG_REGION	☐	CMS_DTE_INS_ORIG_REGION	REGIO	CHAR	3	0	Region where Insurance was purchased	*
25	PRM_TYPE	☐	CMS_DTE_INS_PRM_TYPE	CMS_INS_PREMIUM_TYPE	CHAR	2	0	Type of Premium
26	PRM_VALID_FROM	☐	CMS_DTE_INS_PRM_VALID_FROM_DT	CMS_DATE	DATS	8	0	Date from when specified Premium is valid
27	PAYMNT_METHOD	☐	CMS_DTE_INS_PAYMENT_METHOD	CMS_INS_PAYMENT_METHOD	CHAR	2	0	Payment method for premiums
28	PAYMNT_INFO	☐	CMS_DTE_INS_PAY_INFO	CMS_PAYMENT_HANDLE	CHAR	30	0	Payment Info for an insurance policy
29	LAST_PAYMENT_DT	☐	CMS_DTE_INS_LAST_PAYMENT_DT	CMS_DATE	DATS	8	0	Date when last premium payment was made
30	NXT_PAYMENT_DT	☐	CMS_DTE_INS_NXT_PAYMENT_DT	CMS_DATE	DATS	8	0	Next Payment Date when insurance premium is due
31	STATEMENT_DT	☐	CMS_DTE_INS_STATEMENT_DT	CMS_DATE	DATS	8	0	Date when statements for Policy was made
32	REBATE_METHOD	☐	CMS_DTE_INS_REBATE_METHOD_ID	CMS_INS_REBATE_METHOD_ID	CHAR	6	0	Identifier for the rebate method used to calculate refunds	*
33	PORTFOLIO	☐	CMS_DTE_INS_PORTFOLIO	CMS_INS_PORTFOLIO	CHAR	6	0	Insurance Portfolio	*
34	MAX_AGE_LIMIT	☐	CMS_DTE_INS_MAX_AGE_LIMIT	CMS_AGE	INT1	3	0	Maximum age limit for Policy Validity
35	IND_INSURED_EVENT	☐	CMS_DTE_IND_INSURED_EVENT	CMS_IND_OCCURENCE	CHAR	1	0	Boolean indicator that insured event occured (X = Occured)
36	INSURED_EVENT_DT	☐	CMS_DTE_INSURED_EVENT_DT	CMS_DATE	DATS	8	0	Date when Insured Event Occured
37	IND_FORCE_PLACED	☐	CMS_DTE_INS_IND_FORCE_PLACE	CMS_IND_INS_FORCE_PLACE	CHAR	2	0	Is Insurance Force Placed? (Default = No)
38	IND_TAX_DEDUCT	☐	CMS_DTE_INS_IND_TAX_DEDUCT	CMS_IND_INS_TAX_DEDUCTIBLE	CHAR	2	0	Indicator that Insurance Policy is Tax Deductible

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_INS_MAP	INSUR_CURR	TCURC	WAERS	REF	1	CN

History

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