/SDF/DBAH_SQL_PLAN SAP (Execution plan information for each child cursor in the awr) Structure details

Dictionary Type: Structure
Description: Execution plan information for each child cursor in the awr




ABAP Code to SELECT data from /SDF/DBAH_SQL_PLAN
Related tables to /SDF/DBAH_SQL_PLAN
Access table /SDF/DBAH_SQL_PLAN




Structure field list including key, data, relationships and ABAP select examples

/SDF/DBAH_SQL_PLAN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Execution plan information for each child cursor in the awr" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SDF/DBAH_SQL_PLAN TYPE /SDF/DBAH_SQL_PLAN.

The /SDF/DBAH_SQL_PLAN table consists of various fields, each holding specific information or linking keys about Execution plan information for each child cursor in the awr data available in SAP. These include SQL_ID (SQL identifier of the parent cursor in the library cache), PLAN_HASH_VALUE (Numerical representation of the SQL plan for the cursor.), ID (A number assigned to each step in the execution plan), OPERATION (Name of the internal operation performed in this step (for e).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP /SDF/DBAH_SQL_PLAN structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DBID Database ID0
SQL_ID SQL identifier of the parent cursor in the library cache0
PLAN_HASH_VALUE Numerical representation of the SQL plan for the cursor.0
ID A number assigned to each step in the execution plan0
OPERATION Name of the internal operation performed in this step (for e0
OPTIONS A variation on the operation described in the OPERATION colu0
OBJECT_NODE Name of the database link to reference the object0
OBJECT# Object number of the table or index0
OBJECT_OWNER Name of the user who owns the schema containing the object0
OBJECT_NAME Name of the table or index0
OBJECT_ALIAS Alias for the object0
OBJECT_TYPE Type of the object0
OPTIMIZER Current mode of the optimizer for the first row in the plan0
PARENT_ID ID of the next execution step that operates on the output of0
DEPTH Depth (or level) of the operation in the tree.0
POSITION Order of processing for all operations that have the same PA0
SEARCH_COLUMNS Number of index columns with start and stop keys0
COST Cost of the operation as estimated by the optimizer's cost-b0
CARDINALITY Estimate, by the cost-based optimizer, of the number of rows0
BYTES Estimate, by the cost-based optimizer, of the number of byte0
OTHER_TAG Describes the contents of the OTHER column0
PARTITION_START Start partition of a range of accessed partitions0
PARTITION_STOP Stop partition of a range of accessed partitions0
PARTITION_ID Step that computes the pair of values of the PARTITION colum0
OTHER Other execution step information0
DISTRIBUTION Stores the method to distribute rows from producer quer0
CPU_COST CPU cost of the operation as estimated by the optimizer's0
IO_COST I/O cost of the operation, as estimated by the optimizer's0
TEMP_SPACE Temporary space usage of the operation estimated0
ACCESS_PREDICATES Predicates used to locate rows in an access structure0
FILTER_PREDICATES Predicates to filter rows before producing them0
PROJECTION Expressions produced by the operation0
TIME Elapsed time (in seconds) of the operation as estimated0
QBLOCK_NAME Name of the query block0
REMARKS REMARKS0

Key field Non-key field



How do I retrieve data from SAP structure /SDF/DBAH_SQL_PLAN using ABAP code?

As /SDF/DBAH_SQL_PLAN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SDF/DBAH_SQL_PLAN as there is no data to select.

How to access SAP table /SDF/DBAH_SQL_PLAN

Within an ECC or HANA version of SAP you can also view further information about /SDF/DBAH_SQL_PLAN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!