How To Fix RSRTS_CDS108 - CDS formula (at pos. &1) will be ignored: Formula annotation present

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 108

• Message text: CDS formula (at pos. &1) will be ignored: Formula annotation present

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRTS_CDS108 - CDS formula (at pos. &1) will be ignored: Formula annotation present ?

  The SAP error message RSRTS_CDS108 indicates that there is an issue with a CDS (Core Data Services) formula in your SAP system. Specifically, the message states that the formula at a certain position (indicated by &1) will be ignored because there is a formula annotation present. This typically occurs in the context of using CDS views in SAP BW (Business Warehouse) or SAP HANA.
  Cause:
  The error is caused by the presence of a formula annotation in the CDS view that conflicts with the way the formula is defined or used. In SAP, annotations are metadata that provide additional information about the data model, and certain annotations can dictate how calculations or aggregations should be handled. If a formula is defined in a way that is incompatible with the annotations present, the system will ignore the formula to prevent errors in data processing.
  Solution:
  To resolve this issue, you can take the following steps:
  
  
  Review the CDS View: Check the CDS view definition where the error is occurring. Look for any formula annotations that might be conflicting with the formula you are trying to use.
  
  
  Adjust the Formula: If the formula is not compatible with the annotations, you may need to modify the formula or the annotations. Ensure that the formula aligns with the intended calculations and that the annotations are appropriate for the data model.
  
  
  Remove or Modify Annotations: If the annotations are not necessary for your use case, consider removing or modifying them to allow the formula to be processed correctly.
  
  
  Check Documentation: Refer to the SAP documentation for CDS views and annotations to understand the specific requirements and limitations of the annotations you are using.
  
  
  Test Changes: After making adjustments, test the CDS view to ensure that the formula is now being processed correctly and that the data is being returned as expected.
  
  
  Related Information:
  
  CDS Views: Core Data Services are a way to define semantically rich data models in SAP. They allow for the creation of complex data models that can be consumed by various SAP applications.
  Annotations: Annotations in CDS views provide metadata that can influence how data is processed, displayed, or aggregated. Common annotations include @Analytics, @UI, and @AccessControl.
  SAP BW: If you are working within the SAP BW environment, ensure that your data models and queries are aligned with the BW best practices for using CDS views.
  
  If the issue persists after following these steps, consider reaching out to your SAP support team or consulting the SAP Community for further assistance.