MSQSYSIDX SAP (MS SQL Server: Index Details ( As From Sysindexes )) Structure details

Dictionary Type: Structure
Description: MS SQL Server: Index Details ( As From Sysindexes )




ABAP Code to SELECT data from MSQSYSIDX
Related tables to MSQSYSIDX
Access table MSQSYSIDX




Structure field list including key, data, relationships and ABAP select examples

MSQSYSIDX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "MS SQL Server: Index Details ( As From Sysindexes )" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MSQSYSIDX TYPE MSQSYSIDX.

The MSQSYSIDX table consists of various fields, each holding specific information or linking keys about MS SQL Server: Index Details ( As From Sysindexes ) data available in SAP. These include STATUS (MS SQL server index status), FIRSTPAG (MS SQL server index pointer to the first or root page.), INDID (MS SQL Server index ID), ROOT (MS SQL server pointer to the root page of the index).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP MSQSYSIDX structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TABLEIDMS SQL Server table ID MSQTABIDINT410INT4
STATUSMS SQL server index status MSQIDXSTATINT410INT4
FIRSTPAGMS SQL server index pointer to the first or root page. MSQIDFIRPGRAW6MSQHEX6
INDIDMS SQL Server index ID MSQIDXIDINT25INT2
ROOTMS SQL server pointer to the root page of the index MSQIDXROOTRAW6MSQHEX6
MINLENMS SQL server minimum size of the row. MSQMINLENINT25INT2
KEYCNTMS SQL server - number of key columns in the table MSQKEYCNTINT25INT2
GROUPIDMS SQL Server file group ID on which the index created MSQGROUPIDINT25INT2
DPAGESNumber of data or index pages used stated in kilobytes MSQDPAGESDEC16
RESPAGESCount of alloc. KBytes for all idxes & table data MSQRESPAGDEC16
USEDCount of KBytes used for index and table data MSQUSEDPAGDEC16
ROWCNTMS SQL server - number of data rows in a table. MSQROWCNTRAW8MSQHEX8
ROWMODCTRMS SQL server - modified rows in the table since upd stats MSQMODROWSDEC16
SOIDMS SQL Server - sort order ID for the index MSQSOIDINT25INT2
CSIDMS SQL Server - char. set ID that the index was created with MSQCSIDINT25INT2
MAXLENMS SQL server - maximum size of a row MSQMAXLENINT25INT2
MAXROWMS SQL server - maximum size of a nonleaf index row. MSQMAXIROWINT25INT2
FILLFACMS SQL server index's original fill factor MSQORIFILLINT25INT2
FIRSTIAMFirst IAM page of the table or index MSQFSTIAMRAW6MSQHEX6
LOCKFLAGSMS sql server locking flags for the table MSQLOCKFLGINT25INT2
PGMODCTRMS SQL server modified pages in the table. MSQMODPAGSDEC16
KEYSMS SQL server table keys MSQKEYSRAW512MSQHEX512
NAMEMS SQL server table or index name MSQTABNAMECHAR256CHAR256

Key field Non-key field



How do I retrieve data from SAP structure MSQSYSIDX using ABAP code?

As MSQSYSIDX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSQSYSIDX as there is no data to select.

How to access SAP table MSQSYSIDX

Within an ECC or HANA version of SAP you can also view further information about MSQSYSIDX and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!