How To Fix ESH_SQL_SEARCH052 - CDS entity &1 not enabled for enterprise search, check the DDL

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 052

• Message text: CDS entity &1 not enabled for enterprise search, check the DDL

What causes this issue?

It looks like the corresponding DDL to the CDS entity contains the
annotation '@EnterpriseSearch.enabled: false', or a MetaDataExtension
(MDE) exists, which inactivates the CDS-connector for Enterprise Search,
or the connector was inactivated in the Cockpit.
The CDS-connector associated to the CDS-entity is not searchable.

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?

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_SEARCH052 - CDS entity &1 not enabled for enterprise search, check the DDL ?

  The SAP error message ESH_SQL_SEARCH052 indicates that a Core Data Services (CDS) entity is not enabled for Enterprise Search. This typically occurs when the CDS view you are trying to use for search functionality has not been properly configured to be searchable in the Enterprise Search framework.
  Cause:
  
  CDS Entity Not Configured for Search: The CDS entity may not have the necessary annotations that enable it for Enterprise Search.
  Missing DDL: The Data Definition Language (DDL) for the CDS view may not include the required annotations for search.
  Search Configuration Issues: The Enterprise Search configuration may not be set up correctly to recognize the CDS entity.
  Transport Issues: If the CDS view was recently transported, it may not have been activated in the target system.
  
  Solution:
  
  
  Check Annotations: Ensure that the CDS entity has the appropriate annotations for Enterprise Search. You should look for the @Search.searchable annotation in the CDS definition. For example:
  @Search.searchable: true
  define view Z_MY_CDS_VIEW as select from ...
  
  
  Activate the CDS View: If you have made changes to the CDS view or its annotations, make sure to activate it in the ABAP Development Tools (ADT) or SE11 transaction.
  
  
  Check DDL: Use the transaction code SE11 or the ABAP Development Tools to check the DDL of the CDS view. Ensure that it is correctly defined and includes the necessary annotations.
  
  
  Enterprise Search Configuration: Verify that the Enterprise Search configuration is set up correctly. This includes checking the search connector and ensuring that the CDS view is included in the search model.
  
  
  Re-indexing: If the CDS view is correctly configured but still not searchable, you may need to re-index the search model. This can be done through the Enterprise Search administration tools.
  
  
  Transport Issues: If the CDS view was transported, ensure that it has been activated in the target system. You may need to check the transport logs for any issues.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to Enterprise Search and CDS views.
  Documentation: Refer to the official SAP documentation on Enterprise Search and CDS views for detailed guidance on configuration and best practices.
  Community Forums: Consider checking SAP Community forums or other user groups for similar issues and solutions shared by other users.
  
  By following these steps, you should be able to resolve the ESH_SQL_SEARCH052 error and enable the CDS entity for Enterprise Search.