SAP ABAP Table MSQSYSIDX (MS SQL Server: Index Details ( As From Sysindexes ))
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
Basic Data
Table Category INTTAB    Structure 
Structure MSQSYSIDX   Table Relationship Diagram
Short Description MS SQL Server: Index Details ( As From Sysindexes )    
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 TABLEID MSQTABID INT4 INT4 10   0   MS SQL Server table ID  
2 STATUS MSQIDXSTAT INT4 INT4 10   0   MS SQL server index status  
3 FIRSTPAG MSQIDFIRPG MSQHEX6 RAW 6   0   MS SQL server index pointer to the first or root page.  
4 INDID MSQIDXID INT2 INT2 5   0   MS SQL Server index ID  
5 ROOT MSQIDXROOT MSQHEX6 RAW 6   0   MS SQL server pointer to the root page of the index  
6 MINLEN MSQMINLEN INT2 INT2 5   0   MS SQL server minimum size of the row.  
7 KEYCNT MSQKEYCNT INT2 INT2 5   0   MS SQL server - number of key columns in the table  
8 GROUPID MSQGROUPID INT2 INT2 5   0   MS SQL Server file group ID on which the index created  
9 DPAGES MSQDPAGES   DEC 16   0   Number of data or index pages used stated in kilobytes  
10 RESPAGES MSQRESPAG   DEC 16   0   Count of alloc. KBytes for all idxes & table data  
11 USED MSQUSEDPAG   DEC 16   0   Count of KBytes used for index and table data  
12 ROWCNT MSQROWCNT MSQHEX8 RAW 8   0   MS SQL server - number of data rows in a table.  
13 ROWMODCTR MSQMODROWS   DEC 16   0   MS SQL server - modified rows in the table since upd stats  
14 SOID MSQSOID INT2 INT2 5   0   MS SQL Server - sort order ID for the index  
15 CSID MSQCSID INT2 INT2 5   0   MS SQL Server - char. set ID that the index was created with  
16 MAXLEN MSQMAXLEN INT2 INT2 5   0   MS SQL server - maximum size of a row  
17 MAXROW MSQMAXIROW INT2 INT2 5   0   MS SQL server - maximum size of a nonleaf index row.  
18 FILLFAC MSQORIFILL INT2 INT2 5   0   MS SQL server index's original fill factor  
19 FIRSTIAM MSQFSTIAM MSQHEX6 RAW 6   0   First IAM page of the table or index  
20 LOCKFLAGS MSQLOCKFLG INT2 INT2 5   0   MS sql server locking flags for the table  
21 PGMODCTR MSQMODPAGS   DEC 16   0   MS SQL server modified pages in the table.  
22 KEYS MSQKEYS MSQHEX512 RAW 512   0   MS SQL server table keys  
23 NAME MSQTABNAME CHAR256 CHAR 256   0   MS SQL server table or index name  
History
Last changed by/on SAP  20130604 
SAP Release Created in