CMS_SEC_ACC_POS is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_SEC_ACC_POS in SAP.
- Table description : Securities position 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_POS Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| .INCLUDE | Primary key for positions | ||
| SEC_ACC_POS_GUID | GUID for securities positions in an account | CMS_DTE_SEC_ACC_POS_GUID | SYSUUID |
| .INCLUDE | Link structure for the securities account | ||
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | SYSUUID |
| .INCLUDE | Basic position details of a securities account | ||
| POS_NO | Sequence Number of a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_SEQ_NO | CMS_SEC_POS_ID |
| POS_OLD_REF_NO | ID of a Positiion Referenced from an External System | CMS_DTE_SEC_ACC_POS_REF_NO | CMS_SEC_EXT_REFID |
| ISIN | Unique ID for a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_ISIN | CMS_SEC_POS_ISIN |
| NO_OF_UNITS | Number of Units in a Securities Position | CMS_DTE_SEC_ACC_POS_NO_UNIT | CMS_SEC_UNITS |
| NOMINAL_VALUE | Nominal Value of a Position | CMS_DTE_SEC_ACC_POS_NVAL_AMT | CMS_SEC_AMOUNT |
| NOMINAL_VAL_CURR | Currency of nominal value of a position | CMS_DTE_SEC_ACC_POS_NVAL_CURR | WAERS |
| .INCLUDE | Valuation details of securities positions | ||
| CURRENT_PRICE | Current Price of a Securities Postion per Unit | CMS_DTE_SEC_ACC_POS_CP_AMT | CMS_SEC_AMOUNT |
| CURR_PRICE_CURR | Currency of Current Price of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_CURR | WAERS |
| CURR_PRICE_PCT | Current Price of a Unit of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_PCT | CMS_SEC_PCT |
| CURR_PRICE_AT | Position value recording Timestamp | CMS_DTE_SEC_CPRICE_TSTMPS | TZNTSTMPSL |
| MARKET_VALUE | Market Value of a Securities Position | CMS_DTE_SEC_ACC_POS_MKT_VAL | CMS_SEC_AMOUNT |
| MARKET_VAL_CURR | Currency of the Market Value of Securities Positions | CMS_DTE_SEC_ACC_POS_MKT_CURR | WAERS |
| .INCLUDE | Market value of positions converted to sec account currency | ||
| CON_MKT_VAL | Market Value of a Securities Account Position | CMS_DTE_SEC_ACC_POS_CONMKT_VAL | CMS_SEC_AMOUNT |
| CON_MKT_VAL_CURR | Currency of Converted Market Value of Positions | CMS_DTE_SEC_POS_CONMKTVAL_CURR | WAERS |
| .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 | 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 | 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_POS related tables
| Table | Note |
|---|---|
| CMS_SEC_ACC_POS | Securities position details |
| TRDTT_POS_SEC | Position Information for Securities |
| TRST_CLASPOS | Treasury: Class position in Securities Account |
| TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change |
| TRST_POS_CHG | CFM: Securities Account Position Change |
| VTPPOLI | Cross-Securities-Account Position |
| VWPBDEP | Bank Securities Account Position |
| VWPDEPO | Securities Account Position |
| CMS_SEC_ACC | Securities account details |
| CMS_SEC_VALUE | Securities value details for every ISIN |
| TRST_SECACC_BANK | Payment Details for Securities Account |
| AFWKFPA_POS | Key Figures: Position in Position Currency |
| AFWKF_POS_H | Key Figures: Position in Position Currency |
| JBDBEWE | Position Flows Generated by Position Changes |
| JBDUBPO | Position Items for Non-Interest-Bearing Position |
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