SAP ABAP Table CMS_STR_INS_SRV_DATA_SCR (BDT Screen fields for Insurance Service)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_INS_SRV_DATA_SCR	Table Relationship Diagram
Short Description	BDT Screen fields for Insurance Service

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	TCMS_INS_TYP
3	INS_TYP_DESC	☐	CMS_DTE_INS_NAME	CMS_INS_NAME	CHAR	40	0	Type Name
4	INS_CODE	☐	CMS_DTE_INS_CODE	CMS_INS_CODE	CHAR	6	0	Insurance Product Code
5	INS_ID	☐	CMS_DTE_INS_SRV_SCR_ID	CMS_MOV_ID	CHAR	40	0	Insurance ID
6	INS_DESC	☐	CMS_DTE_INS_DESC	CMS_INS_DESC	CHAR	30	0	Insurance Description
7	INSUR_SUM	☐	CMS_DTE_INS_SUM	CMS_AMOUNT	CURR	17	2	Insurance Sum
8	INSUR_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
9	MAX_COVER_AMT	☐	CMS_DTE_INS_MAX_COVER_AMT	CMS_AMOUNT	CURR	17	2	Maximum Coverage Amount
10	MAX_COVER_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	*
11	MIN_COVER_AMT	☐	CMS_DTE_INS_MIN_COVER_AMT	CMS_AMOUNT	CURR	17	2	Minimum Coverage Amount
12	MIN_COVER_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	*
13	PRM_RT	☐	CMS_DTE_INS_PRM_RT	CMS_INS_PRM_RT	DEC	10	7	Premium Rate
14	INSUR_PREMIUM	☐	CMS_DTE_INS_PRM	CMS_AMOUNT	CURR	17	2	Insurance Premium
15	INSUR_PREMIUM_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	*
16	FOP	☐	CMS_DTE_INS_FOP	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Frequency of Payment
17	FREQ_UNIT	☐	CMS_DTE_INS_FREQ_UNIT	CMS_INS_IND_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation
18	POLICY_NUMBER	☐	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
19	CONTRACT_STRT_DT	☐	CMS_DTE_INS_CNTRT_STRT_DT	DATUM	DATS	8	0	Contract begin date
20	CONTRACT_END_DT	☐	CMS_DTE_INS_CNTRT_END_DT	DATUM	DATS	8	0	Contract end date
21	CONTRACT_CON_DT	☐	CMS_DTE_INS_CNTRT_CON_DT	DATUM	DATS	8	0	Date of conclusion of contract
22	AUTO_CANCEL_DT	☐	CMS_DTE_INS_AUTO_CANCEL_DT	CMS_DATE	DATS	8	0	Auto Cancellation Date for an Insurance Policy
23	POLICY_STATUS	☐	CMS_DTE_INS_POLICY_STATUS	CMS_INS_POLICY_STATUS	CHAR	2	0	Insurance Policy Status
24	INSUR_STATUS_DT	☐	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
25	INACTIVE_REASON	☐	CMS_DTE_INS_INACTIVE_REASON	CMS_INS_INACTIVE_REASON	CHAR	2	0	Reason for inactivating insurance policy	TCMS_INS_SRSN
26	INACTIVE_REASON_DESC	☐	CMS_DTE_INS_INACTIVE_RSN_TEXT		CHAR	30	0	Description for the Reason to Inactivate Insurance Policy
27	RECALL_PRD	☐	CMS_DTE_INS_RECALL_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Recall period
28	RECALL_PRD_UNIT	☐	CMS_DTE_INS_RECALL_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of Recall Period
29	ORIG_COUNTRY	☐	CMS_DTE_INS_ORIG_COUNTRY	LAND1	CHAR	3	0	Country where Insurance was purchased	T005
30	ORIG_COUNTRY_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
31	ORIG_REGION	☐	CMS_DTE_INS_ORIG_REGION	REGIO	CHAR	3	0	Region where Insurance was purchased	T005S
32	ORIG_REGION_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
33	PRM_TYPE	☐	CMS_DTE_INS_PRM_TYPE	CMS_INS_PREMIUM_TYPE	CHAR	2	0	Type of Premium
34	PRM_VALID_FROM	☐	CMS_DTE_INS_PRM_VALID_FROM_DT	CMS_DATE	DATS	8	0	Date from when specified Premium is valid
35	PAYMNT_METHOD	☐	CMS_DTE_INS_PAYMENT_METHOD	CMS_INS_PAYMENT_METHOD	CHAR	2	0	Payment method for premiums
36	PAYMNT_INFO	☐	CMS_DTE_INS_PAY_INFO	CMS_PAYMENT_HANDLE	CHAR	30	0	Payment Info for an insurance policy
37	LAST_PAYMENT_DT	☐	CMS_DTE_INS_LAST_PAYMENT_DT	CMS_DATE	DATS	8	0	Date when last premium payment was made
38	NXT_PAYMENT_DT	☐	CMS_DTE_INS_NXT_PAYMENT_DT	CMS_DATE	DATS	8	0	Next Payment Date when insurance premium is due
39	STATEMENT_DT	☐	CMS_DTE_INS_STATEMENT_DT	CMS_DATE	DATS	8	0	Date when statements for Policy was made
40	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
41	REBATE_METHOD_DESC	☐	CMS_DTE_INS_REBATE_DESC		CHAR	30	0	Description for Insurance Rebate Method
42	PORTFOLIO	☐	CMS_DTE_INS_PORTFOLIO	CMS_INS_PORTFOLIO	CHAR	6	0	Insurance Portfolio	TCMS_INS_PORT
43	PORTFOLIO_DESC	☐	CMS_DTE_INS_PORTFOLIO_DESC		CHAR	30	0	Description for Insurance Rebate Method
44	MAX_AGE_LIMIT	☐	CMS_DTE_INS_MAX_AGE_LIMIT	CMS_AGE	INT1	3	0	Maximum age limit for Policy Validity
45	IND_INSURED_EVNT	☐	CMS_DTE_IND_INSURED_EVENT	CMS_IND_OCCURENCE	CHAR	1	0	Boolean indicator that insured event occured (X = Occured)
46	INSURED_EVENT_DT	☐	CMS_DTE_INSURED_EVENT_DT	CMS_DATE	DATS	8	0	Date when Insured Event Occured
47	IND_FORCE_PLACED	☐	CMS_DTE_INS_IND_FORCE_PLACE	CMS_IND_INS_FORCE_PLACE	CHAR	2	0	Is Insurance Force Placed? (Default = No)
48	IND_TAX_DEDUCT	☐	CMS_DTE_INS_IND_TAX_DEDUCT	CMS_IND_INS_TAX_DEDUCTIBLE	CHAR	2	0	Indicator that Insurance Policy is Tax Deductible
49	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
50	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
51	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
52	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
53	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
54	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
55	CREATED_DATE	☐	CMS_DTE_DATE	CMS_DATE	DATS	8	0	Date
56	CREATED_TIME	☐	CMS_DTE_TIME	CMS_TIME	TIMS	6	0	Time
57	CHANGED_DATE	☐	CMS_DTE_DATE	CMS_DATE	DATS	8	0	Date
58	CHANGED_TIME	☐	CMS_DTE_TIME	CMS_TIME	TIMS	6	0	Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_INS_SRV_DATA_SCR	INACTIVE_REASON	TCMS_INS_SRSN	INACTIVE_REASON	REF	1	CN
2	CMS_STR_INS_SRV_DATA_SCR	INSUR_CURR	TCURC	WAERS	REF	1	CN
3	CMS_STR_INS_SRV_DATA_SCR	INS_TYP	TCMS_INS_TYP	INS_CATEGORY	REF	1	CN
4	CMS_STR_INS_SRV_DATA_SCR	ORIG_COUNTRY	T005	LAND1	REF	1	CN
5	CMS_STR_INS_SRV_DATA_SCR	ORIG_REGION	T005S	BLAND	REF	1	CN
6	CMS_STR_INS_SRV_DATA_SCR	PORTFOLIO	TCMS_INS_PORT	PORTFOLIO	REF	1	CN
7	CMS_STR_INS_SRV_DATA_SCR	REBATE_METHOD	TCMS_INS_REB	REBATE_METHOD	REF	1	CN

History

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