How To Fix ESH_SQL_SEARCH081 - SQL-View &1 enthält SQL-Funkt., die v.der Suche nicht unterstützt werden

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 081

• Message text: SQL-View &1 enthält SQL-Funkt., die v.der Suche nicht unterstützt werden

Was verursacht dieses Problem?

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

Systemantwort

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:

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

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

Wie behebe ich diesen Fehler?

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

Vorgehensweise für Systemadministratoren

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE