CMS_SEC_ACC SAP (Securities account details) Table details

Dictionary Type: Table
Description: Securities account details




ABAP Code to SELECT data from CMS_SEC_ACC
Related tables to CMS_SEC_ACC
Access table CMS_SEC_ACC




Table field list including key, data, relationships and ABAP select examples

CMS_SEC_ACC is a standard SAP Table which is used to store Securities account details data and is available within R/3 SAP systems depending on the version and release level.

The CMS_SEC_ACC table consists of various fields, each holding specific information or linking keys about Securities account details data available in SAP. These include SEC_ACC_GUID (GUID for securities account), DEPO_BANK_ID (Depository Bank Identification), ACCOUNT_NUMBER (Securities Account Identification Number), SEC_ACC_DESC (Description of the Securities Account).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_SEC_ACC table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
SEC_ACC_GUIDGUID for securities account CMS_DTE_SEC_ACC_GUIDRAW16SYSUUID
DEPO_BANK_IDDepository Bank Identification CMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities Account Identification Number CMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
SEC_ACC_DESCDescription of the Securities Account CMS_DTE_SEC_ACC_DESCCHAR30CMS_SEC_DESC
ACC_OLD_REF_NOID of a Securities Account Referenced from External System CMS_DTE_SEC_ACC_REF_NOCHAR32CMS_SEC_EXT_REFID
SEC_ACC_VALValue of the Securities Account CMS_DTE_SEC_ACC_VAL_AMTCURR17(2) CMS_SEC_AMOUNT
SEC_ACC_VAL_CURRCurrency of Securities Account Value CMS_DTE_SEC_ACC_VAL_CURRCUKY5TCURCWAERS
VAL_DATEDate of last valuation CMS_DTE_SEC_ACC_VAL_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
RISK_CODERisk Code CMS_DTE_SEC_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_DTE_SEC_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_DTE_SEC_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_DTE_SEC_SAFETY_AMTCURR17(2) CMS_SEC_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_DTE_SEC_SAFETY_AMT_CURRCUKY5TCURCWAERS
UNIT_VALN_FREQIndicator : Valuation Frequency of Securities Account CMS_DTE_SEC_IND_FREQUENCYCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQPeriod of revaluation for securities CMS_DTE_SEC_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
START_DATEValuation Start date CMS_DTE_SEC_START_DATEDATS8CMS_DATE
END_DATEValuation End date CMS_DTE_SEC_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_DTE_SEC_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_DTE_SEC_LRTE_PCT1DEC10(6) CMS_PCT
LIQD_TYPLiquidation type CMS_DTE_SEC_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate of Liquidation of Collateral CMS_DTE_SEC_LIQD_DATEDATS8CMS_DATE
LIQD_AMTProceeds obtained from liquidation of the collateral CMS_DTE_SEC_LIQD_VALUECURR17(2) CMS_SEC_AMOUNT
LIQD_CURRCurrency of Liquidation value CMS_DTE_SEC_LIQD_CURRCUKY5TCURCWAERS
ORG_UNIT1Organizational Unit 1: Assets CMS_DTE_SEC_ORG_UNIT1CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2: Assets CMS_DTE_SEC_ORG_UNIT2CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3: Assets CMS_DTE_SEC_ORG_UNIT3CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4: Assets CMS_DTE_SEC_ORG_UNIT4CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5: Assets CMS_DTE_SEC_ORG_UNIT5CHAR10Assigned to domainCMS_ORG_UNIT
CREATED_BYSecurities Add-On User CMS_DTE_SEC_CR_BYCHAR12CMS_USER
CREATED_DATECreated On CMS_DTE_SEC_CR_ONDATS8CMS_DATE
CREATED_TIMECreated At CMS_DTE_SEC_CR_ATTIMS6CMS_TIME
LAST_CHG_BYLast Changed By CMS_DTE_SEC_CH_BYCHAR12CMS_USER
LAST_CHG_DATELast Changed on CMS_DTE_SEC_CH_ONDATS8CMS_DATE
LAST_CHG_TIMELast Changed At CMS_DTE_SEC_CH_ATTIMS6CMS_TIME

Key field Non-key field



How do I retrieve data from SAP table CMS_SEC_ACC using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_SEC_ACC to SELECT all data from the table
DATA: WA_CMS_SEC_ACC TYPE CMS_SEC_ACC.

SELECT SINGLE *
FROM CMS_SEC_ACC
INTO CORRESPONDING FIELDS OF WA_CMS_SEC_ACC
WHERE...

How to access SAP table CMS_SEC_ACC

Within an ECC or HANA version of SAP you can also view further information about CMS_SEC_ACC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!