How To Fix FDT_EXPRESSIONS068 - Too many range entries; max. 99 entries are supported

SAP Error Message - Details

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 068

• Message text: Too many range entries; max. 99 entries are supported

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 FDT_EXPRESSIONS068 - Too many range entries; max. 99 entries are supported ?

  The SAP error message FDT_EXPRESSIONS068 indicates that you have exceeded the maximum number of range entries allowed in a certain context, which is 99 entries. This error typically occurs when you are trying to define a range of values in a selection screen or a filter that exceeds this limit.
  Cause:
  The error is caused by attempting to create a range with more than 99 entries. This can happen in various scenarios, such as:
  
  When using a selection screen in a report or transaction.
  When defining filters in a query or data extraction process.
  When using expressions in the context of SAP Fiori or other applications that utilize the FDT (Form Data Tool).
  
  Solution:
  To resolve this error, you can consider the following approaches:
  
  
  Reduce the Number of Entries: 
  
  Review the range entries you are trying to use and see if you can reduce the number of entries to 99 or fewer. This may involve consolidating values or using broader ranges.
  
  
  
  Use Alternative Logic:
  
  If you need to filter on more than 99 values, consider using alternative logic, such as:
  
  Using a database table or a temporary table to store the values and then referencing that table in your selection criteria.
  Implementing a more complex selection logic that can handle larger datasets without exceeding the limit.
  
  
  
  
  
  Split the Query:
  
  If applicable, split your query or selection into multiple parts, each with fewer than 99 entries, and then combine the results programmatically.
  
  
  
  Check for Updates:
  
  Ensure that your SAP system is up to date. Sometimes, newer versions or patches may increase limits or provide alternative methods for handling large datasets.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or community forums for any specific guidelines or best practices related to the context in which you are encountering this error.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific fixes or recommendations related to this error message.
  Performance Considerations: When working with large datasets, consider performance implications and optimize your queries accordingly.
  SAP Community: Engage with the SAP Community for insights from other users who may have encountered and resolved similar issues.
  
  By following these steps, you should be able to address the FDT_EXPRESSIONS068 error effectively.