How To Fix ESH_SQL_SEARCH081 - La vue SQL &1 contient des fonct. SQL non prises en charge par la rech.

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 081

• Message text: La vue SQL &1 contient des fonct. SQL non prises en charge par la rech.

Quelle est la cause de ce problème?

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

Réponse du système

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:

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

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

Comment corriger cette erreur?

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

Procédure pour les administrateurs système

Extrait du message d'erreur du système SAP. Copyright SAP SE.