CMS_SEC_VALUE SAP table for – Securities value details for every ISIN

Here we would like to draw your attention to CMS_SEC_VALUE table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_SEC_VALUE is a SAP standard transp table used for storing Securities value details for every ISIN related data in SAP. It comes under the package CMS_SEC.

SAP CMS_SEC_VALUE table

Table CMS_SEC_VALUE technical data

TableCMS_SEC_VALUE
Data storingSecurities value details for every ISIN
ModuleFS
Sub ModuleFS-CMS-MD-SEC
SAP PackageCMS_SEC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_SEC_VALUE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_SEC_VALUE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ISIN : Unique ID for a Position in a Securities Account
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • CURRENT_PRICE : Current Price of a Securities Postion per Unit
    Its data type is CURR (Currency Field) with field length 17
  • CURR_PRICE_CURR : Currency of Current Price of a Securities Position
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CURR_PRICE_PCT : Current Price of a Unit of a Securities Position
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • CURR_PRICE_AT : Time Stamp – Short Format
    Its data type is NUMC (Character String with Digits Only) with field length 15