/SDF/ORAEXPLAIN SAP (Explain Plan for Oracle Statement) Structure details

Dictionary Type: Structure
Description: Explain Plan for Oracle Statement




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




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

/SDF/ORAEXPLAIN 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 "Explain Plan for Oracle Statement" 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/ORAEXPLAIN TYPE /SDF/ORAEXPLAIN.

The /SDF/ORAEXPLAIN table consists of various fields, each holding specific information or linking keys about Explain Plan for Oracle Statement data available in SAP. These include STMT_ID (Statement ID), ID (Internal: Node ID), TYPE (Node Type), NAME (Object name).. 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/ORAEXPLAIN 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
ANALY_ID Analysis ID0
STMT_ID Statement ID0
ID Internal: Node ID0
TYPE Node Type0
NAME Object name0
TLEVEL Node Level0
LINK link indicator0
COMPRESS Internal: Compression label0
LEAF Internal: end code incicator0
TLOCK Internal: Selectiopn Indicator0
PARENT Internal: Node ID0
CHILD Internal: Node ID0
NEXT Internal: Node ID0
NLENGTH Output Length of a Hierarchy Node0
COLOR colour image of a hierarch0
INTENSIV intensity of representation0
TEXT Text/Icon/Symbol0
TLENGTH Output Length of a Hierarchy Node0
TCOLOR colour image of a hierarch0
TINTENSIV intensity of representation0
TPOS Hierarchy Display: Column position0
KIND Text Type (Space = Text, 'I' = '0
TEXT1 Text/Icon/Symbol0
TLENGTH1 Output Length of a Hierarchy Node0
TCOLOR1 colour image of a hierarch0
TINTENSIV1 intensity of representation0
TPOS1 Hierarchy Display: Column position0
KIND1 Text Type (Space = Text, 'I' = '0
TEXT2 Text/Icon/Symbol0
TLENGTH2 Output Length of a Hierarchy Node0
TCOLOR2 colour image of a hierarch0
TINTENSIV2 intensity of representation0
TPOS2 Hierarchy Display: Column position0
KIND2 Text Type (Space = Text, 'I' = '0
TEXT3 Text/Icon/Symbol0
TLENGTH3 Output Length of a Hierarchy Node0
TCOLOR3 colour image of a hierarch0
TINTENSIV3 intensity of representation0
TPOS3 Hierarchy Display: Column position0
KIND3 Text Type (Space = Text, 'I' = '0
TEXT4 Text/Icon/Symbol0
TLENGTH4 Output Length of a Hierarchy Node0
TCOLOR4 colour image of a hierarch0
TINTENSIV4 intensity of representation0
TPOS4 Hierarchy Display: Column position0
KIND4 Text Type (Space = Text, 'I' = '0
TEXT5 Text/Icon/Symbol0
TLENGTH5 Output Length of a Hierarchy Node0
TCOLOR5 colour image of a hierarch0
TINTENSIV5 intensity of representation0
TPOS5 Hierarchy Display: Column position0
KIND5 Text Type (Space = Text, 'I' = '0
TEXT6 Text/Icon/Symbol0
TLENGTH6 Output Length of a Hierarchy Node0
TCOLOR6 colour image of a hierarch0
TINTENSIV6 intensity of representation0
TPOS6 Hierarchy Display: Column position0
KIND6 Text Type (Space = Text, 'I' = '0
TEXT7 Text/Icon/Symbol0
TLENGTH7 Output Length of a Hierarchy Node0
TCOLOR7 colour image of a hierarch0
TINTENSIV7 intensity of representation0
TPOS7 Hierarchy Display: Column position0
KIND7 Text Type (Space = Text, 'I' = '0
TEXT8 Text/Icon/Symbol0
TLENGTH8 Output Length of a Hierarchy Node0
TCOLOR8 colour image of a hierarch0
TINTENSIV8 intensity of representation0
TPOS8 Hierarchy Display: Column position0
KIND8 Text Type (Space = Text, 'I' = '0
TEXT9 Text/Icon/Symbol0
TLENGTH9 Output Length of a Hierarchy Node0
TCOLOR9 colour image of a hierarch0
TINTENSIV9 intensity of representation0
TPOS9 Hierarchy Display: Column position0
KIND9 Text Type (Space = Text, 'I' = '0
HIDE hide area of a hierarchy node0
FORCE_PLUS dummy function0
HOTSPOT dummy function0
HOTSPOT1 dummy function0
HOTSPOT2 dummy function0
HOTSPOT3 dummy function0
HOTSPOT4 dummy function0
HOTSPOT5 dummy function0
HOTSPOT6 dummy function0
HOTSPOT7 dummy function0
HOTSPOT8 dummy function0
HOTSPOT9 dummy function0
INPUT dummy function0
INPUT1 dummy function0
INPUT2 dummy function0
INPUT3 dummy function0
INPUT4 dummy function0
INPUT5 dummy function0
INPUT6 dummy function0
INPUT7 dummy function0
INPUT8 dummy function0
INPUT9 dummy function0
NODISPLAY Flag: do not display node0
MOREINFO flag: additional info for node0
PROPFAW0 Flag: proportional font plus0
PROPFAW Flag: proportional font plus0
PROPFAW1 Flag: proportional font plus0
PROPFAW2 Flag: proportional font plus0
PROPFAW3 Flag: proportional font plus0
PROPFAW4 Flag: proportional font plus0
PROPFAW5 Flag: proportional font plus0
PROPFAW6 Flag: proportional font plus0
PROPFAW7 Flag: proportional font plus0
PROPFAW8 Flag: proportional font plus0
PROPFAW9 Flag: proportional font plus0
STYLE0 Tree Control Style0
STYLE Tree Control Style0
STYLE1 Tree Control Style0
STYLE2 Tree Control Style0
STYLE3 Tree Control Style0
STYLE4 Tree Control Style0
STYLE5 Tree Control Style0
STYLE6 Tree Control Style0
STYLE7 Tree Control Style0
STYLE8 Tree Control Style0
STYLE9 Tree Control Style0
NODEICON Tree Control: Icon/Image0
LASTHTEXT Ttext field from STREEATTR0
STMT_SOURCE DBA HIST (D) or Cache (C)0
DBA_HIST_B_TS Start timestamp for statement selection from DBA HIST0
DBA_HIST_E_TS End timestamp for statement selection from DBA HIST0

Key field Non-key field



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

As /SDF/ORAEXPLAIN 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/ORAEXPLAIN as there is no data to select.

How to access SAP table /SDF/ORAEXPLAIN

Within an ECC or HANA version of SAP you can also view further information about /SDF/ORAEXPLAIN 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!