SAP ABAP Message Class SMMSS_DDIC Message Number 003 (There can be only one clustered 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

Attribute

Message class	SMMSS_DDIC
Short Description	DDIC Messages for Microsoft SQL Server
Message Number	003
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

There can be only one clustered index

Help Document

Diagnosis

You have set CLUSTERED YES for a secondary index and you set the index memory parameters for a table that does not (yet) exist in the database or that does exist in the database but that does not have a primary index or a clustered primary index.

As you did not set CLUSTERED NO for the primary index, a database error would occur for the non-existent table if it was created in the database or for the existent table during a conversion.

System Response

Procedure

If you really want to create a clustered secondary index, you must set the primary index to CLUSTERED NO.

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in