How To Fix ESH_SQL_SEARCH081 - La vista SQL &1 contiene funciones SQL que la búsqueda no admite

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 081

• Message text: La vista SQL &1 contiene funciones SQL que la búsqueda no admite

¿Qué causa este problema?

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

Respuesta del sistema

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:

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

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

¿Cómo arreglar este 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

Procedimiento para Administradoras de Sistemas

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.