How To Fix E2088 - Index on HDB must not start with 'H'

E2088 - Overview

• Message type: E = Error

• Message class: E2 - DE Data Dictionary

• Message number: 088

• Message text: Index on HDB must not start with 'H'

What causes this issue?

An index name H"xx", such as H01, for example, is reserved for
HANA-specific indexes through exactly one table column. These are cr
eated in customer systems too through the program SHDB_INDEX_CREATE (see
also Note 1794297).

System Response

This index here will not be created.

How to fix this error?

So that possible name conflicts are avoided, the current name for the
index is declined. If you wish to create an index specially for HANA DB
using exactly one table column, you should do this using the above
program. All indexes that were created in advance using the program in
customer systems should also exist in the current system. However, you
are preventing - through the use of this program - that there will be an
index for the same definition that is already created in the customer
system.
You should use a different index name and create the index directly in
SE11.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message E2088 - Index on HDB must not start with 'H' ?

  The SAP error message E2088, which states "Index on HDB must not start with 'H'," typically occurs in the context of SAP HANA database operations. This error is related to the naming conventions for indexes in HANA. Here’s a breakdown of the cause, potential solutions, and related information:
  
  Cause:
  
  
  Naming Convention Violation: In SAP HANA, there are specific naming conventions that must be followed for database objects, including indexes. The error indicates that the index name you are trying to create or use starts with the letter 'H', which is not allowed by the system.
  
  
  Reserved Prefix: The prefix 'H' may be reserved for internal use or may conflict with existing naming conventions in the HANA database.
  
  
  
  Solution:
  
  
  Rename the Index: The most straightforward solution is to rename the index so that it does not start with the letter 'H'. Choose a name that adheres to the naming conventions of HANA. For example, you could