SAP ABAP Function Module MSS_GET_DB_DEV_AND_USR_INFO (To get dbs, devices and user info)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server

Basic Data

Function Module	MSS_GET_DB_DEV_AND_USR_INFO	To get dbs, devices and user info
Function Group	SFMSS_JOBS	Functions used by db12, db13 for MSSQL
Program Name	SAPLSFMSS_JOBS
INCLUDE Name	LSFMSS_JOBSU30

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	DBNAME	TYPE	MSSDB		☐	☑	Database name
Exporting	USERNAME	TYPE	MSSSCHEMA		☐	☑	Schema name
Exporting	SQLVERSION	TYPE	MSSSERVER-VERSION		☐	☑	MS SQL Server version
Exporting	MAINVERSION	TYPE	MSSHELP-MAIN_VERS		☐	☑	MS SQL Server database version (main number)
Importing	CON_NAME	TYPE	DBCON-CON_NAME	'DEFAULT'	☑	☑	Logical name for a database connection
Importing	SCHEMA	TYPE	MSSSCHEMA	''	☑	☑	Schema name
Tables	ALLDATABASES	TYPE	MSSDATABASE		☐	☐	Name + access permission
Tables	DEVLIST	TYPE	MSQDEVLIST		☐	☐	MS SQL server Backup device List.
Exception	NOT_RUNNING_ON_MSSQL	TYPE			☐	☐
Exception	DB_ERROR	TYPE			☐	☐
Exception	INTERNAL_ERROR	TYPE			☐	☐
Exception	NO_MASTER_ACCESS	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	20020827
SAP Release Created in