SAP ABAP Function Module MSS_GET_SQLTEXT (Bestimme den SQL Definition Statement Text eines Objekts)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_DDIC (Package) Data Dictionary Porting for Microsoft SQL Server

Basic Data

Function Module	MSS_GET_SQLTEXT	Bestimme den SQL Definition Statement Text eines Objekts
Function Group	SFMSS_SYSCAT	System Catalog Meta Data
Program Name	SAPLSFMSS_SYSCAT
INCLUDE Name	LSFMSS_SYSCATU01

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	SQLSTRING	TYPE	MSSSQLTEXT		☐	☐	SQL definition statement text
Exporting	SQLSTRING_LENGTH	TYPE	INT4		☐	☐	Length of the SQL definition statement text
Importing	OBJECT_NAME	TYPE	MSSOBJECT		☐	☐	Object name
Importing	SCHEMA_NAME	TYPE	MSSSCHEMA		☑	☐	Schema name
Importing	DB_NAME	TYPE	MSSDB		☑	☐	Database name
Importing	STRING	TYPE	CHAR1		☐	☐	If 'X', then output as string.
Importing	QUOTES	TYPE	CHAR1		☐	☐	If 'X', then quotes around identifiers are not removed from the output string.
Importing	TABLE	TYPE	CHAR1		☐	☐	If 'X', then output as table.
Tables	SQLTABLE	TYPE	MSSSQLSTMT		☑	☐	SQL definition statement text
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	SQLTEXT_NOT_FOUND	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	620