Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.
Bei amazon.de ansehen →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 |