SAP Function Module SQL_MSSQL_ANALYSIS_READ
SQL Server read SQL Statements out of Stored Procedure Stats into Moni
Unsere Literaturempfehlung
Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework
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 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.