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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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