How To Fix RSRTS_CDS122 - Parameter &1 will become hidden variable for current date, lang. or user

RSRTS_CDS122 - Overview

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 122

• Message text: Parameter &1 will become hidden variable for current date, lang. or user

What causes this issue?

Parameter &V1& uses special data type &V2& and has no annotations
specifying a derivation or default value. For compatibility reasons
<(>,<)> it will therefore be converted into a hidden BW Variable filled
with the current date, logon language and user (depending on the data
type).

System Response

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

How to fix this error?

To avoid this implicit conversion, avoid data types SYLANGU, SYDATE and
SYUSER, provide a derivation or default value<(>,<)> or explicitely set
@Consumption.hidden to False.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRTS_CDS122 - Parameter &1 will become hidden variable for current date, lang. or user ?

  The SAP error message RSRTS_CDS122 indicates that a parameter in a query is being treated as a hidden variable due to the current date, language, or user context. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when using the Query Designer or when executing queries that involve variables.
  
  Cause:
  
  Parameter Context: The parameter in question is likely defined in a way that it is sensitive to the current date, language, or user. For example, if a parameter is set to filter data based on the current date, it may not be visible in the selection screen because it is automatically populated based on the context.
  Variable Settings: The variable might be configured to be hidden or to have default values that are automatically applied based on the user or system settings.
  Query Design: The query might be designed in such a way that certain parameters are not meant