SAP CMS_SEC_CL_MST Class master data in external system for every ISIN number Table data and field list

CMS_SEC_CL_MST is a standard SAP Table which is used to store Class master data in external system for every ISIN number data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_SEC_CL_MST table consists of various fields, each holding specific information or linking keys about Class master data in external system for every ISIN number data available in SAP. These include ISIN (Unique identification number for every position), SHORT_NAME (Short name of securities ISIN), SEC_POS_TYPE (Securities Classification Type), ISSUE_SOURCE (Name of Source which has Issued the Securities Position)... 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. .

CMS_SEC_CL_MST table Technical Details:

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_CL_MST table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_SEC_CL_MST table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
ISINUnique identification number for every position CMS_DTE_SEC_POS_EX_CL_MST_ISINCHAR20CMS_SEC_POS_ISIN
SHORT_NAMEShort name of securities ISIN CMS_DTE_SEC_ACC_POS_NAMECHAR40CMS_SEC_NAME
SEC_POS_TYPESecurities Classification Type CMS_DTE_SEC_ACC_POS_TYPECHAR10TCMS_SEC_CL_TYPCMS_SEC_CLASSIFICATION
ISSUE_SOURCEName of Source which has Issued the Securities Position CMS_DTE_SEC_ACC_POS_ISSUE_SRCCHAR40CMS_SEC_NAME
QUOTE_METHODMethod in which Position is Quoted during Trading CMS_DTE_SEC_ACC_POS_Q_METHODCHAR10CMS_SEC_POS_ATTRIB
STOCK_EXCHNGName of Stock Exchange where Securities Account is Traded CMS_DTE_SEC_ACC_POS_STK_EXCHNGCHAR40CMS_SEC_NAME
COUNTRY_ZONECountry Zone where the Securities Positions are Traded CMS_DTE_SEC_ACC_POS_CNTRY_ZONECHAR10CMS_SEC_POS_ATTRIB
FUNGIBILITYSpecifies Interchangeability of Securities Positions CMS_DTE_SEC_ACC_POS_FNGBLTYCHAR10CMS_SEC_POS_ATTRIB
IMP_INDEXStock Exchange Index where Securities Positions are Traded CMS_DTE_SEC_ACC_POS_IMP_INDEXCHAR40CMS_SEC_NAME
NATIONALITYCountry whose Jurisdiction is Applicable for the Securities CMS_DTE_SEC_ACC_POS_COUNTRYCHAR3Assigned to domainLAND1H_T005_LAND
POS_DESCDescription of Securities Account CMS_DTE_SEC_ACC_POS_DESCCHAR30CMS_SEC_DESC

Key field Non-key field



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

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

SELECT SINGLE *
FROM CMS_SEC_CL_MST
INTO CORRESPONDING FIELDS OF WA_CMS_SEC_CL_MST
WHERE...

How to access SAP table CMS_SEC_CL_MST

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

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