SAP SQL Server in SAP NetWeaver Products Tables

Are you looking for the right table related to SAP SQL Server in SAP NetWeaver Products 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 SQL Server in SAP NetWeaver Products (BC-DB-MSS) module.

Top 10 tables in SQL Server in SAP NetWeaver Products

TableDescription
DD12MSSIndex Parameters for MS SQL Server
DD02MSSTable Parameters for Microsoft SQL Server
MSSSTORAGEMSSQL-Specific Storage Parameters for Tables and Indexes
TAMSSTable Category-Table Memory Parameter Assignment for MSS
DBSTATTMSSTable sizes
MSSPROCSMS SQL Server: Stored Procedures
IGMSSTable Category-Index Memory Parameter Assignment for MSS
MSSSOURCEMS SQL Server: Stored Procedures Source Code
TGMSSTable Category-Table Memory Parameter Assignment for MSS
MSSDWDLLSHolds records on the dlls in the disp+work

List of tables in SQL Server in SAP NetWeaver Products

TableDescription
DD12MSSIndex Parameters for MS SQL Server
DD02MSSTable Parameters for Microsoft SQL Server
MSSSTORAGEMSSQL-Specific Storage Parameters for Tables and Indexes
TAMSSTable Category-Table Memory Parameter Assignment for MSS
DBSTATTMSSTable sizes
MSSPROCSMS SQL Server: Stored Procedures
IGMSSTable Category-Index Memory Parameter Assignment for MSS
MSSSOURCEMS SQL Server: Stored Procedures Source Code
TGMSSTable Category-Table Memory Parameter Assignment for MSS
MSSDWDLLSHolds records on the dlls in the disp+work
IAMSSTable Category-Index Memory Parameter Assignment for MSS
MSSNETCHECKcapture db and network times for known query for SQL Server
MSSPPACKMSSQL : list of DB performance snapshots
MSQSNAPMS SQL Server: Database performance snapshot
MSSSPVERSMS SQL Server: Database Release and Stored Proc. Revision
MSSDEADLCKDatabase Deadlock Information for MSSQL Server
MSSROWSETMSSQL : DB performance snapshot data