SAP ABAP Table VCMS_SEC_ACC_POS (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
⤷ 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_POS | 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 position details | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | .INCLUDE | 0 | 0 | Primary key for positions | |||||
4 | SEC_ACC_POS_GUID | CMS_DTE_SEC_ACC_POS_GUID | SYSUUID | RAW | 16 | 0 | GUID for securities positions in an account | ||
5 | .INCLUDE | 0 | 0 | Link structure for the securities account | |||||
6 | SEC_ACC_GUID | CMS_DTE_SEC_ACC_GUID | SYSUUID | RAW | 16 | 0 | GUID for securities account | ||
7 | .INCLUDE | 0 | 0 | Basic position details of a securities account | |||||
8 | 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 | ||
9 | 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 | ||
10 | ISIN | CMS_DTE_SEC_ACC_POS_ISIN | CMS_SEC_POS_ISIN | CHAR | 20 | 0 | Unique ID for a Position in a Securities Account | ||
11 | NO_OF_UNITS | CMS_DTE_SEC_ACC_POS_NO_UNIT | CMS_SEC_UNITS | DEC | 15 | 5 | Number of Units in a Securities Position | ||
12 | NOMINAL_VALUE | CMS_DTE_SEC_ACC_POS_NVAL_AMT | CMS_SEC_AMOUNT | CURR | 17 | 2 | Nominal Value of a Position | ||
13 | NOMINAL_VAL_CURR | CMS_DTE_SEC_ACC_POS_NVAL_CURR | WAERS | CUKY | 5 | 0 | Currency of nominal value of a position | TCURC | |
14 | .INCLUDE | 0 | 0 | Valuation details of securities positions | |||||
15 | CURRENT_PRICE | CMS_DTE_SEC_ACC_POS_CP_AMT | CMS_SEC_AMOUNT | CURR | 17 | 2 | Current Price of a Securities Postion per Unit | ||
16 | CURR_PRICE_CURR | CMS_DTE_SEC_ACC_POS_CP_CURR | WAERS | CUKY | 5 | 0 | Currency of Current Price of a Securities Position | TCURC | |
17 | 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 | ||
18 | CURR_PRICE_AT | CMS_DTE_SEC_CPRICE_TSTMPS | TZNTSTMPSL | NUMC | 15 | 0 | Position value recording Timestamp | ||
19 | MARKET_VALUE | CMS_DTE_SEC_ACC_POS_MKT_VAL | CMS_SEC_AMOUNT | CURR | 17 | 2 | Market Value of a Securities Position | ||
20 | MARKET_VAL_CURR | CMS_DTE_SEC_ACC_POS_MKT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Market Value of Securities Positions | TCURC | |
21 | .INCLUDE | 0 | 0 | Market value of positions converted to sec account currency | |||||
22 | CON_MKT_VAL | CMS_DTE_SEC_ACC_POS_CONMKT_VAL | CMS_SEC_AMOUNT | CURR | 17 | 2 | Market Value of a Securities Account Position | ||
23 | CON_MKT_VAL_CURR | CMS_DTE_SEC_POS_CONMKTVAL_CURR | WAERS | CUKY | 5 | 0 | Currency of Converted Market Value of Positions | * | |
24 | .INCLUDE | 0 | 0 | Basic Asset data | |||||
25 | RISK_CODE | CMS_DTE_SEC_RISK_CODE | CMS_RISK_CODE | CHAR | 6 | 0 | Risk Code | TCMS_RISKCODE | |
26 | 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 | ||
27 | SFTY_DSCNT | CMS_DTE_SEC_SAFETY_DSCNT | CMS_SFTY_PCT | DEC | 10 | 6 | Safety discount | ||
28 | SFTY_AMOUNT | CMS_DTE_SEC_SAFETY_AMT | CMS_SEC_AMOUNT | CURR | 17 | 2 | Safety discount as an amount | ||
29 | SFTY_AMT_CURR | CMS_DTE_SEC_SAFETY_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Safety discount amount | TCURC | |
30 | .INCLUDE | 0 | 0 | Lending rate data | |||||
31 | 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 | ||
32 | .INCLUDE | 0 | 0 | Lending rates | |||||
33 | LENDING_RATE1 | CMS_DTE_SEC_LRTE_PCT1 | CMS_PCT | DEC | 10 | 6 | Lending rate 1 | ||
34 | .INCLUDE | 0 | 0 | Liquidation rights data | |||||
35 | LIQD_TYP | CMS_DTE_SEC_LIQD_TYP | CMS_TYP | CHAR | 6 | 0 | Liquidation type | ||
36 | LIQD_REASON | CMS_DTE_ATT_ID_TY_AST004 | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Liquidation Reason | ||
37 | LIQD_DATE | CMS_DTE_SEC_LIQD_DATE | CMS_DATE | DATS | 8 | 0 | Date of Liquidation of Collateral | ||
38 | LIQD_AMT | CMS_DTE_SEC_LIQD_VALUE | CMS_SEC_AMOUNT | CURR | 17 | 2 | Proceeds obtained from liquidation of the collateral | ||
39 | LIQD_CURR | CMS_DTE_SEC_LIQD_CURR | WAERS | CUKY | 5 | 0 | Currency of Liquidation value | TCURC | |
40 | .INCLUDE | 0 | 0 | Structure for history | |||||
41 | CREATED_BY | CMS_DTE_SEC_CR_BY | CMS_USER | CHAR | 12 | 0 | Securities Add-On User | ||
42 | CREATED_DATE | CMS_DTE_SEC_CR_ON | CMS_DATE | DATS | 8 | 0 | Created On | ||
43 | CREATED_TIME | CMS_DTE_SEC_CR_AT | CMS_TIME | TIMS | 6 | 0 | Created At | ||
44 | LAST_CHG_BY | CMS_DTE_SEC_CH_BY | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
45 | LAST_CHG_DATE | CMS_DTE_SEC_CH_ON | CMS_DATE | DATS | 8 | 0 | Last Changed on | ||
46 | LAST_CHG_TIME | CMS_DTE_SEC_CH_AT | CMS_TIME | TIMS | 6 | 0 | Last Changed At | ||
47 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
48 | 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_POS | CURR_PRICE_CURR | TCURC | WAERS | REF | 1 | CN |
2 | VCMS_SEC_ACC_POS | LIQD_CURR | TCURC | WAERS | REF | 1 | CN |
3 | VCMS_SEC_ACC_POS | MARKET_VAL_CURR | TCURC | WAERS | KEY | 1 | CN |
4 | VCMS_SEC_ACC_POS | NOMINAL_VAL_CURR | TCURC | WAERS | REF | 1 | CN |
5 | VCMS_SEC_ACC_POS | RISK_CODE | TCMS_RISKCODE | RISK_CODE | REF | 1 | CN |
6 | VCMS_SEC_ACC_POS | SFTY_AMT_CURR | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20050409 |
SAP Release Created in | 600 |