Menu

SAP Function Module MSS_EXPLAIN

Complete user interface for SQL Server Explain

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The Function Module MSS_EXPLAIN (Complete user interface for SQL Server Explain) is a standard Function Module in SAP ERP and is part of the function group STXPL within the package STUS.

Technical Information

Function Module MSS_EXPLAIN
Short Text Complete user interface for SQL Server Explain
Function Group STXPL
Package STUS
Module Type Normal Module

Importing Parameters

These are the IMPORTING parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
CONNDATA TYPE MSSCONNDATA MSSQL multi-connect : Complete connection information
INPUT_ABAPNAME TYPE PROGNAME ABAP Program Name
INPUT_ABLOCAT TYPE ABP_CONT Offset of a Processing Control Block
INPUT_INSTNAME TYPE MSNAME2 New Application Server Name Length (Since 6.10)
INPUT_OBJ_DB TYPE MSSDB Database name
INPUT_OBJ_SCH TYPE MSSSCHEMA Schema name
INPUT_SPID TYPE MSQSYPROID 0 MS SQL server process id
INPUT_SPNAME TYPE MSSSPNAME Stored procedure name
INPUT_STMT TYPE MSSSQLTEXT SQL definition statement text

Exporting Parameters

This function module does not define any EXPORTING parameters.

Changing Parameters

This function module does not define any CHANGING parameters.

Table Parameters

These are the TABLE parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
INPUT_PARAMS LIKE MSQSPPARAM MS SQL server stored procedure parameter structure
INPUT_VALUES LIKE EXPL_VALUE Generic abap types and values (st05)

Exceptions

These are the Exceptions of this function module.

Exception Name Short Text
INVALID_INPUT Wrong or missing input parameters
NO_STMT_TEXT Can't find statement text for spid or sp name.