SAP ABAP Table CMS_STR_SEC_AST_DATA_DB (SEC ACC DB Asset Details - not used)

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	CMS_STR_SEC_AST_DATA_DB	Table Relationship Diagram
Short Description	SEC ACC DB Asset Details - not used

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	Basic Asset data
2	RISK_CODE	☐	CMS_DTE_SEC_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
3	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
4	SFTY_DSCNT	☐	CMS_DTE_SEC_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
5	SFTY_AMOUNT	☐	CMS_DTE_SEC_SAFETY_AMT	CMS_SEC_AMOUNT	CURR	17	2	Safety discount as an amount
6	SFTY_AMT_CURR	☐	CMS_DTE_SEC_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
7	.INCLUDE	☐				0	0	Valuation data
8	UNIT_VALN_FREQ	☐	CMS_DTE_SEC_IND_FREQUENCY	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator : Valuation Frequency of Securities Account
9	PERIOD_VALN_FREQ	☐	CMS_DTE_SEC_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for securities
10	START_DATE	☐	CMS_DTE_SEC_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
11	END_DATE	☐	CMS_DTE_SEC_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
12	.INCLUDE	☐				0	0	Lending rate data
13	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
14	.INCLUDE	☐				0	0	Lending rates
15	LENDING_RATE1	☐	CMS_DTE_SEC_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
16	.INCLUDE	☐				0	0	Liquidation rights data
17	LIQD_TYP	☐	CMS_DTE_SEC_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
18	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
19	LIQD_DATE	☐	CMS_DTE_SEC_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
20	LIQD_AMT	☐	CMS_DTE_SEC_LIQD_VALUE	CMS_SEC_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
21	LIQD_CURR	☐	CMS_DTE_SEC_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SEC_AST_DATA_DB	LIQD_CURR	TCURC	WAERS	REF	1	CN
2	CMS_STR_SEC_AST_DATA_DB	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN

History

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