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

SAP Error Message - Details

• 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 values rather than allowing user input. This can be done by modifying the query definition in the Query Designer.
  Check Query Settings: Review the settings in the Query Designer to ensure that the currency and unit fields are configured correctly. Make sure that they are set to fixed values where necessary.
  Modify Variables: If you are using variables for currency or units, consider changing them to fixed values or ensuring that they are defined correctly to avoid this error.
  Review Data Source: Check the underlying data source to ensure that it is set up correctly to handle currency and unit conversions. This may involve checking the InfoObject settings or the characteristics used in the query.
  Test with Different Values: If possible, test the query with different fixed values for currencies or units to see if the error persists.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance on handling currency and unit conversions in queries.
  Documentation: Refer to SAP BW documentation for best practices on designing queries that involve currency and unit conversions.
  Community Forums: Consider searching or posting in SAP community forums for additional insights from other users who may have encountered and resolved similar issues.
  
  By following these steps, you should be able to resolve the RSRTS_CDS218 error and ensure that your queries function correctly with currency and unit values.