How To Fix RSRTS_CDS218 - Entry &1: Currencies/units can only be provided as fixed values

RSRTS_CDS218 - Overview

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 218

• Message text: Entry &1: Currencies/units can only be provided as fixed values

What causes this issue?

In a CDS view annotated with @Analytics.query: true (i.e. the CDS View
is used for generation of a BW Query) you annotated an entry in the
select list with
@Semantics.currencyCode: true or
@Semantics.unitOfMeasure: true
This is supported only if currency or unit are characteristics of the
InfoProvider or are provided as a fixed value.

System Response

The system cannot generate a BW query based on the CDS view.

How to fix this error?

Either remove the select list entry or provide a fixed value - e.g.
cast( 'H' as abap.unit(3) ) as FixUnit

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 RSRTS_CDS218 - Entry &1: Currencies/units can only be provided as fixed values ?

  The SAP error message RSRTS_CDS218 typically occurs in the context of SAP BW (Business Warehouse) when working with queries that involve currency or unit conversion. This error indicates that the system is expecting fixed values for currencies or units, but it has encountered a situation where variable values are being used instead.
  
  Cause:
  
  Dynamic Variables: The query might be using dynamic variables for currency or unit fields instead of fixed values. This can happen if the query is designed to allow user input for currency or unit selection.
  Incorrect Query Design: The query might not be properly designed to handle currency or unit conversions, leading to the system not being able to interpret the values correctly.
  Data Source Issues: The underlying data source (e.g., InfoProvider) may not be set up to handle currency or unit conversions properly.
  
  
  Solution:
  
  Use Fixed Values: Ensure that the currency or unit fields in your query are set to use fixed