How To Fix SADL_GW_ATC_CONSMPTN801 - @Consumption.ranking.activeFunctions must be annotated at view

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 801

• Message text: @Consumption.ranking.activeFunctions must be annotated at view

What causes this issue?

@Consumption.ranking.activeFunctions can be annotated on header-level
only.

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 annotation wherever it is annotated at a view element.

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 SADL_GW_ATC_CONSMPTN801 - @Consumption.ranking.activeFunctions must be annotated at view ?

  The error message SADL_GW_ATC_CONSMPTN801 @Consumption.ranking.activeFunctions must be annotated at view typically occurs in the context of SAP Gateway and the SAP ABAP programming model, particularly when working with CDS (Core Data Services) views and OData services.
  Cause:
  This error indicates that the CDS view you are trying to expose as an OData service is missing the required annotation for the @Consumption.ranking.activeFunctions. This annotation is necessary for the SAP Gateway to understand how to rank the functions that can be executed on the OData service. Without this annotation, the system cannot determine the active functions for the consumption of the OData service, leading to the error.
  Solution:
  To resolve this error, you need to add the required annotation to your CDS view. Here’s how you can do it:
  
  
  Open the CDS View: Locate the CDS view in your ABAP development environment (e.g., Eclipse with ABAP Development Tools).
  
  
  Add the Annotation: You need to add the @Consumption.ranking.activeFunctions annotation to the view definition. Here’s an example of how to do this:
  @AbapCatalog.sqlViewName: 'Z_MY_CDS_VIEW'
  @AbapCatalog.compiler.compareFilter: true
  @AccessControl.authorizationCheck: #CHECK
  @Consumption.ranking.activeFunctions: [ 
      { 
          function: 'FunctionName1', 
          rank: 1 
      }, 
      { 
          function: 'FunctionName2', 
          rank: 2 
      } 
  ]
  define view Z_MY_CDS_VIEW as select from my_table
  {
      key field1,
      field2,
      field3
  }
  In this example, replace FunctionName1 and FunctionName2 with the actual function names you want to expose, and adjust the ranks as necessary.
  
  
  Activate the CDS View: After adding the annotation, activate the CDS view.
  
  
  Regenerate the OData Service: If the CDS view is part of an OData service, you may need to regenerate the service to ensure that the changes take effect.
  
  
  Test the OData Service: After making these changes, test the OData service to ensure that the error is resolved and that the functions are correctly ranked.
  
  
  Related Information:
  
  SAP Documentation: Refer to the official SAP documentation on CDS views and OData services for more details on annotations and their usage.
  SAP Community: You can find discussions and solutions related to similar issues on the SAP Community forums.
  ABAP Development Tools: Familiarize yourself with the ABAP Development Tools in Eclipse, as they provide a robust environment for developing and managing CDS views and OData services.
  
  By following these steps, you should be able to resolve the error and successfully annotate your CDS view for consumption.