SAP MSQIDXDETS table - MS SQL server - Index details & statistics details in SAP

SAP MSQIDXDETS table summary

Object Name: MSQIDXDETS
Dictionary Type: Structure
Description: MS SQL server - Index details & statistics

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

Details

MSQIDXDETS-IDXNAME table field - MS SQL server table or index name ▼

Description: MS SQL server table or index name
Field Name: IDXNAME
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 IDXNAME

MSQIDXDETS-IDXDESC table field - SQL Server index description ▼

Description: SQL Server index description
Field Name: IDXDESC
Data Element: MSQIDXDESC
Data Type: CHAR
length (Dec): 210(0)
Check table:
Conversion Routine:
Domain Name: MSQCHR210
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXDESC

MSQIDXDETS-IDXKEYS table field - The table columns in the index key. ▼

Description: The table columns in the index key.
Field Name: IDXKEYS
Data Element: MSQINDKEYS
Data Type: CHAR
length (Dec): 2078(0)
Check table:
Conversion Routine:
Domain Name: CHAR2078
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDXKEYS

MSQIDXDETS-IDXHGT table field - Number of index levels excluding data pages (index height). ▼

Description: Number of index levels excluding data pages (index height).
Field Name: IDXHGT
Data Element: MSQIDXHGT
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 IDXHGT

MSQIDXDETS-ROWMINLEN table field - MS SQL server minimum size of the row. ▼

Description: MS SQL server minimum size of the row.
Field Name: ROWMINLEN
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 ROWMINLEN

MSQIDXDETS-ROWMAXLEN table field - MS SQL server - maximum size of a row ▼

Description: MS SQL server - maximum size of a row
Field Name: ROWMAXLEN
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 ROWMAXLEN

MSQIDXDETS-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

MSQIDXDETS-AUTOUPDFLG table field - SQL Server flag for auto update statistics for table index. ▼

Description: SQL Server flag for auto update statistics for table index.
Field Name: AUTOUPDFLG
Data Element: MSQAUTOUPD
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOUPDFLG

MSQIDXDETS-UPDDATE table field - Last time the index statistics was updated. ▼

Description: Last time the index statistics was updated.
Field Name: UPDDATE
Data Element: MSQLSTUPST
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDDATE

View list of all SAP tables(S4H/ECC)

Select data from SAP table