SAP Function Module RSDU_EXPLAIN_PLAN_DB6
Derive and present the query processing plan
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The Function Module RSDU_EXPLAIN_PLAN_DB6 (Derive and present the query processing plan) is a standard Function Module in SAP ERP and is part of the function group RSDU_UTIL_DB6 within the package RSDB6_BW35.
Technical Information
| Function Module | RSDU_EXPLAIN_PLAN_DB6 |
| Short Text | Derive and present the query processing plan |
| Function Group | RSDU_UTIL_DB6 |
| Package | RSDB6_BW35 |
| Module Type | Normal Module |
Importing Parameters
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| I_SHOW_PLAN | TYPE | RS_BOOL | RS_C_FALSE | show execution plan |
| I_STMT | TYPE | C | SQL-statement in a string | |
| I_T_STMT | TYPE | RSDU_T_ABAPSOURCE | SQL-statement in an internal table |
Exporting Parameters
These are the EXPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| E_COSTS | TYPE | I | DB-specific SQL-errorcode (OK - 0) | |
| E_STMTSIZE | TYPE | I | Size of the SQL-Statement in Bytes |
Changing Parameters
These are the CHANGING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| C_PROCESSED | TYPE | RS_BOOL | RS_C_FALSE | Boolean |
Table Parameters
This function module does not define any TABLE parameters.
Exceptions
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| EXPLAIN_ERROR | error during EXPLAIN PLAN call |
| NO_STATEMENT | no statement given |
| PLAN_TABLE_ERROR | error with PLAN_TABLE (only Oracle) |
| STATEMENT_TOO_COMPLEX | statement is too long |