CMS_SEC_ACC_POS

Securities position details | #masterdata | Component: Securities
Column Name Description
MANDT Client
SEC_ACC_POS_GUID GUID for securities positions in an account
Column Name Description
💲 Currency of nominal value of a position (NOMINAL_VAL_CURR):
NOMINAL_VALUE Nominal Value of a Position
💲 Currency of Current Price of a Securities Position (CURR_PRICE_CURR):
CURRENT_PRICE Current Price of a Securities Postion per Unit
💲 Currency of the Market Value of Securities Positions (MARKET_VAL_CURR):
MARKET_VALUE Market Value of a Securities Position
💲 Currency of Converted Market Value of Positions (CON_MKT_VAL_CURR):
CON_MKT_VAL Market Value of a Securities Account Position
💲 Currency of the Safety discount amount (SFTY_AMT_CURR):
SFTY_AMOUNT Safety discount as an amount
💲 Currency of Liquidation value (LIQD_CURR):
LIQD_AMT Proceeds obtained from liquidation of the collateral
💲 Currency: Expected Proceed (EXP_PRCD_CURR):
EXP_PRCD_AMNT Expected Proceed Amount
Column Name Description
Column Name Description
LIQD_DATE Date of Liquidation of Collateral
EXP_ACC_DATE Expected accrual date
CREATED_DATE Created On
CREATED_TIME Created At
LAST_CHG_DATE Last Changed on
LAST_CHG_TIME Last Changed At
Column Name Description
SFTY_IND Indicates that the asset has a default sfty discount or not Show values
SFTY_DSCNT Safety discount Show values
LENDING_RATE_IND Indicates that the asset has a default lending rate or not Show values
Column Name Description Domain name
SEC_ACC_GUID GUID for securities account SYSUUID
POS_NO Sequence Number of a Position in a Securities Account CMS_SEC_POS_ID
POS_OLD_REF_NO ID of a Positiion Referenced from an External System CMS_SEC_EXT_REFID
ISIN Unique ID for a Position in a Securities Account CMS_SEC_POS_ISIN
NO_OF_UNITS Number of Units in a Securities Position CMS_SEC_UNITS
CURR_PRICE_PCT Current Price of a Unit of a Securities Position CMS_SEC_PCT
CURR_PRICE_AT Position value recording Timestamp TZNTSTMPSL
LENDING_RATE1 Lending rate 1 CMS_PCT
LIQD_TYP Liquidation type CMS_TYP
LIQD_REASON Liquidation Reason CMS_ATT_ID_TYP
ACC_NUMBER_LIQ Account number for liquidation proceeds BANKN35
BANK_KEY_LIQ Bank Key BANKK
BANK_CTRLKEY_LIQ Bank Control Key BKONT
CREATED_BY Securities Add-On User CMS_USER
LAST_CHG_BY Last Changed By CMS_USER
Master Data Relations Join Conditions
Key of Bank Country/Region
  • Key of Bank Country/Region
  • Client
  • CMS_SEC_ACC_POS.BANK_CNTRY_LIQ == T005.LAND1
  • CMS_SEC_ACC_POS.MANDT == T005.MANDT
Currency of Current Price of a Securities Position
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.CURR_PRICE_CURR == TCURC.WAERS
Currency: Expected Proceed
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.EXP_PRCD_CURR == TCURC.WAERS
Currency of Liquidation value
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.LIQD_CURR == TCURC.WAERS
Currency of the Market Value of Securities Positions
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.MARKET_VAL_CURR == TCURC.WAERS
Currency of nominal value of a position
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.NOMINAL_VAL_CURR == TCURC.WAERS
Risk Code
  • Risk Code
  • Client
Currency of the Safety discount amount
  • CMS_SEC_ACC_POS.MANDT == TCURC.MANDT
  • CMS_SEC_ACC_POS.SFTY_AMT_CURR == TCURC.WAERS