SAP ABAP Table CMS_STR_SEC_AST_DATA (Structure with Asset Details for Table CMS_AST)
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 | CMS_STR_SEC_AST_DATA | Table Relationship Diagram |
Short Description | Structure with Asset Details for Table CMS_AST |
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 | TCMS_ATT_ID_TY | |
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 | |
22 | .INCLUDE | 0 | 0 | Account for liquidation proceeds | |||||
23 | ACC_NUMBER_LIQ | CMS_DTE_LIQ_ACC_NUMBER | BANKN35 | CHAR | 35 | 0 | Account number for liquidation proceeds | ||
24 | BANK_CNTRY_LIQ | CMS_DTE_LIQ_BNK_CTRY_KY | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
25 | BANK_KEY_LIQ | CMS_DTE_LIQ_BNK_KEY | BANKK | CHAR | 15 | 0 | Bank Key | ||
26 | BANK_CTRLKEY_LIQ | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMS_STR_SEC_AST_DATA | BANK_CNTRY_LIQ | T005 | LAND1 | REF | 1 | CN |
2 | CMS_STR_SEC_AST_DATA | LIQD_CURR | TCURC | WAERS | REF | 1 | CN |
3 | CMS_STR_SEC_AST_DATA | LIQD_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | |||
4 | CMS_STR_SEC_AST_DATA | SFTY_AMT_CURR | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 200 |