SAP ABAP Function Module DB_EXPLAIN_PLAN (Create an access plan for a given SQL statement)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DBI (Application Component) DB-Independent Database Interface
⤷
SDB_DBI (Package) General Database Interface
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DBI (Application Component) DB-Independent Database Interface⤷
SDB_DBI (Package) General Database Interface
Basic Data
| Function Module | DB_EXPLAIN_PLAN | Create an access plan for a given SQL statement |
| Function Group | SYDB_EXPLAIN | Common EXPLAIN |
| Program Name | SAPLSYDB_EXPLAIN | |
| INCLUDE Name | LSYDB_EXPLAINU01 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Importing |
STATEMENT | TYPE | SQL statement with markers for host variables | ||||
| Importing |
NO_DISPLAY | TYPE | SPACE | ||||
| Importing |
STMT_LG | TYPE | I | 0 | |||
| Importing |
CON_NAME | TYPE | DBCON_NAME | SPACE | Logischer Name einer Datenbankverbindung | ||
 Tables |
VALUES | TYPE | EXPL_VALUE | Assignment of values to host variables | |||
| Tables |
PLAN | TYPE | EXPL_PLAN | Access plan (DB-specific) | |||
| Tables |
ORA_PAR | TYPE | ORAEXPLPAR | ||||
 Exception |
EXPLAIN_FAILED | TYPE | Error when creating the plan | ||||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20110909 |
| SAP Release Created in | 732 |
