How To Fix RSRTS_CDS083 - Value &1 cannot be used in path filter - see long text

RSRTS_CDS083 - Overview

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 083

• Message text: Value &1 cannot be used in path filter - see long text

What causes this issue?

A path filter uses a constant value which does not represent a date.
The annotation @Analytics.query indicates that the CDS view is used for
the generation of a BW query. In this case<(>,<)> usage of path filters
is limited. In particular<(>,<)> literals (i.e. constant values) can
only be used for providing dates if dealing with time-dependent
attributes.

System Response

Correct the CDS view accordingly.

How to fix this error?

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

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

RSRTS_CDS083 - Details

• The SAP error message RSRTS_CDS083 indicates that a value you are trying to use in a path filter for a Core Data Services (CDS) view or a query cannot be processed. This typically occurs in the context of using the SAP BW (Business Warehouse) or SAP HANA environments where CDS views are utilized for reporting and data retrieval.
  
  Cause:
  The error can arise due to several reasons:
  
  Invalid Value: The value you are trying to filter on may not exist in the underlying data model or may not be valid for the specific context of the query.
  Data Type Mismatch: The data type of the value you are using in the filter may not match the expected data type in the CDS view.
  Path Filter Issues: If you are using a path filter, the structure of the path may not be correctly defined, or the value may not correspond to the expected hierarchy or structure.
  Authorization