SAP /SDF/DBAH_SQL_PLAN table - Execution plan information for each child cursor in the awr details in SAP


SAP /SDF/DBAH_SQL_PLAN table summary

Object Name: /SDF/DBAH_SQL_PLAN
Dictionary Type: Structure
Description: Execution plan information for each child cursor in the awr


Field list for /SDF/DBAH_SQL_PLAN table on an S/4 SAP system

Details
/SDF/DBAH_SQL_PLAN-DBID table field - Database ID

Description: Database ID
Field Name: DBID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBID

/SDF/DBAH_SQL_PLAN-SQL_ID table field - SQL Identifier of the Parent Cursor in the Library Cache

Description: SQL Identifier of the Parent Cursor in the Library Cache
Field Name: SQL_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ID

/SDF/DBAH_SQL_PLAN-PLAN_HASH_VALUE table field - Numerical representation of the SQL plan for the cursor.

Description: Numerical representation of the SQL plan for the cursor.
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HASH_VALUE

/SDF/DBAH_SQL_PLAN-ID table field - A number assigned to each step in the execution plan

Description: A number assigned to each step in the execution plan
Field Name: ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID

/SDF/DBAH_SQL_PLAN-OPERATION table field - Name of the internal operation performed in this step (for e

Description: Name of the internal operation performed in this step (for e
Field Name: OPERATION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPERATION

/SDF/DBAH_SQL_PLAN-OPTIONS table field - A variation on the operation described in the OPERATION colu

Description: A variation on the operation described in the OPERATION colu
Field Name: OPTIONS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIONS

/SDF/DBAH_SQL_PLAN-OBJECT_NODE table field - Name of the database link to reference the object

Description: Name of the database link to reference the object
Field Name: OBJECT_NODE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_NODE

/SDF/DBAH_SQL_PLAN-OBJECT# table field - Object number of the table or index

Description: Object number of the table or index
Field Name: OBJECT#
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT#

/SDF/DBAH_SQL_PLAN-OBJECT_OWNER table field - Name of the user who owns the schema containing the object

Description: Name of the user who owns the schema containing the object
Field Name: OBJECT_OWNER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_OWNER

/SDF/DBAH_SQL_PLAN-OBJECT_NAME table field - Name of the table or index

Description: Name of the table or index
Field Name: OBJECT_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_NAME

/SDF/DBAH_SQL_PLAN-OBJECT_ALIAS table field - Alias for the object

Description: Alias for the object
Field Name: OBJECT_ALIAS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_ALIAS

/SDF/DBAH_SQL_PLAN-OBJECT_TYPE table field - Type of the object

Description: Type of the object
Field Name: OBJECT_TYPE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_TYPE

/SDF/DBAH_SQL_PLAN-OPTIMIZER table field - Current mode of the optimizer for the first row in the plan

Description: Current mode of the optimizer for the first row in the plan
Field Name: OPTIMIZER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIMIZER

/SDF/DBAH_SQL_PLAN-PARENT_ID table field - ID of the next execution step that operates on the output of

Description: ID of the next execution step that operates on the output of
Field Name: PARENT_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT_ID

/SDF/DBAH_SQL_PLAN-DEPTH table field - Depth (or level) of the operation in the tree.

Description: Depth (or level) of the operation in the tree.
Field Name: DEPTH
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPTH

/SDF/DBAH_SQL_PLAN-POSITION table field - Order of processing for all operations that have the same PA

Description: Order of processing for all operations that have the same PA
Field Name: POSITION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSITION

/SDF/DBAH_SQL_PLAN-SEARCH_COLUMNS table field - Number of index columns with start and stop keys

Description: Number of index columns with start and stop keys
Field Name: SEARCH_COLUMNS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH_COLUMNS

/SDF/DBAH_SQL_PLAN-COST table field - Cost of the operation as estimated by the optimizer's cost-b

Description: Cost of the operation as estimated by the optimizer's cost-b
Field Name: COST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COST

/SDF/DBAH_SQL_PLAN-CARDINALITY table field - Estimate, by the cost-based optimizer, of the number of rows

Description: Estimate, by the cost-based optimizer, of the number of rows
Field Name: CARDINALITY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARDINALITY

/SDF/DBAH_SQL_PLAN-BYTES table field - Estimate, by the cost-based optimizer, of the number of byte

Description: Estimate, by the cost-based optimizer, of the number of byte
Field Name: BYTES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BYTES

/SDF/DBAH_SQL_PLAN-OTHER_TAG table field - Describes the contents of the OTHER column

Description: Describes the contents of the OTHER column
Field Name: OTHER_TAG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OTHER_TAG

/SDF/DBAH_SQL_PLAN-PARTITION_START table field - Start partition of a range of accessed partitions

Description: Start partition of a range of accessed partitions
Field Name: PARTITION_START
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITION_START

/SDF/DBAH_SQL_PLAN-PARTITION_STOP table field - Stop partition of a range of accessed partitions

Description: Stop partition of a range of accessed partitions
Field Name: PARTITION_STOP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITION_STOP

/SDF/DBAH_SQL_PLAN-PARTITION_ID table field - Step that computes the pair of values of the PARTITION colum

Description: Step that computes the pair of values of the PARTITION colum
Field Name: PARTITION_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITION_ID

/SDF/DBAH_SQL_PLAN-OTHER table field - Other execution step information

Description: Other execution step information
Field Name: OTHER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OTHER

/SDF/DBAH_SQL_PLAN-DISTRIBUTION table field - Stores the method to distribute rows from producer quer

Description: Stores the method to distribute rows from producer quer
Field Name: DISTRIBUTION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISTRIBUTION

/SDF/DBAH_SQL_PLAN-CPU_COST table field - CPU cost of the operation as estimated by the optimizer's

Description: CPU cost of the operation as estimated by the optimizer's
Field Name: CPU_COST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU_COST

/SDF/DBAH_SQL_PLAN-IO_COST table field - I/O cost of the operation, as estimated by the optimizer's

Description: I/O cost of the operation, as estimated by the optimizer's
Field Name: IO_COST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IO_COST

/SDF/DBAH_SQL_PLAN-TEMP_SPACE table field - Temporary space usage of the operation estimated

Description: Temporary space usage of the operation estimated
Field Name: TEMP_SPACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEMP_SPACE

/SDF/DBAH_SQL_PLAN-ACCESS_PREDICATES table field - Predicates used to locate rows in an access structure

Description: Predicates used to locate rows in an access structure
Field Name: ACCESS_PREDICATES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCESS_PREDICATES

/SDF/DBAH_SQL_PLAN-FILTER_PREDICATES table field - Predicates to filter rows before producing them

Description: Predicates to filter rows before producing them
Field Name: FILTER_PREDICATES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILTER_PREDICATES

/SDF/DBAH_SQL_PLAN-PROJECTION table field - Expressions produced by the operation

Description: Expressions produced by the operation
Field Name: PROJECTION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROJECTION

/SDF/DBAH_SQL_PLAN-TIME table field - Elapsed time (in seconds) of the operation as estimated

Description: Elapsed time (in seconds) of the operation as estimated
Field Name: TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME

/SDF/DBAH_SQL_PLAN-QBLOCK_NAME table field - Name of the query block

Description: Name of the query block
Field Name: QBLOCK_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QBLOCK_NAME

/SDF/DBAH_SQL_PLAN-REMARKS table field - REMARKS

Description: REMARKS
Field Name: REMARKS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REMARKS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table