SAP DBOPTSTATS table - Structure for Optimizer Statistics Check details in SAP

SAP DBOPTSTATS table summary

Object Name: DBOPTSTATS
Dictionary Type: Structure
Description: Structure for Optimizer Statistics Check

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

Details

DBOPTSTATS-ALERT table field - Alert value: 0=Green, 1=Yellow, 2=Red ▼

Description: Alert value: 0=Green, 1=Yellow, 2=Red
Field Name: ALERT
Data Element: ALEVALUE
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALERT

DBOPTSTATS-TEXT table field - Text field in multi-purpose alert record ▼

Description: Text field in multi-purpose alert record
Field Name: TEXT
Data Element: ALEGPTEXT
Data Type: CHAR
length (Dec): 72(0)
Check table:
Conversion Routine:
Domain Name: TEXT72
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEXT

DBOPTSTATS-NEEDED table field - General Flag ▼

Description: General Flag
Field Name: NEEDED
Data Element: FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: FLAG
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEEDED

DBOPTSTATS-LASTDATE table field - System Date ▼

Description: System Date
Field Name: LASTDATE
Data Element: SYDATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYDATS
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTDATE

DBOPTSTATS-STATABLES table field - Tables which by default must be optimized ▼

Description: Tables which by default must be optimized
Field Name: STATABLES
Data Element: STATABLES
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 STATABLES

DBOPTSTATS-PRITABLES table field - Tables which must be optimized with high priority ▼

Description: Tables which must be optimized with high priority
Field Name: PRITABLES
Data Element: PRITABLES
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 PRITABLES

View list of all SAP tables(S4H/ECC)

Select data from SAP table