Menu

SAP Table CMS_SEC_ACC_POS

Securities position details

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