SAP MSSHISTOGRAM table - Output from running dbcc show_statistics with histogram details in SAP

SAP MSSHISTOGRAM table summary

Object Name: MSSHISTOGRAM
Dictionary Type: Structure
Description: Output from running dbcc show_statistics with histogram

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

Details

MSSHISTOGRAM-R_HI_KEY table field - Key value output from dbcc show_statistics ▼

Description: Key value output from dbcc show_statistics
Field Name: R_HI_KEY
Data Element: MSSDBCCKEY
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field R_HI_KEY

MSSHISTOGRAM-R_ROWS table field - Est. number of rows from the table that fall within range ▼

Description: Est. number of rows from the table that fall within range
Field Name: R_ROWS
Data Element: MSSRNGROWS
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSSROWCNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field R_ROWS

MSSHISTOGRAM-EQ_ROWS table field - Estimated number of rows that are equal to the upper bound ▼

Description: Estimated number of rows that are equal to the upper bound
Field Name: EQ_ROWS
Data Element: MSSEQROWS
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSSROWCNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EQ_ROWS

MSSHISTOGRAM-DIST_RNG_ROWS table field - Estimated number of distinct values within a histogram step ▼

Description: Estimated number of distinct values within a histogram step
Field Name: DIST_RNG_ROWS
Data Element: MSSDISTRNGROWS
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSSROWCNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DIST_RNG_ROWS

MSSHISTOGRAM-AVG_RNG_ROWS table field - Average number of duplicate values within a histogram step ▼

Description: Average number of duplicate values within a histogram step
Field Name: AVG_RNG_ROWS
Data Element: MSSAVGRNGROWS
Data Type: DEC
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSSROWCNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_RNG_ROWS

MSSHISTOGRAM-EQ_ROWS_PCT table field - Percentage of all rows ▼

Description: Percentage of all rows
Field Name: EQ_ROWS_PCT
Data Element: MSSEQROWSPCT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EQ_ROWS_PCT

View list of all SAP tables(S4H/ECC)

Select data from SAP table