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

SAP Error Message - Details

• 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 not allowed.
  Use Alternative Tables: If possible, consider using a different table that is not a shared multi-tenancy table for your operation. This may involve redesigning your data model or using a different data source.
  Consult Documentation: Refer to the SAP documentation for Core Data Services and multi-tenancy to understand the limitations and best practices when working with shared multi-tenancy tables.
  Check Authorizations: Ensure that you have the necessary authorizations to access the table and perform the intended operations.
  
  Related Information:
  
  SAP Notes and Knowledge Base Articles: Check for any relevant SAP Notes or KBA that might provide additional context or solutions for this error.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  SAP Support: If the issue persists and you cannot find a resolution, consider reaching out to SAP Support for assistance.
  
  By following these steps, you should be able to address the error and proceed with your work in SAP.