Data Element list used by SAP ABAP Table MSQSYSIDX (MS SQL Server: Index Details ( As From Sysindexes ))
SAP ABAP Table 
MSQSYSIDX (MS SQL Server: Index Details ( As From Sysindexes )) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQCSID | MS SQL Server - char. set ID that the index was created with | |
| 2 | Data Element |
MSQDPAGES | Number of data or index pages used stated in kilobytes | |
| 3 | Data Element |
MSQFSTIAM | First IAM page of the table or index | |
| 4 | Data Element |
MSQGROUPID | MS SQL Server file group ID on which the index created | |
| 5 | Data Element |
MSQIDFIRPG | MS SQL server index pointer to the first or root page. | |
| 6 | Data Element |
MSQIDXID | MS SQL Server index ID | |
| 7 | Data Element |
MSQIDXROOT | MS SQL server pointer to the root page of the index | |
| 8 | Data Element |
MSQIDXSTAT | MS SQL server index status | |
| 9 | Data Element |
MSQKEYCNT | MS SQL server - number of key columns in the table | |
| 10 | Data Element |
MSQKEYS | MS SQL server table keys | |
| 11 | Data Element |
MSQLOCKFLG | MS sql server locking flags for the table | |
| 12 | Data Element |
MSQMAXIROW | MS SQL server - maximum size of a nonleaf index row. | |
| 13 | Data Element |
MSQMAXLEN | MS SQL server - maximum size of a row | |
| 14 | Data Element |
MSQMINLEN | MS SQL server minimum size of the row. | |
| 15 | Data Element |
MSQMODPAGS | MS SQL server modified pages in the table. | |
| 16 | Data Element |
MSQMODROWS | MS SQL server - modified rows in the table since upd stats | |
| 17 | Data Element |
MSQORIFILL | MS SQL server index's original fill factor | |
| 18 | Data Element |
MSQRESPAG | Count of alloc. KBytes for all idxes & table data | |
| 19 | Data Element |
MSQROWCNT | MS SQL server - number of data rows in a table. | |
| 20 | Data Element |
MSQSOID | MS SQL Server - sort order ID for the index | |
| 21 | Data Element |
MSQTABID | MS SQL Server table ID | |
| 22 | Data Element |
MSQTABNAME | MS SQL server table or index name | |
| 23 | Data Element |
MSQUSEDPAG | Count of KBytes used for index and table data |
