SAP ABAP Table CMS_STR_SEC_ACC_SCR (Screen structure for Securities account details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-SEC (Application Component) Securities
     ⤷ CMS_SEC_UI (Package) Securities User Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_SEC_ACC_SCR	Table Relationship Diagram
Short Description	Screen structure for Securities account details

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	Structure for Account GUID
2	SEC_ACC_GUID	☐	CMS_DTE_SEC_ACC_GUID	SYSUUID	RAW	16	0	GUID for securities account
3	.INCLUDE	☐				0	0	Structure for account id of a securities account
4	DEPO_BANK_ID	☐	CMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository Bank Identification
5	ACCOUNT_NUMBER	☐	CMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities Account Identification Number
6	.INCLUDE	☐				0	0	Description of the securities account
7	SEC_ACC_DESC	☐	CMS_DTE_SEC_ACC_DESC	CMS_SEC_DESC	CHAR	30	0	Description of the Securities Account
8	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
9	.INCLUDE	☐				0	0	Depository Bank details
10	BANK_NAME	☐	CMS_DTE_SEC_ACC_BANK_NAME	CMS_SEC_NAME	CHAR	40	0	Depository bank name of securities account
11	BANK_STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
12	BANK_CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
13	.INCLUDE	☐				0	0	Valuation details of the securities account
14	SEC_ACC_VAL	☐	CMS_DTE_SEC_ACC_VAL_AMT	CMS_SEC_AMOUNT	CURR	17	2	Value of the Securities Account
15	SEC_ACC_VAL_CURR	☐	CMS_DTE_SEC_ACC_VAL_CURR	WAERS	CUKY	5	0	Currency of Securities Account Value	TCURC
16	VAL_DATE	☐	CMS_DTE_SEC_ACC_VAL_DATE	CMS_DATE	DATS	8	0	Date of last valuation
17	.INCLUDE	☐				0	0	Administration organization unit (key conversion)
18	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG_KEY	CMS_ADMINORG_KEY	CHAR	12	0	Administration Organizational Unit (Key conversion)
19	.INCLUDE	☐				0	0	Bank area
20	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
21	.INCLUDE	☐				0	0	Structure with Asset Details for Table CMS_AST
22	.INCLUDE	☐				0	0	Basic Asset data
23	RISK_CODE	☐	CMS_DTE_SEC_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
24	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
25	SFTY_DSCNT	☐	CMS_DTE_SEC_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
26	SFTY_AMOUNT	☐	CMS_DTE_SEC_SAFETY_AMT	CMS_SEC_AMOUNT	CURR	17	2	Safety discount as an amount
27	SFTY_AMT_CURR	☐	CMS_DTE_SEC_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
28	.INCLUDE	☐				0	0	Valuation data
29	UNIT_VALN_FREQ	☐	CMS_DTE_SEC_IND_FREQUENCY	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator : Valuation Frequency of Securities Account
30	PERIOD_VALN_FREQ	☐	CMS_DTE_SEC_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for securities
31	START_DATE	☐	CMS_DTE_SEC_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
32	END_DATE	☐	CMS_DTE_SEC_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
33	.INCLUDE	☐				0	0	Lending rate data
34	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
35	.INCLUDE	☐				0	0	Lending rates
36	LENDING_RATE1	☐	CMS_DTE_SEC_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
37	.INCLUDE	☐				0	0	Liquidation rights data
38	LIQD_TYP	☐	CMS_DTE_SEC_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
39	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
40	LIQD_DATE	☐	CMS_DTE_SEC_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
41	LIQD_AMT	☐	CMS_DTE_SEC_LIQD_VALUE	CMS_SEC_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
42	LIQD_CURR	☐	CMS_DTE_SEC_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value	TCURC
43	.INCLUDE	☐				0	0	Account for liquidation proceeds
44	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
45	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
46	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
47	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
48	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
49	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
50	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
51	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
52	.INCLUDE	☐				0	0	Structure for Asset values
53	.INCLUDE	☐				0	0	Structure for Asset values
54	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
55	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value	TCURC
56	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
57	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value	TCURC
58	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
59	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
60	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
61	.INCLUDE	☐				0	0	Purchase price data
62	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
63	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price	TCURC
64	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
65	.INCLUDE	☐				0	0	Active System Statuses
66	SYS_STAT	☐	CMS_DTE_SYS_STAT_LINE	TEXT40	CHAR	40	0	System Status
67	.INCLUDE	☐				0	0	Active User Statuses
68	USR_STAT	☐	CMS_DTE_USR_STAT_LINE	TEXT40	CHAR	40	0	User Status
69	.INCLUDE	☐				0	0	New System Statuses
70	SYS_STAT_NEW	☐	CMS_DTE_SYS_STAT_LINE	TEXT40	CHAR	40	0	System Status
71	.INCLUDE	☐				0	0	New User Statuses
72	USR_STAT_NEW	☐	CMS_DTE_USR_STAT_LINE	TEXT40	CHAR	40	0	User Status
73	.INCLUDE	☐				0	0	Organization unit structure:SEC
74	ORG_UNIT1	☐	CMS_DTE_SEC_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1: Assets	*
75	ORG_UNIT2	☐	CMS_DTE_SEC_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2: Assets	*
76	ORG_UNIT3	☐	CMS_DTE_SEC_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3: Assets	*
77	ORG_UNIT4	☐	CMS_DTE_SEC_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4: Assets	*
78	ORG_UNIT5	☐	CMS_DTE_SEC_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5: Assets	*
79	.INCLUDE	☐				0	0	Structure for history
80	CREATED_BY	☐	CMS_DTE_SEC_CR_BY	CMS_USER	CHAR	12	0	Securities Add-On User
81	CREATED_DATE	☐	CMS_DTE_SEC_CR_ON	CMS_DATE	DATS	8	0	Created On
82	CREATED_TIME	☐	CMS_DTE_SEC_CR_AT	CMS_TIME	TIMS	6	0	Created At
83	LAST_CHG_BY	☐	CMS_DTE_SEC_CH_BY	CMS_USER	CHAR	12	0	Last Changed By
84	LAST_CHG_DATE	☐	CMS_DTE_SEC_CH_ON	CMS_DATE	DATS	8	0	Last Changed on
85	LAST_CHG_TIME	☐	CMS_DTE_SEC_CH_AT	CMS_TIME	TIMS	6	0	Last Changed At

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SEC_ACC_SCR	AST_VALUE_CURR	TCURC	WAERS
2	CMS_STR_SEC_ACC_SCR	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
3	CMS_STR_SEC_ACC_SCR	LIQD_CURR	TCURC	WAERS	REF	1	CN
4	CMS_STR_SEC_ACC_SCR	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
5	CMS_STR_SEC_ACC_SCR	NOM_VALUE_CURR	TCURC	WAERS
6	CMS_STR_SEC_ACC_SCR	PUR_PRICE_CURR	TCURC	WAERS
7	CMS_STR_SEC_ACC_SCR	SEC_ACC_VAL_CURR	TCURC	WAERS	KEY
8	CMS_STR_SEC_ACC_SCR	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN
9	CMS_STR_SEC_ACC_SCR	UNIT_OF_MEASURE	T006	MSEHI	REF	1	CN

History

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