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

SAP Error Message - Details

• 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 to be user-modifiable, leading to them being hidden during execution.
  
  Solution:
  
  Check Variable Settings: Review the settings of the variable in the Query Designer. Ensure that the variable is not set to be hidden or that it does not have default values that make it hidden.
  Modify Query Design: If the variable is essential for user input, consider redesigning the query to allow the variable to be visible. This may involve changing the properties of the variable in the Query Designer.
  User Context: If the variable is context-sensitive (e.g., based on user or date), ensure that the context is appropriate for the intended use of the query. You may need to adjust the user settings or the date context.
  Testing: After making changes, test the query to ensure that the parameter behaves as expected and is visible when needed.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes or documentation that may provide additional insights or updates regarding this error message.
  Query Designer Documentation: Familiarize yourself with the Query Designer and how variables are managed within queries. This can help in understanding how to configure parameters effectively.
  User Roles and Authorizations: Ensure that the user executing the query has the necessary authorizations to view and interact with the parameters in question.
  
  If the issue persists after trying the above solutions, consider reaching out to your SAP support team or consulting the SAP Community for further assistance.