MSSDBSTATT is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of MSSDBSTATT in SAP.
- Table description : Table statistics for MS SQL Server
- Module : BC-DB-MSS-CCM
- Parent Module : BC
- Package : STUS
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP MSSDBSTATT Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| TABLENAME | Table name | MSSTABLE | MSSSYSNAME |
| TOTALROWS | Number of rows | MSSNUMROWS | |
| DATASIZE | Data size in KB | MSSDATASIZE | |
| RESERVED | Reserved size in KB | MSSRESSIZE | |
| INDEXSIZE | Index size in KB | MSSINDEXSIZE | |
| ROWMODCTR | Row modification counter | MSSROWMODCTR | |
| STATSSCHVER | Statistics schema version | MSSSTATSSCHVER | |
| INDEXDEPTH | Depth | MSSINDDEPTH | |
| NUMINDEXES | Number of indexes of a table | MSSNUMINDS | |
| NUMSTATS | Number of statistics of a table | MSSNUMSTATS | |
| STATSDATE | Last update statistics | MSSSTATSDATE | |
| TABLEOPTIONS | Table options on locking and memory | MSSTABOPTS | CHAR10 |
| BUFFSTATUS | SAP table buffering status on application server. | MSSTABBUFF | CHAR4 |
| FILEGROUP | Filegroup name | MSSFG | MSSSYSNAME |
| SCANDENSITY | Scan density | MSSSCANDENSITY | |
| LOGICALFRAG | Logical scan fragmentation | MSSLOGSCANFRAG | |
| NUMPAGES | Number of pages in index level | MSSILPAGES | |
| BESTCOUNT | Ideal number of extent changes | MSSBESTCOUNT | |
| ACTUALCOUNT | Actual number of extent changes | MSSACTCOUNT | |
| EXTENTSWITCHES | Number of extent switches | MSSEXTSWITCHES | |
| LASTTABLE | |||
| LASTRUN | |||
| LASTDURATION | Execution duration of an operation in seconds. | MSSDURATE | INT4 |
MSSDBSTATT related tables
| Table | Note |
|---|---|
| MSSDBSTATT | Table statistics for MS SQL Server |
| /SDF/SQLHIST | SQL Monitor: Delta records for top SQL statements |
| DD02MSS | Table Parameters for Microsoft SQL Server |
| MLOCKLOC | test table used in SQL Server Locking Veris |
| DD12MSS | Index Parameters for MS SQL Server |
| MSQSNAP | MS SQL Server: Database performance snapshot |
| MSSPROCS | MS SQL Server: Stored Procedures |
| MSSSOURCE | MS SQL Server: Stored Procedures Source Code |
| MSSSPVERS | MS SQL Server: Database Release and Stored Proc. Revision |
| /SDF/MSS_CUST | SQL Server Monitors in ST-PI Addon - Customizing |
| SSCOOKIE | Business Server Pages (BSP) DB Table Server-Side Cookies |
| RSDDSTATTREXQAPI | Detailed Statistics from TREX Server During Query Calls |
| RSDDSTATTREXSERV | Detailed Statistics for the TREX Server |
| ESH_QL_ST_STAT | Searchterm Statistics Table for Indexing of Statistics Data |
| CNVCDMCUCIA_STAT | Statistics data collected from the Statistics system |
Abap system field: current date of application server TablesServer TablesStatistics update indicator (post in/post out) TablesUpdate group for statistics update TablesStatistics-relevant delivery date Tables"statistics-relevant delivery date" TablesExchange rate for statistics (exch.rate at time of creation) TablesCondition is used for statistics Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP