SAP ABAP Function Module MSS_GET_TOP_N_TABLES (Get the top n largest/modified tables)

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	MSS_GET_TOP_N_TABLES	Get the top n largest/modified tables
Function Group	SMSSDATA	MSS: Cockpit Backend not from RAT
Program Name	SAPLSMSSDATA
INCLUDE Name	LSMSSDATAU58

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Importing	CON_NAME	TYPE	DBCON-CON_NAME	'DEFAULT'	☑	☑	DBCON name
Importing	SCHEMA	TYPE	MSSSCHEMA	SPACE	☑	☑	Target Schema
Importing	NUMBER	TYPE	INT4	25	☑	☑	Number of tables
Importing	ORDER	TYPE	CHAR1		☐	☑	'L' : largest; 'M' : modified
Importing	SCHEMA_NAME	TYPE	MSSSCHEMA		☑	☑	Schema name
Importing	DB_NAME	TYPE	MSSDB		☑	☑	Database name
Tables	LARGE_TABLES	TYPE	MSSTOPLARGE		☑	☐	Top large tables
Tables	MODIFIED_TABLES	TYPE	MSSTOPMODI		☑	☐	Top modified tables
Exception	NOT_RUNNING_ON_MSSQL	TYPE			☐	☐
Exception	DB_ERROR	TYPE			☐	☐
Exception	INTERNAL_ERROR	TYPE			☐	☐
Exception	DB_NOT_FOUND	TYPE			☐	☐
Exception	NO_DB_ACCESS	TYPE			☐	☐
Exception	SCHEMA_NOT_FOUND	TYPE			☐	☐
Exception	INVALID_INPUT	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