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
| Table | Description |
|---|---|
| DD12MSS | Index Parameters for MS SQL Server |
| DD02MSS | Table Parameters for Microsoft SQL Server |
| MSSSTORAGE | MSSQL-Specific Storage Parameters for Tables and Indexes |
| TAMSS | Table Category-Table Memory Parameter Assignment for MSS |
| DBSTATTMSS | Table sizes |
| MSSPROCS | MS SQL Server: Stored Procedures |
| IGMSS | Table Category-Index Memory Parameter Assignment for MSS |
| MSSSOURCE | MS SQL Server: Stored Procedures Source Code |
| TGMSS | Table Category-Table Memory Parameter Assignment for MSS |
| MSSDWDLLS | Holds records on the dlls in the disp+work |
List of tables in SQL Server in SAP NetWeaver Products
| Table | Description |
|---|---|
| DD12MSS | Index Parameters for MS SQL Server |
| DD02MSS | Table Parameters for Microsoft SQL Server |
| MSSSTORAGE | MSSQL-Specific Storage Parameters for Tables and Indexes |
| TAMSS | Table Category-Table Memory Parameter Assignment for MSS |
| DBSTATTMSS | Table sizes |
| MSSPROCS | MS SQL Server: Stored Procedures |
| IGMSS | Table Category-Index Memory Parameter Assignment for MSS |
| MSSSOURCE | MS SQL Server: Stored Procedures Source Code |
| TGMSS | Table Category-Table Memory Parameter Assignment for MSS |
| MSSDWDLLS | Holds records on the dlls in the disp+work |
| IAMSS | Table Category-Index Memory Parameter Assignment for MSS |
| MSSNETCHECK | capture db and network times for known query for SQL Server |
| MSSPPACK | MSSQL : list of DB performance snapshots |
| MSQSNAP | MS SQL Server: Database performance snapshot |
| MSSSPVERS | MS SQL Server: Database Release and Stored Proc. Revision |
| MSSDEADLCK | Database Deadlock Information for MSSQL Server |
| MSSROWSET | MSSQL : DB performance snapshot data |