SAP ABAP Program SAPLSTU3_EXPLAIN (SAPLSTU3_EXPLAIN)
Basic Data
| Program | SAPLSTU3_EXPLAIN | |
| Program Type | F | Function group |
Attributes
| Status | ||
| Application | S | Basis |
| Authorization Group | ||
| Logical database | D$S | Processing without database |
| Selection screen | ||
| Editor lock | Fixed point arithmetic | |
| Unicode checks active | Start using variant |
Function Group
| Include | Function Module | Short Description | Mode |
|---|---|---|---|
| 01 | |
Explains and displays the access path of an SQL statement | |
| 02 | |
Suggestions for REORG/RUNSTATS for a given page set? | |
| 03 | |
REORG recommendation for index? | |
| 04 | |
Navigate to DB02 detailed panel | |
| 05 | |
Remotely callable Explain function | R |
| 06 | |
cleanup Explain Tables | |
| 07 | |
Calculate Hash Value from Statement Text | |
| 08 | |
check SQL statement | |
Transaction Code
Screens
| # | Screen | Short Description |
|---|---|---|
| 1 | 0100 | Main Explain Screen |
| 2 | 0101 | Main Explain Screen |
| 3 | 0105 | Screen that displays export mode of access path |
| 4 | 0106 | Table-related background information subscreen |
| 5 | 0107 | Index-related background information subscreen |
| 6 | 0111 | Screen that displays column distributions for a table |
| 7 | 0112 | Screen that displays column cardinalities for a table |
| 8 | 0113 | Hierarchical explain |
| 9 | 0114 | Empty Subscreen |
| 10 | 0115 | Index Data |
| 11 | 0116 | Table Data |
| 12 | 0900 | DB6: Navigation Frame |
GUI Status
| # | GUI Status | Short Description |
|---|---|---|
| 1 | 0100 | Main SQL explain status |
| 2 | 0111 | Column Distribution Status |
GUI Title
| # | GUI Title | Short Description |
|---|---|---|
| 1 | 100 | Explanation of SQL Access Path |
| 2 | 111 | Column Distributions |
| 3 | 112 | Colum Cardinalities |
History
| Last changed by/on | SAP | 20040312 |
| SAP Release Created in |