SAP ABAP Function Module MSS_XML_PLAN (MS SQL server function to get statistics, showplan for SQL stmt execution.)

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_XML_PLAN	MS SQL server function to get statistics, showplan for SQL stmt execution.
Function Group	SMSSDATA	MSS: Cockpit Backend not from RAT
Program Name	SAPLSMSSDATA
INCLUDE Name	LSMSSDATAU46

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	XML_SHOWPLAN	TYPE	STRING		☐	☑	Output of set showplan_xml on
Importing	CON_NAME	TYPE	DBCON-CON_NAME	'DEFAULT'	☑	☑	Logical name of a Database Connection
Importing	SCHEMA	TYPE	MSSSCHEMA	SPACE	☑	☑	Schema name
Importing	PLAN_HANDLE	TYPE	MSSPLANHANDLE		☑	☑	handle pointing to plan used in execution of sql stmt/proc
Importing	HISTORY_ID	TYPE	MSSSTMTHCOLLID	0	☑	☑	or optionally a historical plan ID instead
Tables	OBJ_REFS	TYPE	MSSXMLOBJREFS		☑	☐	Object references in an XML showplan
Tables	PAR_VALUES	TYPE	MSQSPPARAM		☑	☐	Values extracted from XML plan
Exception	DB_ERROR	TYPE			☐	☑	Some database error occurred.
Exception	INTERNAL_ERROR	TYPE			☐	☑	Internal ADBC error.
Exception	NOT_RUNNING_ON_MSSQL	TYPE			☐	☑	Not MSSQL
Exception	CONNECT_ERROR	TYPE			☐	☑	Can't connect

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