SAP ABAP Table CMS_STR_INS_GENERAL (Other general fields required for a standalone insurance)

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_INS_GENERAL	Table Relationship Diagram
Short Description	Other general fields required for a standalone insurance

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_CODE	☐	CMS_DTE_INS_CODE	CMS_INS_CODE	CHAR	6	0	Insurance Product Code
2	ORIG_COUNTRY	☐	CMS_DTE_INS_ORIG_COUNTRY	LAND1	CHAR	3	0	Country where Insurance was purchased	T005
3	ORIG_REGION	☐	CMS_DTE_INS_ORIG_REGION	REGIO	CHAR	3	0	Region where Insurance was purchased	T005S
4	AUTO_CANCEL_DT	☐	CMS_DTE_INS_AUTO_CANCEL_DT	CMS_DATE	DATS	8	0	Auto Cancellation Date for an Insurance Policy
5	PRM_TYPE	☐	CMS_DTE_INS_PRM_TYPE	CMS_INS_PREMIUM_TYPE	CHAR	2	0	Type of Premium
6	PRM_VALID_FROM	☐	CMS_DTE_INS_PRM_VALID_FROM_DT	CMS_DATE	DATS	8	0	Date from when specified Premium is valid
7	PAYMNT_METHOD	☐	CMS_DTE_INS_PAYMENT_METHOD	CMS_INS_PAYMENT_METHOD	CHAR	2	0	Payment method for premiums
8	PAYMNT_INFO	☐	CMS_DTE_INS_PAY_INFO	CMS_PAYMENT_HANDLE	CHAR	30	0	Payment Info for an insurance policy
9	LAST_PAYMENT_DT	☐	CMS_DTE_INS_LAST_PAYMENT_DT	CMS_DATE	DATS	8	0	Date when last premium payment was made
10	NXT_PAYMENT_DT	☐	CMS_DTE_INS_NXT_PAYMENT_DT	CMS_DATE	DATS	8	0	Next Payment Date when insurance premium is due
11	STATEMENT_DT	☐	CMS_DTE_INS_STATEMENT_DT	CMS_DATE	DATS	8	0	Date when statements for Policy was made
12	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	TCMS_INS_REB
13	PORTFOLIO	☐	CMS_DTE_INS_PORTFOLIO	CMS_INS_PORTFOLIO	CHAR	6	0	Insurance Portfolio	TCMS_INS_PORT
14	MAX_AGE_LIMIT	☐	CMS_DTE_INS_MAX_AGE_LIMIT	CMS_AGE	INT1	3	0	Maximum age limit for Policy Validity
15	MAX_COVER_AMT	☐	CMS_DTE_INS_MAX_COVER_AMT	CMS_AMOUNT	CURR	17	2	Maximum Coverage Amount
16	MIN_COVER_AMT	☐	CMS_DTE_INS_MIN_COVER_AMT	CMS_AMOUNT	CURR	17	2	Minimum Coverage Amount
17	IND_INSURED_EVNT	☐	CMS_DTE_IND_INSURED_EVENT	CMS_IND_OCCURENCE	CHAR	1	0	Boolean indicator that insured event occured (X = Occured)
18	INSURED_EVENT_DT	☐	CMS_DTE_INSURED_EVENT_DT	CMS_DATE	DATS	8	0	Date when Insured Event Occured
19	IND_FORCE_PLACED	☐	CMS_DTE_INS_IND_FORCE_PLACE	CMS_IND_INS_FORCE_PLACE	CHAR	2	0	Is Insurance Force Placed? (Default = No)
20	IND_TAX_DEDUCT	☐	CMS_DTE_INS_IND_TAX_DEDUCT	CMS_IND_INS_TAX_DEDUCTIBLE	CHAR	2	0	Indicator that Insurance Policy is Tax Deductible
21	INACTIVE_REASON	☐	CMS_DTE_INS_INACTIVE_REASON	CMS_INS_INACTIVE_REASON	CHAR	2	0	Reason for inactivating insurance policy	TCMS_INS_SRSN
22	POLICY_STATUS	☐	CMS_DTE_INS_POLICY_STATUS	CMS_INS_POLICY_STATUS	CHAR	2	0	Insurance Policy Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_INS_GENERAL	INACTIVE_REASON	TCMS_INS_SRSN	INACTIVE_REASON	REF	1	CN
2	CMS_STR_INS_GENERAL	ORIG_COUNTRY	T005	LAND1	REF	1	CN
3	CMS_STR_INS_GENERAL	ORIG_REGION	T005S	BLAND	REF	1	CN
4	CMS_STR_INS_GENERAL	PORTFOLIO	TCMS_INS_PORT	PORTFOLIO	REF	1	CN
5	CMS_STR_INS_GENERAL	REBATE_METHOD	TCMS_INS_REB	REBATE_METHOD	REF	1	CN

History

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