SAP Table CMS_SEC_ACC_POS
Securities position details
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table CMS_SEC_ACC_POS (Securities position details) is a standard table in SAP ERP. It belongs to the package CMS_SEC.
Technical Information
| Table | CMS_SEC_ACC_POS |
| Short Text | Securities position details |
| Package | CMS_SEC |
| Table Type | Transparent Table |
Fields for Table CMS_SEC_ACC_POS
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| SEC_ACC_POS_GUID | ✔ | GUID for securities positions in an account | CMS_DTE_SEC_ACC_POS_GUID | RAW | 16 | |
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | RAW | 16 | ||
| POS_NO | Sequence Number of a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_SEQ_NO | NUMC | 4 | ||
| POS_OLD_REF_NO | ID of a Positiion Referenced from an External System | CMS_DTE_SEC_ACC_POS_REF_NO | CHAR | 32 | ||
| ISIN | Unique ID for a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_ISIN | CHAR | 20 | ||
| NO_OF_UNITS | Number of Units in a Securities Position | CMS_DTE_SEC_ACC_POS_NO_UNIT | DEC | 15 | ||
| NOMINAL_VALUE | Nominal Value of a Position | CMS_DTE_SEC_ACC_POS_NVAL_AMT | CURR | 17 | ||
| NOMINAL_VAL_CURR | Currency of nominal value of a position | CMS_DTE_SEC_ACC_POS_NVAL_CURR | CUKY | 5 | TCURC | |
| CURRENT_PRICE | Current Price of a Securities Postion per Unit | CMS_DTE_SEC_ACC_POS_CP_AMT | CURR | 17 | ||
| CURR_PRICE_CURR | Currency of Current Price of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_CURR | CUKY | 5 | TCURC | |
| CURR_PRICE_PCT | Current Price of a Unit of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_PCT | DEC | 10 | ||
| CURR_PRICE_AT | Position value recording Timestamp | CMS_DTE_SEC_CPRICE_TSTMPS | NUMC | 15 | ||
| MARKET_VALUE | Market Value of a Securities Position | CMS_DTE_SEC_ACC_POS_MKT_VAL | CURR | 17 | ||
| MARKET_VAL_CURR | Currency of the Market Value of Securities Positions | CMS_DTE_SEC_ACC_POS_MKT_CURR | CUKY | 5 | TCURC | |
| CON_MKT_VAL | Market Value of a Securities Account Position | CMS_DTE_SEC_ACC_POS_CONMKT_VAL | CURR | 17 | ||
| CON_MKT_VAL_CURR | Currency of Converted Market Value of Positions | CMS_DTE_SEC_POS_CONMKTVAL_CURR | CUKY | 5 | * | |
| RISK_CODE | Risk Code | CMS_DTE_SEC_RISK_CODE | CHAR | 6 | TCMS_RISKCODE | |
| SFTY_IND | Indicates that the asset has a default sfty discount or not | CMS_DTE_SEC_IND_SFTY_DISC | CHAR | 2 | ||
| SFTY_DSCNT | Safety discount | CMS_DTE_SEC_SAFETY_DSCNT | DEC | 10 | ||
| SFTY_AMOUNT | Safety discount as an amount | CMS_DTE_SEC_SAFETY_AMT | CURR | 17 | ||
| SFTY_AMT_CURR | Currency of the Safety discount amount | CMS_DTE_SEC_SAFETY_AMT_CURR | CUKY | 5 | TCURC | |
| LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | CMS_DTE_SEC_IND_LND_RTE | CHAR | 2 | ||
| LENDING_RATE1 | Lending rate 1 | CMS_DTE_SEC_LRTE_PCT1 | DEC | 10 | ||
| LIQD_TYP | Liquidation type | CMS_DTE_SEC_LIQD_TYP | CHAR | 6 | ||
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CHAR | 6 | ||
| LIQD_DATE | Date of Liquidation of Collateral | CMS_DTE_SEC_LIQD_DATE | DATS | 8 | ||
| LIQD_AMT | Proceeds obtained from liquidation of the collateral | CMS_DTE_SEC_LIQD_VALUE | CURR | 17 | ||
| LIQD_CURR | Currency of Liquidation value | CMS_DTE_SEC_LIQD_CURR | CUKY | 5 | TCURC | |
| CREATED_BY | Securities Add-On User | CMS_DTE_SEC_CR_BY | CHAR | 12 | ||
| CREATED_DATE | Created On | CMS_DTE_SEC_CR_ON | DATS | 8 | ||
| CREATED_TIME | Created At | CMS_DTE_SEC_CR_AT | TIMS | 6 | ||
| LAST_CHG_BY | Last Changed By | CMS_DTE_SEC_CH_BY | CHAR | 12 | ||
| LAST_CHG_DATE | Last Changed on | CMS_DTE_SEC_CH_ON | DATS | 8 | ||
| LAST_CHG_TIME | Last Changed At | CMS_DTE_SEC_CH_AT | TIMS | 6 |