How To Fix ESH_SQL_SEARCH081 - SQL view &1 contains SQL features not supported by search

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 081

• Message text: SQL view &1 contains SQL features not supported by search

What causes this issue?

SQL view <(>&<)>1 contains some SQL features that are not supported by
search

System Response

The search cannot be executed because the SQL view contains some SQL
features that are not supported by search, like e.g.:
join conditions over a calculated column or
a cyclic left outer join (a cyclic join is a join where the left side of
a join contains columns from two different tables when joining another
table to the view. In the search views this may happen if either the
left side or the right side of a join condition in any of the views
contains columns from more than one table).
The shape of a cycle is not important. To have a cycle or not is the
issue. Examples of cyclic joins:

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

select *
from A
left outer join B on B.x = A.x
left outer join C on C.y = A.y
left outer join D on D.z = C.z and D.w = B.w;
==> A-B-D-C-A: cycle
select *
from A
left outer join B on B.x = A.x
left outer join C on C.y = A.y
left outer join D on D.z = C.z and D.w = A.w;
==> A-C-D-A: cycle
a left outer join that has left outer joins in both child nodes

How to fix this error?

Change the SQL view definition so that it follows the rules for CDS
search views as described in https://wiki.wdf.sap.corp/wiki/download/att
achments/1731219214/ThM_CDS_Search_View_Limitations.pdf?version=3
<(>&<)>modificationDate=1531294690000<(>&<)>api=v2

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_SEARCH081 - SQL view &1 contains SQL features not supported by search ?

  The SAP error message ESH_SQL_SEARCH081 indicates that the SQL view you are trying to use contains SQL features that are not supported by the SAP Enterprise Search (ESH) framework. This typically occurs when the SQL view includes certain constructs or functions that ESH cannot process.
  Cause:
  The error can be caused by several factors, including:
  
  Unsupported SQL Features: The SQL view may use features such as complex joins, subqueries, certain aggregate functions, or specific SQL syntax that ESH does not support.
  Database-Specific Functions: If the SQL view uses database-specific functions or constructs that are not universally supported, this can lead to the error.
  View Definition: The way the SQL view is defined may not align with the requirements of the ESH framework.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review the SQL View: Examine the SQL view definition to identify any unsupported features. Look for:
  
  Complex joins
  Subqueries
  Non-standard SQL functions
  Aggregate functions that may not be supported
  
  
  
  Simplify the View: If possible, simplify the SQL view by removing or replacing unsupported features. This may involve:
  
  Breaking down complex queries into simpler components.
  Avoiding the use of certain SQL functions that are not compatible with ESH.
  
  
  
  Create a Compatible View: If the original view cannot be modified to meet ESH requirements, consider creating a new SQL view that adheres to the limitations of the ESH framework.
  
  
  Check Documentation: Refer to the SAP documentation for ESH to understand the specific SQL features that are supported. This can provide guidance on how to structure your SQL views.
  
  
  Testing: After making changes, test the new or modified SQL view to ensure it works correctly with ESH and does not produce the same error.
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific guidance or updates related to ESH and SQL view compatibility.
  SAP Community: Engage with the SAP Community forums to see if others have encountered similar issues and what solutions they have found.
  Version Compatibility: Ensure that you are using a version of SAP that supports the features you are trying to implement, as capabilities may vary between versions.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution that allows your SQL view to work with SAP Enterprise Search.