The Function Module MSS_GET_MSSTATS (Get MSSTATS list) is a standard Function Module in SAP ERP and is part of the function group STUQ within the package STUS.
| Function Module | MSS_GET_MSSTATS |
| Short Text | Get MSSTATS list |
| Function Group | STUQ |
| Package | STUS |
| Module Type | Remote-Enabled |
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| ALL_DETAIL | TYPE | CHAR1 | ' ' | Single-character flag |
| CON_NAME | LIKE | DBCON-CON_NAME | 'DEFAULT' | DBCON Name |
| IMPORTED_SP | TYPE | CHAR1 | ' ' | Single-character flag |
| INSTNAME | LIKE | MSQMSTATS-NAME | ' ' | Appserver |
| MAX_ROWS | TYPE | INT4 | 100 | Natural number |
| OBJ_DB | TYPE | MSSDB | Database name | |
| OBJ_SCHEMA | TYPE | MSSSCHEMA | Schema name | |
| SCHEMA | TYPE | MSSSCHEMA | SPACE | Target Schema |
| SHOW_CACHE | TYPE | CHAR1 | ' ' | Single-character flag |
| SHOW_EXP | TYPE | CHAR1 | 'X' | Single-character flag |
| SHOW_IDX | TYPE | CHAR1 | 'X' | Single-character flag |
| SORTEDCOLNAME | TYPE | CHAR10 | 'RF_TOT_MS' | Character field length - 10 |
These are the EXPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| SUMMARY | TYPE | MSQMSSTSUM | MS 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 |
|---|---|---|---|---|
| CACHE_OBJECTS | LIKE | MSSSYCHST | The data from syscacheobjects for display fewer columns | |
| MSSTATS_LIST | LIKE | MSSSTATS1X | MS SQL Server: MSSTATS with Statement Type and Intance | |
| OBJECT_DETAIL | LIKE | MSSTDETAIL | MS SQL Server MSSTATS: Detail List | |
| SPLIST | LIKE | MSSSTATS1X | MS SQL server dbcc output result set |
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| CONNECT_ERROR | Connection problem |
| DB_ERROR | SQL Error Message |
| NOT_RUNNING_ON_MSSQL | DBMS must be MSSQL |