SAP Securities Tables

Are you looking for the right table related to SAP Securities Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Securities (FS-CMS-MD-SEC) module.

List of tables in Securities

TableDescription
CMS_SEC_ACCSecurities account details
CMS_SEC_ACC_BPLink between securities account and BuPa is stored here
CMS_SEC_ACC_DOCLink between securities account and Documents is stored here
CMS_SEC_ACC_POSSecurities position details
CMS_SEC_CL_MSTClass master data in external system for every ISIN number
CMS_SEC_VALUESecurities value details for every ISIN
TCMS_SEC_ASTAsset type for securities accounts
TCMS_SEC_CL_TYPSecurities classification types
TCMS_SEC_CL_TY_TText table securities classification types