How To Fix ESH_ENG_CDSVAL_ES064 - &1 is a shared multi-tenancy table - cannot be used (&2)

ESH_ENG_CDSVAL_ES064 - Overview

• Message type: E = Error

• Message class: ESH_ENG_CDSVAL_ES - ES-CDS/ABAP: Validation of domain @EnterpriseSearch

• Message number: 064

• Message text: &1 is a shared multi-tenancy table - cannot be used (&2)

What causes this issue?

Table &V1& is shared in a multi-tenant installation; this means that
shared parts of the table are kept centrally, while the tenant-specific
parts are kept separate from them. At runtime, both are accessed via
UNION. This is not compatible with HANA's join-engine.

System Response

No Enterprise Search connector can be derived from this CDS-entity.

How to fix this error?

Remove all elements from the view that come from this table.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_ENG_CDSVAL_ES064 - &1 is a shared multi-tenancy table - cannot be used (&2) ?

  The SAP error message ESH_ENG_CDSVAL_ES064 indicates that you are trying to use a shared multi-tenancy table in a context where it is not allowed. This typically occurs in the context of Core Data Services (CDS) views or when working with certain database operations that are restricted to specific types of tables.
  
  Cause:
  
  Shared Multi-Tenancy Table: The error arises because the table you are trying to access is a shared multi-tenancy table. These tables are designed to support multiple tenants in a cloud environment, and certain operations or queries may not be permitted on them.
  Inappropriate Context: The operation you are attempting (e.g., a specific type of join, aggregation, or data manipulation) is not compatible with the shared multi-tenancy model.
  
  
  Solution:
  
  Review the Query/Operation: Check the query or operation you are trying to perform. Ensure that it is compatible with shared multi-tenancy tables. You may need to adjust your query to avoid using operations that are