SAP ABAP Table CMS_STR_SEC_ACC_POS (Structure for securities positions(without mandt))

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_ACC_POS	Table Relationship Diagram
Short Description	Structure for securities positions(without mandt)

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	Primary key for positions
2	SEC_ACC_POS_GUID	☐	CMS_DTE_SEC_ACC_POS_GUID	SYSUUID	RAW	16	0	GUID for securities positions in an account
3	.INCLUDE	☐				0	0	Link structure for the securities account
4	SEC_ACC_GUID	☐	CMS_DTE_SEC_ACC_GUID	SYSUUID	RAW	16	0	GUID for securities account
5	.INCLUDE	☐				0	0	Basic position details of a securities account
6	POS_NO	☐	CMS_DTE_SEC_ACC_POS_SEQ_NO	CMS_SEC_POS_ID	NUMC	4	0	Sequence Number of a Position in a Securities Account
7	POS_OLD_REF_NO	☐	CMS_DTE_SEC_ACC_POS_REF_NO	CMS_SEC_EXT_REFID	CHAR	32	0	ID of a Positiion Referenced from an External System
8	ISIN	☐	CMS_DTE_SEC_ACC_POS_ISIN	CMS_SEC_POS_ISIN	CHAR	20	0	Unique ID for a Position in a Securities Account
9	NO_OF_UNITS	☐	CMS_DTE_SEC_ACC_POS_NO_UNIT	CMS_SEC_UNITS	DEC	15	5	Number of Units in a Securities Position
10	NOMINAL_VALUE	☐	CMS_DTE_SEC_ACC_POS_NVAL_AMT	CMS_SEC_AMOUNT	CURR	17	2	Nominal Value of a Position
11	NOMINAL_VAL_CURR	☐	CMS_DTE_SEC_ACC_POS_NVAL_CURR	WAERS	CUKY	5	0	Currency of nominal value of a position	TCURC
12	.INCLUDE	☐				0	0	Valuation details of securities positions
13	CURRENT_PRICE	☐	CMS_DTE_SEC_ACC_POS_CP_AMT	CMS_SEC_AMOUNT	CURR	17	2	Current Price of a Securities Postion per Unit
14	CURR_PRICE_CURR	☐	CMS_DTE_SEC_ACC_POS_CP_CURR	WAERS	CUKY	5	0	Currency of Current Price of a Securities Position	TCURC
15	CURR_PRICE_PCT	☐	CMS_DTE_SEC_ACC_POS_CP_PCT	CMS_SEC_PCT	DEC	10	6	Current Price of a Unit of a Securities Position
16	CURR_PRICE_AT	☐	CMS_DTE_SEC_CPRICE_TSTMPS	TZNTSTMPSL	NUMC	15	0	Position value recording Timestamp
17	MARKET_VALUE	☐	CMS_DTE_SEC_ACC_POS_MKT_VAL	CMS_SEC_AMOUNT	CURR	17	2	Market Value of a Securities Position
18	MARKET_VAL_CURR	☐	CMS_DTE_SEC_ACC_POS_MKT_CURR	WAERS	CUKY	5	0	Currency of the Market Value of Securities Positions	TCURC
19	.INCLUDE	☐				0	0	Market value of positions converted to sec account currency
20	CON_MKT_VAL	☐	CMS_DTE_SEC_ACC_POS_CONMKT_VAL	CMS_SEC_AMOUNT	CURR	17	2	Market Value of a Securities Account Position
21	CON_MKT_VAL_CURR	☐	CMS_DTE_SEC_POS_CONMKTVAL_CURR	WAERS	CUKY	5	0	Currency of Converted Market Value of Positions	*
22	.INCLUDE	☐				0	0	Structure with Asset Details for Table CMS_AST
23	.INCLUDE	☐				0	0	Basic Asset data
24	RISK_CODE	☐	CMS_DTE_SEC_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
25	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
26	SFTY_DSCNT	☐	CMS_DTE_SEC_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
27	SFTY_AMOUNT	☐	CMS_DTE_SEC_SAFETY_AMT	CMS_SEC_AMOUNT	CURR	17	2	Safety discount as an amount
28	SFTY_AMT_CURR	☐	CMS_DTE_SEC_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
29	.INCLUDE	☐				0	0	Valuation data
30	UNIT_VALN_FREQ	☐	CMS_DTE_SEC_IND_FREQUENCY	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator : Valuation Frequency of Securities Account
31	PERIOD_VALN_FREQ	☐	CMS_DTE_SEC_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for securities
32	START_DATE	☐	CMS_DTE_SEC_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
33	END_DATE	☐	CMS_DTE_SEC_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
34	.INCLUDE	☐				0	0	Lending rate data
35	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
36	.INCLUDE	☐				0	0	Lending rates
37	LENDING_RATE1	☐	CMS_DTE_SEC_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
38	.INCLUDE	☐				0	0	Liquidation rights data
39	LIQD_TYP	☐	CMS_DTE_SEC_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
40	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
41	LIQD_DATE	☐	CMS_DTE_SEC_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
42	LIQD_AMT	☐	CMS_DTE_SEC_LIQD_VALUE	CMS_SEC_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
43	LIQD_CURR	☐	CMS_DTE_SEC_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value	TCURC
44	.INCLUDE	☐				0	0	Account for liquidation proceeds
45	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
46	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
47	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
48	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
49	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
50	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
51	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
52	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
53	.INCLUDE	☐				0	0	Structure for history
54	CREATED_BY	☐	CMS_DTE_SEC_CR_BY	CMS_USER	CHAR	12	0	Securities Add-On User
55	CREATED_DATE	☐	CMS_DTE_SEC_CR_ON	CMS_DATE	DATS	8	0	Created On
56	CREATED_TIME	☐	CMS_DTE_SEC_CR_AT	CMS_TIME	TIMS	6	0	Created At
57	LAST_CHG_BY	☐	CMS_DTE_SEC_CH_BY	CMS_USER	CHAR	12	0	Last Changed By
58	LAST_CHG_DATE	☐	CMS_DTE_SEC_CH_ON	CMS_DATE	DATS	8	0	Last Changed on
59	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_POS	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
2	CMS_STR_SEC_ACC_POS	CURR_PRICE_CURR	TCURC	WAERS	REF	1	CN
3	CMS_STR_SEC_ACC_POS	LIQD_CURR	TCURC	WAERS	REF	1	CN
4	CMS_STR_SEC_ACC_POS	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
5	CMS_STR_SEC_ACC_POS	MARKET_VAL_CURR	TCURC	WAERS	KEY	1	CN
6	CMS_STR_SEC_ACC_POS	NOMINAL_VAL_CURR	TCURC	WAERS	REF	1	CN
7	CMS_STR_SEC_ACC_POS	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN

History

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