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

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	VCMS_SEC_ACC	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	Securities account details
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Structure for Account GUID
4	SEC_ACC_GUID	☐	CMS_DTE_SEC_ACC_GUID	SYSUUID	RAW	16	0	GUID for securities account
5	.INCLUDE	☐				0	0	Structure for account id of a securities account
6	DEPO_BANK_ID	☐	CMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository Bank Identification
7	ACCOUNT_NUMBER	☐	CMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities Account Identification Number
8	.INCLUDE	☐				0	0	Description of the securities account
9	SEC_ACC_DESC	☐	CMS_DTE_SEC_ACC_DESC	CMS_SEC_DESC	CHAR	30	0	Description of the Securities Account
10	ACC_OLD_REF_NO	☐	CMS_DTE_SEC_ACC_REF_NO	CMS_SEC_EXT_REFID	CHAR	32	0	ID of a Securities Account Referenced from External System
11	.INCLUDE	☐				0	0	Valuation details of the securities account
12	SEC_ACC_VAL	☐	CMS_DTE_SEC_ACC_VAL_AMT	CMS_SEC_AMOUNT	CURR	17	2	Value of the Securities Account
13	SEC_ACC_VAL_CURR	☐	CMS_DTE_SEC_ACC_VAL_CURR	WAERS	CUKY	5	0	Currency of Securities Account Value	TCURC
14	VAL_DATE	☐	CMS_DTE_SEC_ACC_VAL_DATE	CMS_DATE	DATS	8	0	Date of last valuation
15	.INCLUDE	☐				0	0	Administrative organization unit
16	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
17	.INCLUDE	☐				0	0	Bank area
18	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
19	.INCLUDE	☐				0	0	SEC ACC DB Asset Details - not used
20	.INCLUDE	☐				0	0	Basic Asset data
21	RISK_CODE	☐	CMS_DTE_SEC_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
22	SFTY_IND	☐	CMS_DTE_SEC_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
23	SFTY_DSCNT	☐	CMS_DTE_SEC_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
24	SFTY_AMOUNT	☐	CMS_DTE_SEC_SAFETY_AMT	CMS_SEC_AMOUNT	CURR	17	2	Safety discount as an amount
25	SFTY_AMT_CURR	☐	CMS_DTE_SEC_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
26	.INCLUDE	☐				0	0	Valuation data
27	UNIT_VALN_FREQ	☐	CMS_DTE_SEC_IND_FREQUENCY	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator : Valuation Frequency of Securities Account
28	PERIOD_VALN_FREQ	☐	CMS_DTE_SEC_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for securities
29	START_DATE	☐	CMS_DTE_SEC_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
30	END_DATE	☐	CMS_DTE_SEC_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
31	.INCLUDE	☐				0	0	Lending rate data
32	LENDING_RATE_IND	☐	CMS_DTE_SEC_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
33	.INCLUDE	☐				0	0	Lending rates
34	LENDING_RATE1	☐	CMS_DTE_SEC_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
35	.INCLUDE	☐				0	0	Liquidation rights data
36	LIQD_TYP	☐	CMS_DTE_SEC_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
37	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
38	LIQD_DATE	☐	CMS_DTE_SEC_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
39	LIQD_AMT	☐	CMS_DTE_SEC_LIQD_VALUE	CMS_SEC_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
40	LIQD_CURR	☐	CMS_DTE_SEC_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value	TCURC
41	.INCLUDE	☐				0	0	Organization unit structure:SEC
42	ORG_UNIT1	☐	CMS_DTE_SEC_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1: Assets	*
43	ORG_UNIT2	☐	CMS_DTE_SEC_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2: Assets	*
44	ORG_UNIT3	☐	CMS_DTE_SEC_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3: Assets	*
45	ORG_UNIT4	☐	CMS_DTE_SEC_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4: Assets	*
46	ORG_UNIT5	☐	CMS_DTE_SEC_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5: Assets	*
47	.INCLUDE	☐				0	0	Structure for history
48	CREATED_BY	☐	CMS_DTE_SEC_CR_BY	CMS_USER	CHAR	12	0	Securities Add-On User
49	CREATED_DATE	☐	CMS_DTE_SEC_CR_ON	CMS_DATE	DATS	8	0	Created On
50	CREATED_TIME	☐	CMS_DTE_SEC_CR_AT	CMS_TIME	TIMS	6	0	Created At
51	LAST_CHG_BY	☐	CMS_DTE_SEC_CH_BY	CMS_USER	CHAR	12	0	Last Changed By
52	LAST_CHG_DATE	☐	CMS_DTE_SEC_CH_ON	CMS_DATE	DATS	8	0	Last Changed on
53	LAST_CHG_TIME	☐	CMS_DTE_SEC_CH_AT	CMS_TIME	TIMS	6	0	Last Changed At
54	.INCLUDE	☐				0	0	Structures for generating change document update programs
55	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_SEC_ACC	LIQD_CURR	TCURC	WAERS	REF	1	CN
2	VCMS_SEC_ACC	SEC_ACC_VAL_CURR	TCURC	WAERS	KEY
3	VCMS_SEC_ACC	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN

History

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