How To Fix SMMSS_DDIC002 - You can only set CLUSTERED for one index

SMMSS_DDIC002 - Overview

• Message type: E = Error

• Message class: SMMSS_DDIC - DDIC Messages for Microsoft SQL Server

• Message number: 002

• Message text: You can only set CLUSTERED for one index

What causes this issue?

You have set CLUSTERED YES for more than one index. However, only one
index per table can be a clustered index.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Correct your entry.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_DDIC002 - You can only set CLUSTERED for one index ?

  The SAP error message SMMSS_DDIC002 indicates that you are trying to set the "CLUSTERED" attribute for more than one index on a database table. In a database, a clustered index determines the physical order of data in the table, and only one clustered index can exist per table. This is a fundamental rule in database design.
  
  Cause:
  The error occurs when:
  
  You attempt to define multiple indexes on a table with the "CLUSTERED" option.
  The table already has a clustered index defined, and you are trying to create another one.
  
  
  Solution:
  To resolve this error, you need to ensure that only one index is defined as clustered for the table. Here are the steps you can take:
  
  
  Review Existing Indexes: Check the existing indexes on the table to see if there is already a clustered index defined. You can do this using the Data Dictionary (SE11) or by checking the database directly.
  
  
  Modify Index Definitions:
  
  If you find that