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.
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 |
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 |
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 |
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 |
---|---|---|---|---|
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 |
This function module does not define any Exceptions.