SAP ABAP Table CMS_SEC_ACC (Securities account details)
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 | TRANSP | Transparent table |
Transparent table | CMS_SEC_ACC | Table Relationship Diagram |
Short Description | Securities account details |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Structure for Account GUID | |||||
3 | SEC_ACC_GUID | CMS_DTE_SEC_ACC_GUID | SYSUUID | RAW | 16 | 0 | GUID for securities account | ||
4 | .INCLUDE | 0 | 0 | Structure for account id of a securities account | |||||
5 | DEPO_BANK_ID | CMS_DTE_SEC_DEPO_BNK_ID | CMS_SEC_DEPO_BNK_ID | CHAR | 18 | 0 | Depository Bank Identification | ||
6 | ACCOUNT_NUMBER | CMS_DTE_SEC_ACC_NUMBER | CMS_SEC_ACC_ID | CHAR | 20 | 0 | Securities Account Identification Number | ||
7 | .INCLUDE | 0 | 0 | Description of the securities account | |||||
8 | SEC_ACC_DESC | CMS_DTE_SEC_ACC_DESC | CMS_SEC_DESC | CHAR | 30 | 0 | Description of the Securities Account | ||
9 | 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 | ||
10 | .INCLUDE | 0 | 0 | Valuation details of the securities account | |||||
11 | SEC_ACC_VAL | CMS_DTE_SEC_ACC_VAL_AMT | CMS_SEC_AMOUNT | CURR | 17 | 2 | Value of the Securities Account | ||
12 | SEC_ACC_VAL_CURR | CMS_DTE_SEC_ACC_VAL_CURR | WAERS | CUKY | 5 | 0 | Currency of Securities Account Value | TCURC | |
13 | VAL_DATE | CMS_DTE_SEC_ACC_VAL_DATE | CMS_DATE | DATS | 8 | 0 | Date of last valuation | ||
14 | .INCLUDE | 0 | 0 | Administrative organization unit | |||||
15 | ADMIN_ORG_UNIT | CMS_DTE_ADMINORG | TEXT12 | CHAR | 12 | 0 | Administration Organizational Unit | ||
16 | .INCLUDE | 0 | 0 | Bank area | |||||
17 | BANKAREA | CMS_DTE_BANKAREA | CMS_BANKAREA | CHAR | 4 | 0 | Bank Area in Collateral Management | * | |
18 | .INCLUDE | 0 | 0 | SEC ACC DB Asset Details - not used | |||||
19 | .INCLUDE | 0 | 0 | Basic Asset data | |||||
20 | RISK_CODE | CMS_DTE_SEC_RISK_CODE | CMS_RISK_CODE | CHAR | 6 | 0 | Risk Code | * | |
21 | 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 | ||
22 | SFTY_DSCNT | CMS_DTE_SEC_SAFETY_DSCNT | CMS_SFTY_PCT | DEC | 10 | 6 | Safety discount | ||
23 | SFTY_AMOUNT | CMS_DTE_SEC_SAFETY_AMT | CMS_SEC_AMOUNT | CURR | 17 | 2 | Safety discount as an amount | ||
24 | SFTY_AMT_CURR | CMS_DTE_SEC_SAFETY_AMT_CURR | WAERS | CUKY | 5 | 0 | Currency of the Safety discount amount | TCURC | |
25 | .INCLUDE | 0 | 0 | Valuation data | |||||
26 | UNIT_VALN_FREQ | CMS_DTE_SEC_IND_FREQUENCY | CMS_IND_AST_VALN_FREQ_UNIT | CHAR | 2 | 0 | Indicator : Valuation Frequency of Securities Account | ||
27 | PERIOD_VALN_FREQ | CMS_DTE_SEC_VALN_FREQ_PERIOD | CMS_AST_VALN_FREQ_PERIOD | NUMC | 4 | 0 | Period of revaluation for securities | ||
28 | START_DATE | CMS_DTE_SEC_START_DATE | CMS_DATE | DATS | 8 | 0 | Valuation Start date | ||
29 | END_DATE | CMS_DTE_SEC_END_DATE | CMS_DATE | DATS | 8 | 0 | Valuation End date | ||
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 | Organization unit structure:SEC | |||||
41 | ORG_UNIT1 | CMS_DTE_SEC_ORG_UNIT1 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 1: Assets | * | |
42 | ORG_UNIT2 | CMS_DTE_SEC_ORG_UNIT2 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 2: Assets | * | |
43 | ORG_UNIT3 | CMS_DTE_SEC_ORG_UNIT3 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 3: Assets | * | |
44 | ORG_UNIT4 | CMS_DTE_SEC_ORG_UNIT4 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 4: Assets | * | |
45 | ORG_UNIT5 | CMS_DTE_SEC_ORG_UNIT5 | CMS_ORG_UNIT | CHAR | 10 | 0 | Organizational Unit 5: Assets | * | |
46 | .INCLUDE | 0 | 0 | Structure for history | |||||
47 | CREATED_BY | CMS_DTE_SEC_CR_BY | CMS_USER | CHAR | 12 | 0 | Securities Add-On User | ||
48 | CREATED_DATE | CMS_DTE_SEC_CR_ON | CMS_DATE | DATS | 8 | 0 | Created On | ||
49 | CREATED_TIME | CMS_DTE_SEC_CR_AT | CMS_TIME | TIMS | 6 | 0 | Created At | ||
50 | LAST_CHG_BY | CMS_DTE_SEC_CH_BY | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
51 | LAST_CHG_DATE | CMS_DTE_SEC_CH_ON | CMS_DATE | DATS | 8 | 0 | Last Changed on | ||
52 | 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_SEC_ACC | LIQD_CURR | TCURC | WAERS | REF | 1 | CN |
2 | CMS_SEC_ACC | SEC_ACC_VAL_CURR | TCURC | WAERS | KEY | ||
3 | CMS_SEC_ACC | SFTY_AMT_CURR | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20050109 |
SAP Release Created in | 200 |