Menu

SAP Function Module SQL_MSSQL_ANALYSIS_READ

SQL Server read SQL Statements out of Stored Procedure Stats into Moni

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The Function Module SQL_MSSQL_ANALYSIS_READ (SQL Server read SQL Statements out of Stored Procedure Stats into Moni) is a standard Function Module in SAP ERP and is part of the function group STUL within the package STUS.

Technical Information

Function Module SQL_MSSQL_ANALYSIS_READ
Short Text SQL Server read SQL Statements out of Stored Procedure Stats into Moni
Function Group STUL
Package STUS
Module Type Remote-Enabled

Importing Parameters

These are the IMPORTING parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
ADDONKEY LIKE BDLADDON-ADDONKEY Generic key for add-on data collection
NOOFSTMTS LIKE MSDMSTDOWN-NCALL SQL Server MSSTATS number of calls
TIMELIMIT LIKE MSDMSTDOWN-NCALL SQL Server MSSTATS number of calls

Exporting Parameters

These are the EXPORTING parameters of this function module.

Parameter Name Type Associated Type Default Value Short Text
DBSUMMARY LIKE MSDSTATEM SQL Server global data for SQL Statement Analysis
SUMMARY LIKE MSDMSSTSUM SQL Server stored procedure statistics summary

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
INDEX_FIELDS LIKE SQLDSE11IP SQL Download SE11 Index positions
INDEX_HEADER LIKE SQLDSE11IH SQL Download SE11 Index header
INDEX_STATS LIKE MSDINDSTAT SQL Server statement download index info
JOIN_CONDITIONS LIKE DD28J Internal structure for joins of views
MSSTATS_LIST LIKE MSDMSTDOWN SQL Server MSSTATS statement info
PROG_INFO LIKE MSDPRGINF SQL Server statement download program info
SELECTION_CONDITIONS LIKE DD28V View on a Selection Condition
SERVER_INFO LIKE MSDSERVINF SQL Server host information
STMT_EXPLAIN LIKE MSDSTRING SQL Server statement download statement string
STMT_STRING LIKE MSDSTRING SQL Server statement download statement string
TABLELIST LIKE MSDTABLIST SQL Server statement download tables per statement
TABLE_FIELDS LIKE SQLDSE11TP SQL Download SE11 Table columns
TABLE_HEADER LIKE SQLDSE11TH SQL Download SE11 Table header
TABLE_STATS LIKE MSDTBSTATS SQL Server statement download table info
VIEW_TABLES LIKE DD26V V-VIEWTABLE: View of Base Tables of a View

Exceptions

This function module does not define any Exceptions.