SAP ABAP Table VCMS_INS (Change Document Structure; Generated by RSSCD000)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-SHP (Application Component) Ship
     ⤷ CMS_SHP (Package) Ship: General tables and programs & Persistence layer

Basic Data

Table Category	INTTAB	Structure
Structure	VCMS_INS	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	.INCLUDE	☐				0	0	Insurance Application Table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Primary Key for Insurance
4	INS_GUID	☐	CMS_DTE_INS_GUID	SYSUUID	RAW	16	0	Insurance GUID
5	.INCLUDE	☐				0	0	Semantic Key for insurance
6	INS_CATEGORY	☐	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category	*
7	INS_TYP	☐	CMS_DTE_INS_TYPE	CMS_MOV_TYP	CHAR	6	0	Insurance Type	*
8	INS_ID	☐	CMS_DTE_INS_ID	CMS_MOV_ID	CHAR	40	0	Insurance ID
9	.INCLUDE	☐				0	0	Insurance common data
10	INS_DESC	☐	CMS_DTE_INS_DESC	CMS_INS_DESC	CHAR	30	0	Insurance Description
11	.INCLUDE	☐				0	0	Information on Insurance Settlement
12	INSUR_TAX_DB	☐	CMS_DTE_INS_TAX_DB	CMS_INS_FLG	CHAR	1	0	Insurance tax to the debit of the bank
13	SETLMNT_TYPE	☐	CMS_DTE_INS_SETLMNT_TYPE	CMS_ATT_ID_TYP	CHAR	6	0	Type of settlement	TCMS_ATT_ID_TY
14	INSUR_SUM	☐	CMS_DTE_INS_SUM	CMS_AMOUNT	CURR	17	2	Insurance Sum
15	INSUR_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
16	PRM_RT	☐	CMS_DTE_INS_PRM_RT	CMS_INS_PRM_RT	DEC	10	7	Premium Rate
17	INSUR_PREMIUM	☐	CMS_DTE_INS_PRM	CMS_AMOUNT	CURR	17	2	Insurance Premium
18	INSUR_PRM_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
19	INSUR_TAX_RT	☐	CMS_DTE_INS_TAX_RT	CMS_INS_PRM_RT	DEC	10	7	Insurance tax rate (in %)
20	INSUR_TAX_AMT	☐	CMS_DTE_INS_TAX_AMT	CMS_AMOUNT	CURR	17	2	Insurance tax amount
21	INSUR_TAX_CURR	☐	CMS_DTE_INS_TAX_CURR	WAERS	CUKY	5	0	Tax Currency	TCURC
22	.INCLUDE	☐				0	0	Insurance cover
23	SCOPE_INS_COVER	☐	CMS_DTE_INS_COVER	CMS_INS_COVER	CHAR	6	0	not used -> package has to be changed CMS_OMS_INS
24	.INCLUDE	☐				0	0	Common OMS data
25	EXT_ITM_NO	☐	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
26	EXT_REFERENCE	☐	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
27	FOP	☐	CMS_DTE_INS_FOP	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Frequency of Payment
28	FREQ_UNIT	☐	CMS_DTE_INS_FREQ_UNIT	CMS_INS_IND_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation
29	.INCLUDE	☐				0	0	Other general fields required for a standalone insurance
30	INS_CODE	☐	CMS_DTE_INS_CODE	CMS_INS_CODE	CHAR	6	0	Insurance Product Code
31	ORIG_COUNTRY	☐	CMS_DTE_INS_ORIG_COUNTRY	LAND1	CHAR	3	0	Country where Insurance was purchased	T005
32	ORIG_REGION	☐	CMS_DTE_INS_ORIG_REGION	REGIO	CHAR	3	0	Region where Insurance was purchased	T005S
33	AUTO_CANCEL_DT	☐	CMS_DTE_INS_AUTO_CANCEL_DT	CMS_DATE	DATS	8	0	Auto Cancellation Date for an Insurance Policy
34	PRM_TYPE	☐	CMS_DTE_INS_PRM_TYPE	CMS_INS_PREMIUM_TYPE	CHAR	2	0	Type of Premium
35	PRM_VALID_FROM	☐	CMS_DTE_INS_PRM_VALID_FROM_DT	CMS_DATE	DATS	8	0	Date from when specified Premium is valid
36	PAYMNT_METHOD	☐	CMS_DTE_INS_PAYMENT_METHOD	CMS_INS_PAYMENT_METHOD	CHAR	2	0	Payment method for premiums
37	PAYMNT_INFO	☐	CMS_DTE_INS_PAY_INFO	CMS_PAYMENT_HANDLE	CHAR	30	0	Payment Info for an insurance policy
38	LAST_PAYMENT_DT	☐	CMS_DTE_INS_LAST_PAYMENT_DT	CMS_DATE	DATS	8	0	Date when last premium payment was made
39	NXT_PAYMENT_DT	☐	CMS_DTE_INS_NXT_PAYMENT_DT	CMS_DATE	DATS	8	0	Next Payment Date when insurance premium is due
40	STATEMENT_DT	☐	CMS_DTE_INS_STATEMENT_DT	CMS_DATE	DATS	8	0	Date when statements for Policy was made
41	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
42	PORTFOLIO	☐	CMS_DTE_INS_PORTFOLIO	CMS_INS_PORTFOLIO	CHAR	6	0	Insurance Portfolio	TCMS_INS_PORT
43	MAX_AGE_LIMIT	☐	CMS_DTE_INS_MAX_AGE_LIMIT	CMS_AGE	INT1	3	0	Maximum age limit for Policy Validity
44	MAX_COVER_AMT	☐	CMS_DTE_INS_MAX_COVER_AMT	CMS_AMOUNT	CURR	17	2	Maximum Coverage Amount
45	MIN_COVER_AMT	☐	CMS_DTE_INS_MIN_COVER_AMT	CMS_AMOUNT	CURR	17	2	Minimum Coverage Amount
46	IND_INSURED_EVNT	☐	CMS_DTE_IND_INSURED_EVENT	CMS_IND_OCCURENCE	CHAR	1	0	Boolean indicator that insured event occured (X = Occured)
47	INSURED_EVENT_DT	☐	CMS_DTE_INSURED_EVENT_DT	CMS_DATE	DATS	8	0	Date when Insured Event Occured
48	IND_FORCE_PLACED	☐	CMS_DTE_INS_IND_FORCE_PLACE	CMS_IND_INS_FORCE_PLACE	CHAR	2	0	Is Insurance Force Placed? (Default = No)
49	IND_TAX_DEDUCT	☐	CMS_DTE_INS_IND_TAX_DEDUCT	CMS_IND_INS_TAX_DEDUCTIBLE	CHAR	2	0	Indicator that Insurance Policy is Tax Deductible
50	INACTIVE_REASON	☐	CMS_DTE_INS_INACTIVE_REASON	CMS_INS_INACTIVE_REASON	CHAR	2	0	Reason for inactivating insurance policy	TCMS_INS_SRSN
51	POLICY_STATUS	☐	CMS_DTE_INS_POLICY_STATUS	CMS_INS_POLICY_STATUS	CHAR	2	0	Insurance Policy Status
52	.INCLUDE	☐				0	0	Insurance for object
53	.INCLUDE	☐				0	0	Information on Insurance Agreement
54	INS_STRT_DAT	☐	CMS_DTE_INS_STRT_DAT	DATUM	DATS	8	0	Start date of insurance
55	INSUR_EXPY_DAT	☐	CMS_DTE_INS_EXPY_DAT	DATUM	DATS	8	0	Date of expiry of insurance
56	REQD_INSUR_CVR	☐	CMS_DTE_INS_REQD_CVR	CMS_AMOUNT	CURR	17	2	Required insurance cover
57	REQD_INSUR_CURR	☐	CMS_DTE_INS_CURR	WAERS	CUKY	5	0	Insurance Currency	TCURC
58	.INCLUDE	☐				0	0	Information on Insurance / Insurance Broker
59	INSURER_NAM	☐	CMS_DTE_INS_INSUR_NAM	CMS_INS_INSURER	CHAR	30	0	Name of the insurer
60	INSURER_INF	☐	CMS_DTE_INS_INSUR_INF	CMS_INS_INSUR_INF	CHAR	30	0	Remarks on insurer
61	COVER_MKT	☐	CMS_DTE_INS_COVER_MKT	LAND1	CHAR	3	0	Cover Market	*
62	SHARE_CVR_MKT	☐	CMS_DTE_INS_SH_CVR_MKT	CMS_AMOUNT	CURR	17	2	Share of cover market
63	SH_CVR_MKT_CUR	☐	CMS_DTE_INS_SH_CVR_MKT_CUR	WAERS	CUKY	5	0	Currency for Share of Cover Market	*
64	CONTACT_FIRM	☐	CMS_DTE_INS_CON_FRM	CMS_INS_CON_FRM	CHAR	30	0	Contact firm
65	CONTACT_PARTNER	☐	CMS_DTE_INS_CON_PRT	CMS_INS_CON_PRT	CHAR	30	0	Contact partner
66	.INCLUDE	☐				0	0	Insurance as object
67	.INCLUDE	☐				0	0	Special features for description of insurances
68	TARRIF	☐	CMS_DTE_INS_TARRIF	CMS_INS_TARRIF	CHAR	30	0	Insurance tariff
69	CONTRACT_STRT_DT	☐	CMS_DTE_INS_CNTRT_STRT_DT	DATUM	DATS	8	0	Contract begin date
70	CONTRACT_END_DT	☐	CMS_DTE_INS_CNTRT_END_DT	DATUM	DATS	8	0	Contract end date
71	CONTRACT_CON_DT	☐	CMS_DTE_INS_CNTRT_CON_DT	DATUM	DATS	8	0	Date of conclusion of contract
72	INSUR_STATUS	☐	CMS_DTE_INS_STATUS	CMS_ATT_ID_TYP	CHAR	6	0	Status of insurance	TCMS_ATT_ID_TY
73	INSUR_STATUS_DT	☐	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
74	SUM_ONE_TM_CON	☐	CMS_DTE_INS_SUM_ONE_TM_CON	CMS_AMOUNT	CURR	17	2	Sum of one time contribution
75	ONE_TM_CON_CKY	☐	CMS_DTE_INS_ONE_TM_CON_CKY	WAERS	CUKY	5	0	Currency	TCURC
76	DYNAMICS	☐	CMS_DTE_INS_DYNAMICS	CMS_INS_FLG	CHAR	1	0	Dynamics
77	PER_DYNAMICS	☐	CMS_DTE_INS_PER_DYNAMICS	CMS_SEC_PCT	DEC	10	6	Percentage of the dynamics
78	TERMIN_PRD	☐	CMS_DTE_INS_TERMIN_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Termination period
79	TERM_PRD_UNIT	☐	CMS_DTE_INS_TERM_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of termination period
80	RECALL_PRD	☐	CMS_DTE_INS_RECALL_PRD	CMS_INS_FREQ_OF_PAYMENT	NUMC	4	0	Recall period
81	RECALL_PRD_UNIT	☐	CMS_DTE_INS_RECALL_PRD_UNIT	CMS_INS_IND_FREQ_UNT	CHAR	2	0	Indicator: Units of Recall Period
82	INS_SUM_SRVL	☐	CMS_DTE_INS_SUM_IN_SURVIVAL	CMS_AMOUNT	CURR	17	2	Insurance sum incase of survival
83	INS_SUM_SRVL_CKY	☐	CMS_DTE_INS_SUM_IN_SURVIVL_CKY	WAERS	CUKY	5	0	Insurance survival Currency	TCURC
84	INS_SUM_DTH	☐	CMS_DTE_INS_SUM_IN_DEATH	CMS_AMOUNT	CURR	17	2	Insurance sum in case of death
85	INS_SUM_DTH_CKY	☐	CMS_DTE_INS_SUM_IN_DEATH_CKY	WAERS	CUKY	5	0	Death benefit currency	TCURC
86	INS_BENF_EXP	☐	CMS_DTE_INS_PROB_BENF	CMS_AMOUNT	CURR	17	2	Probable benefit on expiry
87	INS_BENF_EXP_CKY	☐	CMS_DTE_INS_PROB_BENF_CKY	WAERS	CUKY	5	0	Currency for probable benefit on expiry	TCURC
88	DT_PROB_BEN_EXP	☐	CMS_DTE_INS_DT_PRO_BEN_EXP	DATUM	DATS	8	0	Date of probable benefit on expiry
89	.INCLUDE	☐				0	0	Administrative organization unit
90	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
91	.INCLUDE	☐				0	0	Bank area
92	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
93	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
94	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
95	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
96	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
97	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
98	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
99	.INCLUDE	☐				0	0	Structures for generating change document update programs
100	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VCMS_INS	INACTIVE_REASON	TCMS_INS_SRSN	INACTIVE_REASON	REF	1	CN
2	VCMS_INS	INSUR_CURR	TCURC	WAERS	REF	1	CN
3	VCMS_INS	INSUR_PRM_CURR	TCURC	WAERS	REF	1	CN
4	VCMS_INS	INSUR_STATUS	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
5	VCMS_INS	INSUR_TAX_CURR	TCURC	WAERS	REF	1	CN
6	VCMS_INS	INS_BENF_EXP_CKY	TCURC	WAERS	REF	1	CN
7	VCMS_INS	INS_SUM_DTH_CKY	TCURC	WAERS	REF	1	CN
8	VCMS_INS	INS_SUM_SRVL_CKY	TCURC	WAERS	REF	1	CN
9	VCMS_INS	ONE_TM_CON_CKY	TCURC	WAERS	REF	1	CN
10	VCMS_INS	ORIG_COUNTRY	T005	LAND1	REF	1	CN
11	VCMS_INS	ORIG_REGION	T005S	BLAND	REF	1	CN
12	VCMS_INS	PORTFOLIO	TCMS_INS_PORT	PORTFOLIO	REF	1	CN
13	VCMS_INS	REBATE_METHOD	TCMS_INS_REB	REBATE_METHOD	REF	1	CN
14	VCMS_INS	REQD_INSUR_CURR	TCURC	WAERS	REF	1	CN
15	VCMS_INS	SETLMNT_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

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