1. SAP Tutorial
  2. Financial Services

CMS_SEC_ACC_POS SAP table for – Securities position details

Here we would like to draw your attention to CMS_SEC_ACC_POS 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_ACC_POS is a SAP standard transp table used for storing Securities position details related data in SAP. It comes under the package CMS_SEC.

SAP CMS_SEC_ACC_POS table

Table CMS_SEC_ACC_POS technical data

TableCMS_SEC_ACC_POS
Data storingSecurities position details
ModuleFS
Sub ModuleFS-CMS-MD-SEC
SAP PackageCMS_SEC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_SEC_ACC_POS 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_ACC_POS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for positions
    Its a key field.
  • SEC_ACC_POS_GUID : GUID for securities positions in an account
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for the securities account
  • SEC_ACC_GUID : GUID for securities account
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Basic position details of a securities account
  • POS_NO : Sequence Number of a Position in a Securities Account
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • POS_OLD_REF_NO : ID of a Positiion Referenced from an External System
    Its data type is CHAR (Character String) with field length 32
  • ISIN : Unique ID for a Position in a Securities Account
    Its data type is CHAR (Character String) with field length 20
  • NO_OF_UNITS : Number of Units in a Securities Position
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • NOMINAL_VALUE : Nominal Value of a Position
    Its data type is CURR (Currency Field) with field length 17
  • NOMINAL_VAL_CURR : Currency of nominal value of a position
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Valuation details of securities positions
  • 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 : Position value recording Timestamp
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • MARKET_VALUE : Market Value of a Securities Position
    Its data type is CURR (Currency Field) with field length 17
  • MARKET_VAL_CURR : Currency of the Market Value of Securities Positions
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Market value of positions converted to sec account currency
  • CON_MKT_VAL : Market Value of a Securities Account Position
    Its data type is CURR (Currency Field) with field length 17
  • CON_MKT_VAL_CURR : Currency of Converted Market Value of Positions
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Basic Asset data
  • RISK_CODE : Risk Code
    Its data type is CHAR (Character String) with field length 6
  • SFTY_IND : Indicates that the asset has a default sfty discount or not
    Its data type is CHAR (Character String) with field length 2
  • SFTY_DSCNT : Safety discount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SFTY_AMOUNT : Safety discount as an amount
    Its data type is CURR (Currency Field) with field length 17
  • SFTY_AMT_CURR : Currency of the Safety discount amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Lending rate data
  • LENDING_RATE_IND : Indicates that the asset has a default lending rate or not
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Lending rates
  • LENDING_RATE1 : Lending rate 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Liquidation rights data
  • LIQD_TYP : Liquidation type
    Its data type is CHAR (Character String) with field length 6
  • LIQD_REASON : Liquidation Reason
    Its data type is CHAR (Character String) with field length 6
  • LIQD_DATE : Date of Liquidation of Collateral
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LIQD_AMT : Proceeds obtained from liquidation of the collateral
    Its data type is CURR (Currency Field) with field length 17
  • LIQD_CURR : Currency of Liquidation value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Structure for history
  • CREATED_BY : Securities Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

    • CMS_SEC_ACC_POS related tables

    • CMS_SEC_ACC_BP : Link between securities account and BuPa is stored here
    • TCMS_SEC_CL_TY_T : Text table securities classification types
    • CMS_SEC_ACC_POS : Securities position details
    • CMS_SEC_CL_MST : Class master data in external system for every ISIN number
    • CMS_SEC_ACC_DOC : Link between securities account and Documents is stored here
    • CMS_SEC_VALUE : Securities value details for every ISIN
    • TCMS_SEC_CL_TYP : Securities classification types
    • TCMS_SEC_AST : Asset type for securities accounts
    • CMS_SEC_ACC : Securities account details

    CMS_SEC_ACC_POS related transaction codes under SAP package CMS_SEC

    • CMS_DEL_SUBAST_SEC : Delete wrong subassets for Sec acc
    • CMS_SEC_ISIN : Maintain class master data for ISINs
    • CMS_SEC_ISIN_PRICE : Maintain price data for ISINs

    Related References

    Related Tutorials

    CMS_SEC_ACC SAP table for – Securities account details

    CMS_SEC_ACC table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Securities...

    CMS_SEC_VALUE SAP table for – Securities value details for every ISIN

    CMS_SEC_VALUE table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Securities...

    CMS_SEC_ACC_DOC SAP table for – Link between securities account and Documents is stored here

    CMS_SEC_ACC_DOC table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Link...

    CMS_SEC_ACC_BP SAP table for – Link between securities account and BuPa is stored here

    CMS_SEC_ACC_BP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Link...

    TCMS_SEC_CL_TYP SAP table for – Securities classification types

    TCMS_SEC_CL_TYP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Securities...

    TCMS_SEC_AST SAP table for – Asset type for securities accounts

    TCMS_SEC_AST table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Asset...

    TCMS_SEC_CL_TY_T SAP table for – Text table securities classification types

    TCMS_SEC_CL_TY_T table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Text...

    «
    »