SAP DBAOPTL table - DB Optimization - Table Statistics details in SAP


SAP DBAOPTL table summary

Object Name: DBAOPTL
Dictionary Type: Transparent table
Description: DB Optimization - Table Statistics


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

Details
DBAOPTL-SYS_ID table field - Database system ID

Description: Database system ID
Field Name: SYS_ID
Data Element: SDBA_DBSID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYS_ID

DBAOPTL-OPER_ID table field - Unique operation ID

Description: Unique operation ID
Field Name: OPER_ID
Data Element: SDBA_OP_ID
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPER_ID

DBAOPTL-TASKNAME table field - Task Name

Description: Task Name
Field Name: TASKNAME
Data Element: SDBA_TASK
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: SDBA_TASK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TASKNAME

DBAOPTL-JOB_NR table field - Unique Job Number in a Task

Description: Unique Job Number in a Task
Field Name: JOB_NR
Data Element: SDBA_JOB
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SDBA_JOB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOB_NR

DBAOPTL-TRIAL table field - Unique ID Number of the Suboperation

Description: Unique ID Number of the Suboperation
Field Name: TRIAL
Data Element: SDBA_TRIAL
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRIAL

DBAOPTL-UTIL_NR table field - Utility number within job step

Description: Utility number within job step
Field Name: UTIL_NR
Data Element: SDBA_UTNR
Data Type: NUMC
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SDBA_UTNR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UTIL_NR

DBAOPTL-FUNC_ID table field - DBA Function ID

Description: DBA Function ID
Field Name: FUNC_ID
Data Element: SDBA_FID
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: SDBA_FUNCT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FUNC_ID

DBAOPTL-UPD_OP table field - Update Time Stamp

Description: Update Time Stamp
Field Name: UPD_OP
Data Element: SDBA_UPD
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: SDBA_UPD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPD_OP

DBAOPTL-OBJ table field - Object of DB operation

Description: Object of DB operation
Field Name: OBJ
Data Element: SDBA_OBJ30
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 OBJ

DBAOPTL-ANALY_METH table field - Analysis Method

Description: Analysis Method
Field Name: ANALY_METH
Data Element: SDBA_ANME
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 ANALY_METH

DBAOPTL-ANALY_OPTI table field - Analysis method

Description: Analysis method
Field Name: ANALY_OPTI
Data Element: SDBA_OPT
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 ANALY_OPTI

DBAOPTL-TABLES table field - Number of statistics to be checked

Description: Number of statistics to be checked
Field Name: TABLES
Data Element: SDBA_TAB
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLES

DBAOPTL-TAB_CHECK table field - Number of checked statistics

Description: Number of checked statistics
Field Name: TAB_CHECK
Data Element: SDBA_CHK
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAB_CHECK

DBAOPTL-TAB_OLD table field - Number of tables with statistics that need to be updated

Description: Number of tables with statistics that need to be updated
Field Name: TAB_OLD
Data Element: SDBA_OLD
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAB_OLD

DBAOPTL-TAB_REFR table field - Number of tables with updated statistics

Description: Number of tables with updated statistics
Field Name: TAB_REFR
Data Element: SDBA_REF
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAB_REFR


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table