SAP ABAP Table MSQTABSTAT (MS SQL server table statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSQTABSTAT |
Table Relationship Diagram 
|
| Short Description | MS SQL server table statistics |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  RESERVED |
MSQTABRES | INT4 | INT4 | 10 | 0 | MS SQL server - reserved size of the table | ||
| 2 | DATASIZE |
MSQTABTOT | INT4 | INT4 | 10 | 0 | MS SQL server - Total used size of the table | ||
| 3 | INDEXSIZE |
MSQTOTINSZ | DEC | 16 | 0 | Size of all indexes in the database in KB. | |||
| 4 | UNUSEDSIZE |
MSQTABUNUD | INT4 | INT4 | 10 | 0 | MS SQL server - total unused space | ||
| 5 | TOTALROWS |
MSQTABROWS | DEC | 16 | 0 | MS SQL server - number of rows in a table | |||
| 6 | MINLEN |
MSQMINLEN | INT2 | INT2 | 5 | 0 | MS SQL server minimum size of the row. | ||
| 7 | MAXLEN |
MSQMAXLEN | INT2 | INT2 | 5 | 0 | MS SQL server - maximum size of a row | ||
| 8 | ROWMODCTR |
MSQMODROWS | DEC | 16 | 0 | MS SQL server - modified rows in the table since upd stats | |||
| 9 | SCHEMAVER |
MSQSCHEVER | INT4 | INT4 | 10 | 0 | The count of changes in schema of a given object |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
