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 | Table | DBCON | Description of Database Connections | SOURCE VALUE(CON_NAME) LIKE DBCON-CON_NAME DEFAULT 'DEFAULT' |
2 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(STATIO_X) LIKE MSQEXPLAIN-IOSTATSON DEFAULT 'X' |
3 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(FINAL_COMMAND) LIKE MSQEXPLAIN-LONGSQLTXT OPTIONAL |
4 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(NOEXEC_X) LIKE MSQEXPLAIN-NOEXEC DEFAULT ' ' |
5 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(SHOWPLAN_X) LIKE MSQEXPLAIN-SHOWPLANON DEFAULT 'X' |
6 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(TIMESTATS_X) LIKE MSQEXPLAIN-TIMESTATON DEFAULT 'X' |
7 | Table | MSQEXPLAIN | MS SQL server - sql statement execution plan options | SOURCE VALUE(TRACE_FLAGS) LIKE MSQEXPLAIN-TRACEFLAGS DEFAULT ' ' |
8 | Table | MSQOBJECTS | MS SQL server system objects ( as from sysobjects ) | SOURCE VALUE(SP_NAME) LIKE MSQOBJECTS-NAME DEFAULT ' ' |
9 | Table | MSQSPPARAM | MS SQL server stored procedure parameter structure | SOURCE SP_PARAMS STRUCTURE MSQSPPARAM OPTIONAL |
10 | Table | MSQSQLCODE | MS SQL server structure to get the sp text | |
11 | Table | MSQSQLCODE | MS SQL server structure to get the sp text | SOURCE STMT_LINES STRUCTURE MSQSQLCODE OPTIONAL |
12 | Table | MSQSTPRTXT | MS SQL server - stored procedure text | |
13 | Table | MSQSTPRTXT | MS SQL server - stored procedure text | SOURCE EXPLAIN_RESULT STRUCTURE MSQSTPRTXT |
14 | Table | MSSHELP | Structure for Data Elements Holding F1 Help Documentation | SOURCE VALUE(GURU_AT_WORK) LIKE MSSHELP-MIRRFLAG DEFAULT ' ' |