Table list used by SAP ABAP Function Module MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement)
SAP ABAP Function Module
MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DBCON | Description of Database Connections | SOURCE VALUE(CON_NAME) LIKE DBCON-CON_NAME DEFAULT 'DEFAULT' |
|
| 2 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(STATIO_X) LIKE MSQEXPLAIN-IOSTATSON DEFAULT 'X' |
|
| 3 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(FINAL_COMMAND) LIKE MSQEXPLAIN-LONGSQLTXT OPTIONAL |
|
| 4 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(NOEXEC_X) LIKE MSQEXPLAIN-NOEXEC DEFAULT ' ' |
|
| 5 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(SHOWPLAN_X) LIKE MSQEXPLAIN-SHOWPLANON DEFAULT 'X' |
|
| 6 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(TIMESTATS_X) LIKE MSQEXPLAIN-TIMESTATON DEFAULT 'X' |
|
| 7 | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(TRACE_FLAGS) LIKE MSQEXPLAIN-TRACEFLAGS DEFAULT ' ' |
|
| 8 | MSQOBJECTS | MS SQL server system objects ( as from sysobjects ) | SOURCE VALUE(SP_NAME) LIKE MSQOBJECTS-NAME DEFAULT ' ' |
|
| 9 | MSQSPPARAM | MS SQL server stored procedure parameter structure | SOURCE SP_PARAMS STRUCTURE MSQSPPARAM OPTIONAL |
|
| 10 | MSQSQLCODE | MS SQL server structure to get the sp text | ||
| 11 | MSQSQLCODE | MS SQL server structure to get the sp text | SOURCE STMT_LINES STRUCTURE MSQSQLCODE OPTIONAL |
|
| 12 | MSQSTPRTXT | MS SQL server - stored procedure text | ||
| 13 | MSQSTPRTXT | MS SQL server - stored procedure text | SOURCE EXPLAIN_RESULT STRUCTURE MSQSTPRTXT |
|
| 14 | MSSHELP | Structure for Data Elements Holding F1 Help Documentation | SOURCE VALUE(GURU_AT_WORK) LIKE MSSHELP-MIRRFLAG DEFAULT ' ' |