SAP Table MSQSYSIDX
MS SQL Server: Index Details ( As From Sysindexes )
MSQSYSIDX (MS SQL Server: Index Details ( As From Sysindexes )) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSQSYSIDX to other SAP tables.
MSQSYSIDX table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| TABLEID | MS SQL Server table ID | MSQTABID | INT4 | 10 | 0 | |||
| STATUS | MS SQL server index status | MSQIDXSTAT | INT4 | 10 | 0 | |||
| FIRSTPAG | MS SQL server index pointer to the first or root page. | MSQIDFIRPG | RAW | 6 | 0 | |||
| INDID | MS SQL Server index ID | MSQIDXID | INT2 | 5 | 0 | |||
| ROOT | MS SQL server pointer to the root page of the index | MSQIDXROOT | RAW | 6 | 0 | |||
| MINLEN | MS SQL server minimum size of the row. | MSQMINLEN | INT2 | 5 | 0 | |||
| KEYCNT | MS SQL server - number of key columns in the table | MSQKEYCNT | INT2 | 5 | 0 | |||
| GROUPID | MS SQL Server file group ID on which the index created | MSQGROUPID | INT2 | 5 | 0 | |||
| DPAGES | Number of data or index pages used stated in kilobytes | MSQDPAGES | DEC | 16 | 0 | |||
| RESPAGES | Count of alloc. KBytes for all idxes & table data | MSQRESPAG | DEC | 16 | 0 | |||
| USED | Count of KBytes used for index and table data | MSQUSEDPAG | DEC | 16 | 0 | |||
| ROWCNT | MS SQL server - number of data rows in a table. | MSQROWCNT | RAW | 8 | 0 | |||
| ROWMODCTR | MS SQL server - modified rows in the table since upd stats | MSQMODROWS | DEC | 16 | 0 | |||
| SOID | MS SQL Server - sort order ID for the index | MSQSOID | INT2 | 5 | 0 | |||
| CSID | MS SQL Server - char. set ID that the index was created with | MSQCSID | INT2 | 5 | 0 | |||
| MAXLEN | MS SQL server - maximum size of a row | MSQMAXLEN | INT2 | 5 | 0 | |||
| MAXROW | MS SQL server - maximum size of a nonleaf index row. | MSQMAXIROW | INT2 | 5 | 0 | |||
| FILLFAC | MS SQL server index's original fill factor | MSQORIFILL | INT2 | 5 | 0 | |||
| FIRSTIAM | First IAM page of the table or index | MSQFSTIAM | RAW | 6 | 0 | |||
| LOCKFLAGS | MS sql server locking flags for the table | MSQLOCKFLG | INT2 | 5 | 0 | |||
| PGMODCTR | MS SQL server modified pages in the table. | MSQMODPAGS | DEC | 16 | 0 | |||
| KEYS | MS SQL server table keys | MSQKEYS | RAW | 512 | 0 | |||
| NAME | MS SQL server table or index name | MSQTABNAME | CHAR | 256 | 0 | |||
