1. SAP Tutorial
  2. Financial Services

CMS_SEC_ACC SAP table for – Securities account details

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

SAP CMS_SEC_ACC table

Table CMS_SEC_ACC technical data

TableCMS_SEC_ACC
Data storingSecurities account 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 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 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Structure for Account GUID
    Its a key field.
  • SEC_ACC_GUID : GUID for securities account
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for account id of a securities account
  • DEPO_BANK_ID : Depository Bank Identification
    Its data type is CHAR (Character String) with field length 18
  • ACCOUNT_NUMBER : Securities Account Identification Number
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Description of the securities account
  • SEC_ACC_DESC : Description of the Securities Account
    Its data type is CHAR (Character String) with field length 30
  • ACC_OLD_REF_NO : ID of a Securities Account Referenced from External System
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Valuation details of the securities account
  • SEC_ACC_VAL : Value of the Securities Account
    Its data type is CURR (Currency Field) with field length 17
  • SEC_ACC_VAL_CURR : Currency of Securities Account Value
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VAL_DATE : Date of last valuation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : SEC ACC DB Asset Details – not used
  • .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 : Valuation data
  • UNIT_VALN_FREQ : Indicator : Valuation Frequency of Securities Account
    Its data type is CHAR (Character String) with field length 2
  • PERIOD_VALN_FREQ : Period of revaluation for securities
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • START_DATE : Valuation Start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_DATE : Valuation End date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .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 : Organization unit structure:SEC
  • ORG_UNIT1 : Organizational Unit 1: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT2 : Organizational Unit 2: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT3 : Organizational Unit 3: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT4 : Organizational Unit 4: Assets
    Its data type is CHAR (Character String) with field length 10
  • ORG_UNIT5 : Organizational Unit 5: Assets
    Its data type is CHAR (Character String) with field length 10
  • .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 related tables

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

    CMS_SEC_ACC related transaction codes under SAP package CMS_SEC

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

    Related References

    Related Tutorials

    CMS_SEC_ACC_POS SAP table for – Securities position details

    CMS_SEC_ACC_POS 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...

    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...

    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...

    «
    »