How To Fix SADL_GW_ATC_CONSMPTN820 - Type STRING cannot be used with ranking functions (&1)

SADL_GW_ATC_CONSMPTN820 - Overview

• Message type: E = Error

• Message class: SADL_GW_ATC_CONSMPTN - SADL Gateway: ATC Messages for Consumtion Annotations

• Message number: 820

• Message text: Type STRING cannot be used with ranking functions (&1)

What causes this issue?

Element &V1& is of type STRING. This type cannot be used with ranking
functions.

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?

Remove the @Consumption.ranking.parameterBinding-annotation at the
element. If this means that the ranking function cannot be applied to
the view, remove the corresponding @Consumption.ranking.activeFunctions,
too.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

SADL_GW_ATC_CONSMPTN820 - Details

• The SAP error message SADL_GW_ATC_CONSMPTN820 indicates that there is an issue with the use of ranking functions in your ABAP CDS (Core Data Services) view or query. Specifically, the error message states that a type STRING cannot be used with ranking functions. This typically occurs when you are trying to apply ranking functions (like ROW_NUMBER(), RANK(), etc.) to a field that is of type STRING.
  Cause
  The root cause of this error is that ranking functions in SQL require numeric or date types to perform their calculations. When you attempt to use a STRING type field in a ranking function, the system raises this error because it cannot perform the necessary operations on string data.
  Solution
  To resolve this error, you can take the following steps:
  
  
  Check the Data Type: Review the fields you are using in your ranking function. Ensure that you are not using any STRING type fields directly in the ranking function.
  
  
  Convert