The Function Module MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement) is a standard Function Module in SAP ERP and is part of the function group STUS within the package STUS.
| Function Module | MSS_GET_SQLEXPLAIN |
| Short Text | MS SQL Server get explain for a given SQL statement |
| Function Group | STUS |
| Package | STUS |
| Module Type | Remote-Enabled |
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| CON_NAME | LIKE | DBCON-CON_NAME | 'DEFAULT' | Logical name of a Database Connection |
| FINAL_COMMAND | LIKE | MSQEXPLAIN-LONGSQLTXT | ||
| GURU_AT_WORK | LIKE | MSSHELP-MIRRFLAG | ' ' | |
| NOEXEC_X | LIKE | MSQEXPLAIN-NOEXEC | ' ' | |
| SCHEMA | TYPE | MSSSCHEMA | SPACE | Target Schema |
| SHOWPLAN_X | LIKE | MSQEXPLAIN-SHOWPLANON | 'X' | |
| SP_NAME | LIKE | MSQOBJECTS-NAME | ' ' | |
| STATIO_X | LIKE | MSQEXPLAIN-IOSTATSON | 'X' | |
| TIMESTATS_X | LIKE | MSQEXPLAIN-TIMESTATON | 'X' | |
| TRACE_FLAGS | LIKE | MSQEXPLAIN-TRACEFLAGS | ' ' |
This function module does not define any EXPORTING parameters.
This function module does not define any CHANGING parameters.
These are the TABLE parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| EXPLAIN_RESULT | LIKE | MSQSTPRTXT | ||
| SP_PARAMS | LIKE | MSQSPPARAM | ||
| STMT_LINES | LIKE | MSQSQLCODE | MS SQL server structure to get the sp text |
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| CONNECT_ERROR | Can't connect |
| DB_ERROR | Some database error occurred. |
| INTERNAL_ERROR | Internal ADBC error. |
| NOT_RUNNING_ON_MSSQL | Not MSSQL |