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

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.