CMS_SEC_ACC_POS - Securities position details
Securities position details information is stored in SAP table CMS_SEC_ACC_POS.
It is part of development package CMS_SEC in software component FS-CMS-MD-SEC. This development package consists of objects that can be grouped under "Securities: General tables and programs & Persistence layer".
It is part of development package CMS_SEC in software component FS-CMS-MD-SEC. This development package consists of objects that can be grouped under "Securities: General tables and programs & Persistence layer".
Fields for table CMS_SEC_ACC_POS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | X | CMS_STR_SEC_ACC_POS_PKY | 0 | |||
| SEC_ACC_POS_GUID | GUID for securities positions in an account | X | CMS_DTE_SEC_ACC_POS_GUID | RAW | 16 | |
| .INCLUDE | CMS_STR_SEC_ACC_LKY | 0 | ||||
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | RAW | 16 | ||
| .INCLUDE | CMS_STR_SEC_ACC_POS_BASIC | 0 | ||||
| POS_NO | Sequence Number of a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_SEQ_NO | NUMC | 8 | ||
| POS_OLD_REF_NO | ID of a Positiion Referenced from an External System | CMS_DTE_SEC_ACC_POS_REF_NO | CHAR | 64 | ||
| ISIN | Unique ID for a Position in a Securities Account | CMS_DTE_SEC_ACC_POS_ISIN | CHAR | 40 | ||
| NO_OF_UNITS | Number of Units in a Securities Position | CMS_DTE_SEC_ACC_POS_NO_UNIT | DEC | 8 | ||
| NOMINAL_VALUE | Nominal Value of a Position | CMS_DTE_SEC_ACC_POS_NVAL_AMT | CURR | 9 | ||
| NOMINAL_VAL_CURR | Currency of nominal value of a position | CMS_DTE_SEC_ACC_POS_NVAL_CURR | CUKY | 10 | TCURC | |
| .INCLUDE | CMS_STR_SEC_ACC_POS_VAL_DATA | 0 | ||||
| CURRENT_PRICE | Current Price of a Securities Postion per Unit | CMS_DTE_SEC_ACC_POS_CP_AMT | CURR | 9 | ||
| CURR_PRICE_CURR | Currency of Current Price of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_CURR | CUKY | 10 | TCURC | |
| CURR_PRICE_PCT | Current Price of a Unit of a Securities Position | CMS_DTE_SEC_ACC_POS_CP_PCT | DEC | 6 | ||
| CURR_PRICE_AT | Position value recording Timestamp | CMS_DTE_SEC_CPRICE_TSTMPS | NUMC | 30 | ||
| MARKET_VALUE | Market Value of a Securities Position | CMS_DTE_SEC_ACC_POS_MKT_VAL | CURR | 9 | ||
| MARKET_VAL_CURR | Currency of the Market Value of Securities Positions | CMS_DTE_SEC_ACC_POS_MKT_CURR | CUKY | 10 | TCURC | |
| .INCLUDE | CMS_STR_SEC_POS_CONV_MKT_VAL | 0 | ||||
| CON_MKT_VAL | Market Value of a Securities Account Position | CMS_DTE_SEC_ACC_POS_CONMKT_VAL | CURR | 9 | ||
| CON_MKT_VAL_CURR | Currency of Converted Market Value of Positions | CMS_DTE_SEC_POS_CONMKTVAL_CURR | CUKY | 10 | * | |
| .INCLUDE | CMS_STR_SEC_AST_BASIC_DATA | 0 | ||||
| RISK_CODE | Risk Code | CMS_DTE_SEC_RISK_CODE | CHAR | 12 | TCMS_RISKCODE | |
| SFTY_IND | Indicates that the asset has a default sfty discount or not | CMS_DTE_SEC_IND_SFTY_DISC | CHAR | 4 | ||
| SFTY_DSCNT | Safety discount | CMS_DTE_SEC_SAFETY_DSCNT | DEC | 6 | ||
| SFTY_AMOUNT | Safety discount as an amount | CMS_DTE_SEC_SAFETY_AMT | CURR | 9 | ||
| SFTY_AMT_CURR | Currency of the Safety discount amount | CMS_DTE_SEC_SAFETY_AMT_CURR | CUKY | 10 | TCURC | |
| .INCLUDE | CMS_STR_SEC_LND_RTE_DATA | 0 | ||||
| LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | CMS_DTE_SEC_IND_LND_RTE | CHAR | 4 | ||
| .INCLUDE | LENDING_RATE | CMS_STR_SEC_LENDING_RATE | 0 | |||
| LENDING_RATE1 | Lending rate 1 | CMS_DTE_SEC_LRTE_PCT1 | DEC | 6 | ||
| .INCLUDE | CMS_STR_SEC_LIQDTN_DATA_DB | 0 | ||||
| LIQD_TYP | Liquidation type | CMS_DTE_SEC_LIQD_TYP | CHAR | 12 | ||
| LIQD_REASON | Liquidation Reason | CMS_DTE_ATT_ID_TY_AST004 | CHAR | 12 | ||
| LIQD_DATE | Date of Liquidation of Collateral | CMS_DTE_SEC_LIQD_DATE | DATS | 16 | ||
| LIQD_AMT | Proceeds obtained from liquidation of the collateral | CMS_DTE_SEC_LIQD_VALUE | CURR | 9 | ||
| LIQD_CURR | Currency of Liquidation value | CMS_DTE_SEC_LIQD_CURR | CUKY | 10 | TCURC | |
| EXP_PRCD_AMNT | Expected Proceed Amount | CMS_DTE_LIQ_EXP_PRCD_AMOUNT | CURR | 9 | ||
| EXP_PRCD_CURR | Currency: Expected Proceed | CMS_DTE_LIQ_EXP_PRCD_CURR | CUKY | 10 | TCURC | |
| EXP_ACC_DATE | Expected accrual date | CMS_DTE_LIQ_EXP_ACCRUAL_DATE | DATS | 16 | ||
| .INCLUDE | CMS_STR_LIQ_ACC_DET | 0 | ||||
| ACC_NUMBER_LIQ | Account number for liquidation proceeds | CMS_DTE_LIQ_ACC_NUMBER | CHAR | 70 | ||
| BANK_CNTRY_LIQ | Key of Bank Country/Region | CMS_DTE_LIQ_BNK_CTRY_KY | CHAR | 6 | T005 | |
| BANK_KEY_LIQ | Bank Key | CMS_DTE_LIQ_BNK_KEY | CHAR | 30 | ||
| BANK_CTRLKEY_LIQ | Bank Control Key | BKONT | CHAR | 4 | ||
| .INCLUDE | CMS_STR_SEC_HIST | 0 | ||||
| CREATED_BY | Securities Add-On User | CMS_DTE_SEC_CR_BY | CHAR | 24 | ||
| CREATED_DATE | Created On | CMS_DTE_SEC_CR_ON | DATS | 16 | ||
| CREATED_TIME | Created At | CMS_DTE_SEC_CR_AT | TIMS | 12 | ||
| LAST_CHG_BY | Last Changed By | CMS_DTE_SEC_CH_BY | CHAR | 24 | ||
| LAST_CHG_DATE | Last Changed on | CMS_DTE_SEC_CH_ON | DATS | 16 | ||
| LAST_CHG_TIME | Last Changed At | CMS_DTE_SEC_CH_AT | TIMS | 12 |