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 specified in the error message. Look for any unsupported SQL features or constructs.
  
  
  Simplify the CDS View: If possible, simplify the CDS view by removing unsupported features. This may involve:
  
  Replacing outer joins with inner joins if the logic allows.
  Avoiding subqueries and using joins instead.
  Ensuring that only supported functions and expressions are used.
  
  
  
  Check Annotations: Review the annotations used in the CDS view. Ensure that they are compatible with ESH.
  
  
  Consult Documentation: Refer to the SAP documentation for ESH and CDS to understand the supported features and limitations. This can provide guidance on what constructs are allowed.
  
  
  Test the Changes: After making adjustments to the CDS entity, test it again in the context of ESH to see if the error persists.
  
  
  Seek Help from SAP Support: If you are unable to resolve the issue, consider reaching out to SAP support for assistance. They may provide insights specific to your version and configuration.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide guidance on supported features for ESH.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can share their solutions.
  Documentation: Review the official SAP documentation for ESH and CDS to understand the capabilities and limitations of the technologies involved.
  
  By following these steps, you should be able to identify and resolve the cause of the ESH_SQL_SEARCH053 error.