How To Fix ESH_SQL_SEARCH053 - Check if the DDL of CDS entity &1 contains only ESH-supported features

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 053

• Message text: Check if the DDL of CDS entity &1 contains only ESH-supported features

What causes this issue?

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

System Response

The search leads to an error.

How to fix this error?

There are some limitations by searching with Enterprise Search in CDS
views. The limitations are not caused by Enterprise Search itself, but
rather by SAP HANA. The join engine is very restrictive regarding
allowed SQL operations.
Examples:
- Operations like CASE, CAST, UNION ALL,... are not supported and will
break the search.

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 ESH_SQL_SEARCH053 - Check if the DDL of CDS entity &1 contains only ESH-supported features ?

  The SAP error message ESH_SQL_SEARCH053 indicates that there is an issue with the Data Definition Language (DDL) of a Core Data Services (CDS) entity that is being used in the context of SAP Enterprise Search (ESH). Specifically, it suggests that the CDS entity contains features that are not supported by ESH.
  
  Cause:
  The error typically arises when the CDS view includes certain SQL features or constructs that are incompatible with the ESH framework. Common causes include:
  
  
  Unsupported SQL Constructs: The CDS entity may use SQL features such as:
  
  Certain types of joins (e.g., outer joins)
  Subqueries
  Aggregations that are not supported
  Specific functions or expressions that ESH cannot process
  
  
  
  Complex Data Types: The use of complex data types or structures that ESH does not support.
  
  
  Annotations: Certain annotations in the CDS view that are not recognized or supported by ESH.
  
  
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Review the CDS Entity: Check the DDL of the CDS entity