SAP Table CMS_SEC_ACC_POS
Securities position details
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
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 |