SAP ABAP Function Module GET_PROCESSINFO_MSS (get data from sysprocesses)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-MSS (Application Component) Microsoft SQL Server
     STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Function Module GET_PROCESSINFO_MSS get data from sysprocesses  
Function Group SMSSDATA   MSS: Cockpit Backend not from RAT  
Program Name SAPLSMSSDATA    
INCLUDE Name LSMSSDATAU28    
Parameters
Type Parameter Name Typing Associated Type Default value Optional Pass Value Short text
Importing EX_STATUS TYPE MSQ_PROCES-STATUS SQL Server process status; ie sleeping, running etc.
Importing IN_STATUS TYPE MSQ_PROCES-STATUS SQL Server process status; ie sleeping, running etc.
Importing SAP_SPIDS TYPE CHAR1 Database name
Importing RES_LOCKS TYPE CHAR1 Single-character flag
Importing CON_NAME TYPE DBCON-CON_NAME 'DEFAULT' Logical name for a database connection
Importing SCHEMA TYPE MSSSCHEMA ' ' Schema name
Importing ONE_LOGIN TYPE MSSSCHEMA 'N' Schema name
Importing ONE_HOST TYPE MSQ_PROCES-HOSTNAME 'N' Hostname of the application server logged into SQL Server.
Importing ONE_WP TYPE MSQ_PROCES-PROGNAME 'N' Name of the application program which owns the connection.
Tables PROCINFO TYPE MSQ_PROCES Data on the processes connected SQL Server
Exception INVALID_EX_STATUS TYPE parameter ex_status( exclude ) is invalid
Exception INVALID_IN_STATUS TYPE parameter in_status(include) is invalid
Exception INVALID_SAP_SPIDS TYPE parameter sap_spids 'Y' or 'N' or NULL
Exception INVALID_RES_LOCKS TYPE parameter res_locks 'Y' or 'N'
Exception DB_ERROR TYPE
Exception INTERNAL_ERROR TYPE
Exception CONNECT_ERROR TYPE
               
Processing Type
Normal Function Module  
Remote-Enabled Module BaseXML supported
Update Module Start immediately
Immediate Start, No Restart
Start Delayed
Coll.run
JAVA Module Callable from ABAP  
Remote-Enabled JAVA Module  
Module Callable from JAVA  
History
Last changed by/on SAP  20100421 
SAP Release Created in 711