SAP ABAP Function Module MSS_CREATE_CS_INDEX (Create Column Store Index)

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_CREATE_CS_INDEX	Create Column Store Index
Function Group	SFMSS_SYSCAT	System Catalog Meta Data
Program Name	SAPLSFMSS_SYSCAT
INCLUDE Name	LSFMSS_SYSCATU22

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	SQL_TEXT	TYPE	STRING		☐	☑	SQL statements as string
Exporting	DBINDEX	TYPE	DBINDEX_D		☐	☑	Name eines Datenbankindexes
Exporting	STATEMENTS	TYPE	RSSOURCET		☐	☑	SQL statements as table
Importing	TABNAME	TYPE	TABNAME		☐	☑	Tabellenname
Importing	INDEXID	TYPE	INDEXID	'CS'	☑	☑	Eindeutige Indexkennung innerhalb einer Tabelle
Importing	IS_CLUSTERED	TYPE	ABAP_BOOL	ABAP_FALSE	☑	☑	X: Clustered CS index
Importing	NO_EXEC	TYPE	ABAP_BOOL	ABAP_FALSE	☑	☑	X: No Execute
Importing	MAXDOP	TYPE	I	8	☑	☑	Max degree of parallelism
Importing	IS_CS_ARCHIVE	TYPE	ABAP_BOOL	ABAP_FALSE	☑	☑	Use new compression type
Exception	INDEX_EXISTS	TYPE			☐	☐	CS Index existiert bereits
Exception	TABLE_ALREADY_HAS_CS_INDEX	TYPE			☐	☐	Ein anderer CS Index existiert bereits
Exception	INDEX_NOT_DEFINED	TYPE			☐	☐	Kein CS Index notwendig
Exception	NOT_SUPPORTED_CS_INDEX	TYPE			☐	☐	CS Index nicht supported für das SQL Release
Exception	NOT_SUPPORTED_DATA_TYPE	TYPE			☐	☐	CS Index enthält nicht supporteten Datentyp
Exception	INDEX_NOT_CREATED	TYPE			☐	☐	Index wurde nicht erstellt
Exception	TABLE_DOES_NOT_EXIST	TYPE			☐	☐	Tablle existiert nicht

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	20130604
SAP Release Created in	620