CMS_SEC_ACC is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_SEC_ACC in SAP.
- Table description : Securities account details
- Module : FS-CMS-MD-SEC
- Parent Module : FS
- Package : CMS_SEC
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMS_SEC_ACC Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| .INCLUDE | Structure for Account GUID | ||
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | SYSUUID |
| .INCLUDE | Structure for account id of a securities account | ||
| DEPO_BANK_ID | Depository Bank Identification | CMS_DTE_SEC_DEPO_BNK_ID | CMS_SEC_DEPO_BNK_ID |
| ACCOUNT_NUMBER | Securities Account Identification Number | CMS_DTE_SEC_ACC_NUMBER | CMS_SEC_ACC_ID |
| .INCLUDE | Description of the securities account | ||
| SEC_ACC_DESC | Description of the Securities Account | CMS_DTE_SEC_ACC_DESC | CMS_SEC_DESC |
| ACC_OLD_REF_NO | ID of a Securities Account Referenced from External System | CMS_DTE_SEC_ACC_REF_NO | CMS_SEC_EXT_REFID |
| .INCLUDE | Valuation details of the securities account | ||
| SEC_ACC_VAL | Value of the Securities Account | CMS_DTE_SEC_ACC_VAL_AMT | CMS_SEC_AMOUNT |
| SEC_ACC_VAL_CURR | Currency of Securities Account Value | CMS_DTE_SEC_ACC_VAL_CURR | WAERS |
| VAL_DATE | Date of last valuation | CMS_DTE_SEC_ACC_VAL_DATE | CMS_DATE |
| .INCLUDE | Administrative organization unit | ||
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | TEXT12 |
| .INCLUDE | Bank area | ||
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CMS_BANKAREA |
| .INCLUDE | SEC ACC DB Asset Details - not used | ||
| .INCLUDE | Basic Asset data | ||
| RISK_CODE | Risk Code | CMS_DTE_SEC_RISK_CODE | CMS_RISK_CODE |
| SFTY_IND | Indicates that the asset has a default sfty discount or not | CMS_DTE_SEC_IND_SFTY_DISC | CMS_IND_SFTY |
| SFTY_DSCNT | Safety discount | CMS_DTE_SEC_SAFETY_DSCNT | CMS_SFTY_PCT |
| SFTY_AMOUNT | Safety discount as an amount | CMS_DTE_SEC_SAFETY_AMT | CMS_SEC_AMOUNT |
| SFTY_AMT_CURR | Currency of the Safety discount amount | CMS_DTE_SEC_SAFETY_AMT_CURR | WAERS |
| .INCLUDE | Valuation data | ||
| UNIT_VALN_FREQ | Indicator : Valuation Frequency of Securities Account | CMS_DTE_SEC_IND_FREQUENCY | CMS_IND_AST_VALN_FREQ_UNIT |
| PERIOD_VALN_FREQ | Period of revaluation for securities | CMS_DTE_SEC_VALN_FREQ_PERIOD | CMS_AST_VALN_FREQ_PERIOD |
| START_DATE | Valuation Start date | CMS_DTE_SEC_START_DATE | CMS_DATE |
| END_DATE | Valuation End date | CMS_DTE_SEC_END_DATE | CMS_DATE |
| .INCLUDE | Lending rate data | ||
| LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | CMS_DTE_SEC_IND_LND_RTE | CMS_IND_LRTE |
| .INCLUDE | Lending rates | ||
| LENDING_RATE1 | Lending rate 1 | CMS_DTE_SEC_LRTE_PCT1 | CMS_PCT |
| .INCLUDE | Liquidation rights data | ||
| LIQD_TYP | Liquidation type | CMS_DTE_SEC_LIQD_TYP | CMS_TYP |
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CMS_ATT_ID_TYP |
| LIQD_DATE | Date of Liquidation of Collateral | CMS_DTE_SEC_LIQD_DATE | CMS_DATE |
| LIQD_AMT | Proceeds obtained from liquidation of the collateral | CMS_DTE_SEC_LIQD_VALUE | CMS_SEC_AMOUNT |
| LIQD_CURR | Currency of Liquidation value | CMS_DTE_SEC_LIQD_CURR | WAERS |
| .INCLUDE | Organization unit structure:SEC | ||
| ORG_UNIT1 | Organizational Unit 1: Assets | CMS_DTE_SEC_ORG_UNIT1 | CMS_ORG_UNIT |
| ORG_UNIT2 | Organizational Unit 2: Assets | CMS_DTE_SEC_ORG_UNIT2 | CMS_ORG_UNIT |
| ORG_UNIT3 | Organizational Unit 3: Assets | CMS_DTE_SEC_ORG_UNIT3 | CMS_ORG_UNIT |
| ORG_UNIT4 | Organizational Unit 4: Assets | CMS_DTE_SEC_ORG_UNIT4 | CMS_ORG_UNIT |
| ORG_UNIT5 | Organizational Unit 5: Assets | CMS_DTE_SEC_ORG_UNIT5 | CMS_ORG_UNIT |
| .INCLUDE | Structure for history | ||
| CREATED_BY | Securities Add-On User | CMS_DTE_SEC_CR_BY | CMS_USER |
| CREATED_DATE | Created On | CMS_DTE_SEC_CR_ON | CMS_DATE |
| CREATED_TIME | Created At | CMS_DTE_SEC_CR_AT | CMS_TIME |
| LAST_CHG_BY | Last Changed By | CMS_DTE_SEC_CH_BY | CMS_USER |
| LAST_CHG_DATE | Last Changed on | CMS_DTE_SEC_CH_ON | CMS_DATE |
| LAST_CHG_TIME | Last Changed At | CMS_DTE_SEC_CH_AT | CMS_TIME |
CMS_SEC_ACC related tables
| Table | Note |
|---|---|
| CMS_SEC_ACC | Securities account details |
| TRST_SECACC_BANK | Payment Details for Securities Account |
| CMS_SEC_ACC_POS | Securities position details |
| CMS_SEC_VALUE | Securities value details for every ISIN |
| CMS_SEC_ACC_BP | Link between securities account and BuPa is stored here |
| CMS_SEC_ACC_DOC | Link between securities account and Documents is stored here |
| TRGT_SECACCGRP | Securities Account Groups (Definition) |
| TRSB_CLASFLO | CFM: Backup Table for Class Flows in Securities Account |
| TRSB_CLASFLO_REV | CFM: Backup Table for Class Flows in Securities Account |
| TRSB_SECACCTRANS | CFM: Backup Table for Securities Account Transfer |
| TRSC_LEND_TRANS | Update Types for Securities Account Transfer for Sec.Lending |
| TRSC_RECON_STA | Treasury: Status of External Securities Account Statement |
| TRSC_SECACCTRANS | Treasury: Update Type for Securities Account Transfer |
| TRSC_SECACC_TYPE | Securities Account Type |
| TRSTS_FLOWCAT | Treasury: Flow Categories for Securities Account Management |
Id for account details TablesSap bank account details TablesBank account details table in sap TablesHow to check bank account details in sap TablesSap bank account details table TablesBank account number details tables in sap TablesCustomer bank account details table in sap TablesHow to check vendor bank account details in sap Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP