SAP ABAP Program SAPLSMSSDATA1 (SAPLSMSSDATA1)
Basic Data
| Program | SAPLSMSSDATA1 | |
| Program Type | F | Function group |
Attributes
| Status | ||
| Application | S | Basis |
| Authorization Group | ||
| Logical database | D$S | Processing without database |
| Selection screen | ||
| Editor lock | Fixed point arithmetic | |
| Unicode checks active | Start using variant |
Function Group
| Include | Function Module | Short Description | Mode |
|---|---|---|---|
| 01 |  MSS_MON_GET_PARTTABS |
Get a list of all tables that are partitioned | R |
| 02 | MSS_MON_GET_REPLTABLES |
Get a list of all tables that are replicated | R |
| 04 | CHECK_CONNECTION_MSS |
Check connection to remote DB | R |
| 05 | MSS_MON_GET_TRIGGERS |
Read all trigger names from the systemtabelle | R |
| 06 | MSS_MON_OBJECT_TYPE |
Find the type of an object | R |
| 07 | MSS_MON_SET_ONLINE_INDXCREATE |
Set online index creation on/off | |
| 08 | MSS_MON_SQLTEXT |
Get SQL Text for an MSS object | R |
| 11 | MSS_MON_TOP_TABVIEW |
Get the column definitions of a table | R |
| 13 | MSS_MON_GET_ONLINE_IDXCR_VAL |
Read status of online index creation | R |
| 16 | MSS_MON_GET_ALL_OBJECTS |
Get all objects of a certain type | R |
| 20 | MSS_READ_TEXT_FILE |
Read a text file on sql server host | R |
| 25 | MSS_GET_APPSERVER_INFO |
Get Application Server info for MSS | R |
| 26 | MSS_GET_ALL_APPSERVER_INFO |
Get Application Server info for MSS | R |
| 27 | MSS_DYNAMIC_PARAMETER_SWITCH |
Switch Dynamic Profile Parameters on/off | R |
| 30 | GET_LOCKINFO_MSS |
retrieve blocking/locking data | R |
| 31 | MSS_GET_R3REPORT_USER |
MS SQL server to get column density for a given table | R |
| 32 | MSQ_AUTOSTAT_DOWNLOAD |
SQL Server find all indexes with sp_autostats off | R |
| 33 | MSQ_DBSTAT_DOWNLOAD |
SQL Server table statistic download function | |
| 34 | MSQ_DLL_DOWNLOAD |
SQL Server download permanent stored procedure info | R |
| 35 | MSQ_NETLIB_DOWNLOAD |
SQL Server download network libraries used by app servers | R |
| 37 | MSQ_SHOW_EXTENT |
SQL Server show extent distribution per table | R |
| 39 | MSQ_SQLPERF_DOWNLOAD |
SQL Server DBCC sqlperf Call | R |
| 41 | MSQ_VIRTLOG_DOWNLOAD |
SQL Server Download virtual log information | R |
| 42 | MSQ_VTLFILESTATS_DOWNLOAD |
SQL Server file IO statistics | R |
| 43 | MSQ_WAIT_DOWNLOAD |
MS SQL Server DBCC Wait Statistics | R |
| 46 | DB_MSS_EXCLUSIVE_LOCK_WAITERS |
MS SQL Server exclusive lock waiters | R |
| 49 | MSQ_DB_SPACE_HISTORY |
MS SQL Server DB space history | R |
| 50 | MSQ_GET_DB_MONITOR_VERSION |
Get MS SQL Server DB monitor version | R |
| 57 | MSS_SHOW_ABAP_CODE |
MS SQL Server show ABAP code | R |
| 59 | TABLECONTROL_PAGING |
Table control paging up and down | |
| 61 | MSS_CALL_TCODE_SICK |
MS SQL Server: Call transaction SICK | R |
| 62 | MSS_CHECK_PARAMETER |
Check parameter value vs its type | |
| 63 | MSS_FILLING_PROCESSES |
MS SQL Server filling additonal information for processes monitor | R |
| 64 | MSS_GET_DB_MAINVERSION |
Get SQL Server main version | R |
| 65 | MSS_GET_DESTINATION |
Get RFC destination for system to be monitored | |
| 66 | MSS_GET_LOGSIZE |
SQL Server transaction log size | R |
| 67 | MSS_GET_SAPRELEASE |
Get SAP Release info (makes only sense if called remotely) | R |
| 68 | MSS_GET_SERVERINFO |
MSS-SQL Server Information | R |
| 69 | MSS_GET_SQLEXPLAIN |
MS SQL Server get explain for a given SQL statement | R |
| 71 | MSS_GET_SY_DATE_TIME |
Get system date and time for RFC (sy-datum, sy-uzeit) | R |
| 72 | MSS_GET_SY_DBSYS |
Get database name for RFC (sy-dbsys) | R |
| 73 | MSS_GET_SY_SYSID |
Get System ID for RFC (sy-sysid) | R |
| 77 | MSS_PARSE_FINAL_COMMAND |
MS SQL Server parse final command for explain | |
| 78 | MSS_R3_OWNS_CURR_DB |
R/3 owns the current db or schema: true/false. | |
| 79 | MSS_RESTORE_HIST |
MS SQL Server 6.5 restoration history overview | R |
| 82 | MSS_SELECT_ALL_MSSDEADLCK |
MS SQL Server select total deadlocks from MSSDEADLCK | R |
| 84 | MSS_SELECT_MSQSNAP |
MS SQL Server read database table MSQSNAP | R |
| 85 | MSS_SET_DESTINATION |
Set RFC destination for system to be monitored (in user GPA) | |
| 88 | TABLECONTROL_DOWNLOAD |
Table control download | |
| 89 | MSS_GET_EXPLAIN_QA |
Get rowset containing SQL Server Explain | |
Transaction Code
History
| Last changed by/on | SAP | 20100421 |
| SAP Release Created in |
