SAP ABAP Function Module MSS_EXPLAIN_SQL_STMT (MS SQL server function to get statistics, showplan for SQL stmt execution.)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Function Module | MSS_EXPLAIN_SQL_STMT | MS SQL server function to get statistics, showplan for SQL stmt execution. |
| Function Group | SMSSDATA | MSS: Cockpit Backend not from RAT |
| Program Name | SAPLSMSSDATA | |
| INCLUDE Name | LSMSSDATAU33 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name of a Database Connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | SPACE | Target Schema | ||
| Importing |
SIMPLE_EXPLAIN | TYPE | MSQEXPLAIN-SIMPLEEXPL | 'X' | |||
| Importing |
IO_STATS_ON | TYPE | MSQEXPLAIN-IOSTATSON | 'X' | |||
| Importing |
TIME_STATS_ON | TYPE | MSQEXPLAIN-TIMESTATON | 'X' | |||
| Importing |
SHOWPLAN_ON | TYPE | MSQEXPLAIN-SHOWPLANON | 'X' | |||
| Importing |
TRACE_FLAG_LIST | TYPE | MSQEXPLAIN-TRACEFLAGS | ' ' | |||
| Importing |
NO_EXECUTE | TYPE | MSQEXPLAIN-NOEXEC | ||||
 Tables |
SQLCODE | TYPE | MSQSQLCODE | MS SQL server structure to get the sp text | |||
| Tables |
SQLEXEC_PLAN | TYPE | MSQSTPRTXT | ||||
 Exception |
DB_ERROR | TYPE | Some database error occurred. | ||||
| Exception |
INTERNAL_ERROR | TYPE | Internal ADBC error. | ||||
| Exception |
NOT_RUNNING_ON_MSSQL | TYPE | Not MSSQL | ||||
| Exception |
CONNECT_ERROR | TYPE | Can't connect | ||||
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 | 20100421 |
| SAP Release Created in | 711 |
