SAP MSSIDXRECOMMEND table - Index recommendations from sap_index_recommend details in SAP

SAP MSSIDXRECOMMEND table summary

Object Name: MSSIDXRECOMMEND
Dictionary Type: Structure
Description: Index recommendations from sap_index_recommend

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

Details

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

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

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

MSSIDXRECOMMEND-DBLOAD table field - Total anticipated cumulative improvement ▼

Description: Total anticipated cumulative improvement
Field Name: DBLOAD
Data Element: MSSIDXLOAD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBLOAD

MSSIDXRECOMMEND-AVG_USER_COST table field - Avg. cost of user queries that could be reduced by an index ▼

Description: Avg. cost of user queries that could be reduced by an index
Field Name: AVG_USER_COST
Data Element: MSSAVGUCOST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_USER_COST

MSSIDXRECOMMEND-AVG_USER_IMPACT table field - Average percentage benefit for user queries ▼

Description: Average percentage benefit for user queries
Field Name: AVG_USER_IMPACT
Data Element: MSSAVGUIMPACT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_USER_IMPACT

MSSIDXRECOMMEND-USER_TOTAL_OPS table field - Number of seeks and scans by user queries. ▼

Description: Number of seeks and scans by user queries.
Field Name: USER_TOTAL_OPS
Data Element: MSSUTOTOPS
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_TOTAL_OPS

MSSIDXRECOMMEND-EQUALITY_COLUMNS table field - list of columns that contribute to equality predicates ▼

Description: list of columns that contribute to equality predicates
Field Name: EQUALITY_COLUMNS
Data Element: MSSEQCOLS
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: MSSIDXRECCOLS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EQUALITY_COLUMNS

MSSIDXRECOMMEND-INEQUALITY_COLUMNS table field - list of columns that contribute to inequality predicates ▼

Description: list of columns that contribute to inequality predicates
Field Name: INEQUALITY_COLUMNS
Data Element: MSSNECOLS
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: MSSIDXRECCOLS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INEQUALITY_COLUMNS

MSSIDXRECOMMEND-INCLUDED_COLUMNS table field - Columns needed as covering columns ▼

Description: Columns needed as covering columns
Field Name: INCLUDED_COLUMNS
Data Element: MSSINCCOLS
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: MSSIDXRECCOLS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INCLUDED_COLUMNS

MSSIDXRECOMMEND-LAST_USER_SEEK table field - Index usage: Last user seek (sql datetime) ▼

Description: Index usage: Last user seek (sql datetime)
Field Name: LAST_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 LAST_USER_SEEK

MSSIDXRECOMMEND-LAST_USER_SCAN table field - Index usage: Last user scan (sql datetime) ▼

Description: Index usage: Last user scan (sql datetime)
Field Name: LAST_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 LAST_USER_SCAN

MSSIDXRECOMMEND-UNIQUE_COMPILES table field - Number of compilations and recompilations ▼

Description: Number of compilations and recompilations
Field Name: UNIQUE_COMPILES
Data Element: MSSUQCOMPILES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNIQUE_COMPILES

MSSIDXRECOMMEND-AVG_TOTAL_SYSTEM_COST table field - Average cost of syst queries that could be reduced by an ind ▼

Description: Average cost of syst queries that could be reduced by an ind
Field Name: AVG_TOTAL_SYSTEM_COST
Data Element: MSSAVGTOTSYS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_TOTAL_SYSTEM_COST

MSSIDXRECOMMEND-AVG_SYSTEM_IMPACT table field - Average percentage benefit for system queries ▼

Description: Average percentage benefit for system queries
Field Name: AVG_SYSTEM_IMPACT
Data Element: MSSAVSYSIMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_SYSTEM_IMPACT

MSSIDXRECOMMEND-SYSTEM_TOTAL_OPS table field - Number of seeks and scans by system queries. ▼

Description: Number of seeks and scans by system queries.
Field Name: SYSTEM_TOTAL_OPS
Data Element: MSSYSTOTOPS
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_TOTAL_OPS

MSSIDXRECOMMEND-LAST_SYSTEM_SEEK table field - Index usage: Time of last system seek ▼

Description: Index usage: Time of last system seek
Field Name: LAST_SYSTEM_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_SYSTEM_SEEK

MSSIDXRECOMMEND-LAST_SYSTEM_SCAN table field - Index usage: Time of last system scan ▼

Description: Index usage: Time of last system scan
Field Name: LAST_SYSTEM_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_SYSTEM_SCAN

View list of all SAP tables(S4H/ECC)

Select data from SAP table