SAP MSSIDXUSAGESTATS table - Index usage stats output from MSS_GET_INDEX_USE_STATS details in SAP

SAP MSSIDXUSAGESTATS table summary

Object Name: MSSIDXUSAGESTATS
Dictionary Type: Structure
Description: Index usage stats output from MSS_GET_INDEX_USE_STATS

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

Details

MSSIDXUSAGESTATS-DBNAME table field - Database name ▼

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSIDXUSAGESTATS-SCHEMANAME table field - Schema name ▼

Description: Schema name
Field Name: SCHEMANAME
Data Element: MSSSCHEMA
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEMANAME

MSSIDXUSAGESTATS-TABNAME table field - Table name ▼

Description: Table name
Field Name: TABNAME
Data Element: MSSTABLE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABNAME

MSSIDXUSAGESTATS-INDEXNAME table field - Index name ▼

Description: Index name
Field Name: INDEXNAME
Data Element: MSSINDEX
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXNAME

MSSIDXUSAGESTATS-USER_SEEKS table field - Index usage - Number of seeks by user queries. ▼

Description: Index usage - Number of seeks by user queries.
Field Name: USER_SEEKS
Data Element: MSSUSEEKS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_SEEKS

MSSIDXUSAGESTATS-USER_SCANS table field - Index usage - Number of scans by user queries. ▼

Description: Index usage - Number of scans by user queries.
Field Name: USER_SCANS
Data Element: MSSUSCANS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_SCANS

MSSIDXUSAGESTATS-USER_LOOKUPS table field - Index usage: Number of lookups by user queries ▼

Description: Index usage: Number of lookups by user queries
Field Name: USER_LOOKUPS
Data Element: MSSULOOKUPS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_LOOKUPS

MSSIDXUSAGESTATS-USER_UPDATES table field - Index usage: Number of updates by user queries ▼

Description: Index usage: Number of updates by user queries
Field Name: USER_UPDATES
Data Element: MSSUUPDATES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_UPDATES

MSSIDXUSAGESTATS-USER_TOTALOPS table field - Index usage: Total user operations on the index ▼

Description: Index usage: Total user operations on the index
Field Name: USER_TOTALOPS
Data Element: MSSUTOTALOPS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_TOTALOPS

MSSIDXUSAGESTATS-LST_USER_SEEK table field - Index usage: Last user seek (sql datetime) ▼

Description: Index usage: Last user seek (sql datetime)
Field Name: LST_USER_SEEK
Data Element: MSSLSTUSEEK
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LST_USER_SEEK

MSSIDXUSAGESTATS-LST_USER_SCAN table field - Index usage: Last user scan (sql datetime) ▼

Description: Index usage: Last user scan (sql datetime)
Field Name: LST_USER_SCAN
Data Element: MSSLSTUSCAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LST_USER_SCAN

MSSIDXUSAGESTATS-LST_USER_LOOKUP table field - Index usage: Last user lookup (sql datetime) ▼

Description: Index usage: Last user lookup (sql datetime)
Field Name: LST_USER_LOOKUP
Data Element: MSSLSTULOOKUP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LST_USER_LOOKUP

MSSIDXUSAGESTATS-LST_USER_UPDATE table field - Index usage: Last user update (sql datetime) ▼

Description: Index usage: Last user update (sql datetime)
Field Name: LST_USER_UPDATE
Data Element: MSSLSTUUPDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LST_USER_UPDATE

MSSIDXUSAGESTATS-SYSTEM_SEEKS table field - Index usage: Number of seeks by system queries ▼

Description: Index usage: Number of seeks by system queries
Field Name: SYSTEM_SEEKS
Data Element: MSSSYSSEEKS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSTEM_SEEKS

MSSIDXUSAGESTATS-SYSTEM_SCANS table field - Index usage: Number of scans by system queries ▼

Description: Index usage: Number of scans by system queries
Field Name: SYSTEM_SCANS
Data Element: MSSSYSSCANS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSTEM_SCANS

MSSIDXUSAGESTATS-SYSTEM_LOOKUPS table field - Index usage: Number of lookups by system queries ▼

Description: Index usage: Number of lookups by system queries
Field Name: SYSTEM_LOOKUPS
Data Element: MSSSYSLOOKUPS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSTEM_LOOKUPS

MSSIDXUSAGESTATS-SYSTEM_UPDATES table field - Index usage: Number of updates by system queries ▼

Description: Index usage: Number of updates by system queries
Field Name: SYSTEM_UPDATES
Data Element: MSSSYSUPDATES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSTEM_UPDATES

MSSIDXUSAGESTATS-LAST_SYS_SEEK table field - Index usage: Time of last system seek ▼

Description: Index usage: Time of last system seek
Field Name: LAST_SYS_SEEK
Data Element: MSSLSTSYSSEEK
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_SYS_SEEK

MSSIDXUSAGESTATS-LAST_SYS_SCAN table field - Index usage: Time of last system scan ▼

Description: Index usage: Time of last system scan
Field Name: LAST_SYS_SCAN
Data Element: MSSLSTSYSSCAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_SYS_SCAN

MSSIDXUSAGESTATS-LAST_SYS_LOOKUP table field - Index usage: Time of last system lookup ▼

Description: Index usage: Time of last system lookup
Field Name: LAST_SYS_LOOKUP
Data Element: MSSLSTSYSLOOKUP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_SYS_LOOKUP

MSSIDXUSAGESTATS-LAST_SYS_UPDATE table field - Index usage: Time of last system update ▼

Description: Index usage: Time of last system update
Field Name: LAST_SYS_UPDATE
Data Element: MSSLSTSYSUPDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_SYS_UPDATE

View list of all SAP tables(S4H/ECC)

Select data from SAP table