SAP MSQSYSIDX table - MS SQL Server: Index Details ( As From Sysindexes ) details in SAP

SAP MSQSYSIDX table summary

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

Field list for MSQSYSIDX table on an S/4 SAP system

Details

MSQSYSIDX-TABLEID table field - MS SQL Server table ID ▼

Description: MS SQL Server table ID
Field Name: TABLEID
Data Element: MSQTABID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLEID

MSQSYSIDX-STATUS table field - MS SQL server index status ▼

Description: MS SQL server index status
Field Name: STATUS
Data Element: MSQIDXSTAT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSQSYSIDX-FIRSTPAG table field - MS SQL server index pointer to the first or root page. ▼

Description: MS SQL server index pointer to the first or root page.
Field Name: FIRSTPAG
Data Element: MSQIDFIRPG
Data Type: RAW
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTPAG

MSQSYSIDX-INDID table field - MS SQL Server index ID ▼

Description: MS SQL Server index ID
Field Name: INDID
Data Element: MSQIDXID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDID

MSQSYSIDX-ROOT table field - MS SQL server pointer to the root page of the index ▼

Description: MS SQL server pointer to the root page of the index
Field Name: ROOT
Data Element: MSQIDXROOT
Data Type: RAW
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOT

MSQSYSIDX-MINLEN table field - MS SQL server minimum size of the row. ▼

Description: MS SQL server minimum size of the row.
Field Name: MINLEN
Data Element: MSQMINLEN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MINLEN

MSQSYSIDX-KEYCNT table field - MS SQL server - number of key columns in the table ▼

Description: MS SQL server - number of key columns in the table
Field Name: KEYCNT
Data Element: MSQKEYCNT
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEYCNT

MSQSYSIDX-GROUPID table field - MS SQL Server file group ID on which the index created ▼

Description: MS SQL Server file group ID on which the index created
Field Name: GROUPID
Data Element: MSQGROUPID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GROUPID

MSQSYSIDX-DPAGES table field - Number of data or index pages used stated in kilobytes ▼

Description: Number of data or index pages used stated in kilobytes
Field Name: DPAGES
Data Element: MSQDPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DPAGES

MSQSYSIDX-RESPAGES table field - Count of alloc. KBytes for all idxes & table data ▼

Description: Count of alloc. KBytes for all idxes & table data
Field Name: RESPAGES
Data Element: MSQRESPAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RESPAGES

MSQSYSIDX-USED table field - Count of KBytes used for index and table data ▼

Description: Count of KBytes used for index and table data
Field Name: USED
Data Element: MSQUSEDPAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USED

MSQSYSIDX-ROWCNT table field - MS SQL server - number of data rows in a table. ▼

Description: MS SQL server - number of data rows in a table.
Field Name: ROWCNT
Data Element: MSQROWCNT
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWCNT

MSQSYSIDX-ROWMODCTR table field - MS SQL server - modified rows in the table since upd stats ▼

Description: MS SQL server - modified rows in the table since upd stats
Field Name: ROWMODCTR
Data Element: MSQMODROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWMODCTR

MSQSYSIDX-SOID table field - MS SQL Server - sort order ID for the index ▼

Description: MS SQL Server - sort order ID for the index
Field Name: SOID
Data Element: MSQSOID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOID

MSQSYSIDX-CSID table field - MS SQL Server - char. set ID that the index was created with ▼

Description: MS SQL Server - char. set ID that the index was created with
Field Name: CSID
Data Element: MSQCSID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CSID

MSQSYSIDX-MAXLEN table field - MS SQL server - maximum size of a row ▼

Description: MS SQL server - maximum size of a row
Field Name: MAXLEN
Data Element: MSQMAXLEN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXLEN

MSQSYSIDX-MAXROW table field - MS SQL server - maximum size of a nonleaf index row. ▼

Description: MS SQL server - maximum size of a nonleaf index row.
Field Name: MAXROW
Data Element: MSQMAXIROW
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXROW

MSQSYSIDX-FILLFAC table field - MS SQL server index's original fill factor ▼

Description: MS SQL server index's original fill factor
Field Name: FILLFAC
Data Element: MSQORIFILL
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILLFAC

MSQSYSIDX-FIRSTIAM table field - First IAM page of the table or index ▼

Description: First IAM page of the table or index
Field Name: FIRSTIAM
Data Element: MSQFSTIAM
Data Type: RAW
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTIAM

MSQSYSIDX-LOCKFLAGS table field - MS sql server locking flags for the table ▼

Description: MS sql server locking flags for the table
Field Name: LOCKFLAGS
Data Element: MSQLOCKFLG
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKFLAGS

MSQSYSIDX-PGMODCTR table field - MS SQL server modified pages in the table. ▼

Description: MS SQL server modified pages in the table.
Field Name: PGMODCTR
Data Element: MSQMODPAGS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGMODCTR

MSQSYSIDX-KEYS table field - MS SQL server table keys ▼

Description: MS SQL server table keys
Field Name: KEYS
Data Element: MSQKEYS
Data Type: RAW
length (Dec): 512(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX512
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEYS

MSQSYSIDX-NAME table field - MS SQL server table or index name ▼

Description: MS SQL server table or index name
Field Name: NAME
Data Element: MSQTABNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

View list of all SAP tables(S4H/ECC)

Select data from SAP table