How To Fix RSRTS_CDS006 - Select option cannot be created; condition is too complex

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRTS_CDS - Messages Transient CDS Queries

• Message number: 006

• Message text: Select option cannot be created; condition is too complex

What causes this issue?

The CDS View contains a condition which cannot be converted into a
select option table.

System Response

Generation of BW Query based on this CDS View will result in an error

How to fix this error?

To support conversion of the condition into a select option table, you
must comply with the following rules:
Combine conditions for different elements with AND
Combine negated conditions for any element with AND
Combine conditions for same elements with OR (unless NOT is used)
Only use parentheses for OR expressions (enforcing OR to be evaluated
prior to AND)
Example: ( sales_region = 'SOUTH' OR sales_region = 'WEST' ) AND
( product_category = 'CAT29' OR product_category between 'CAT01'
and 'CAT20' ) AND NOT product_category = 'CAT17'

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRTS_CDS006 - Select option cannot be created; condition is too complex ?

  The SAP error message RSRTS_CDS006 indicates that a select option cannot be created because the condition defined in the query is too complex. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when working with queries that involve complex conditions or filters.
  Cause:
  
  Complex Conditions: The query may have too many conditions or filters that exceed the system's limitations for processing.
  Data Source Limitations: The underlying data source (like a CDS view or InfoProvider) may have restrictions on the complexity of the conditions that can be applied.
  Performance Issues: The complexity of the query may lead to performance issues, prompting the system to restrict the creation of certain select options.
  
  Solution:
  
  
  Simplify the Query: Review the query and try to simplify the conditions. This may involve:
  
  Reducing the number of filters.
  Combining similar conditions.
  Breaking down complex conditions into simpler ones.
  
  
  
  Use Variables: Instead of using multiple static filters, consider using variables that can dynamically adjust based on user input. This can help reduce complexity.
  
  
  Check Data Source: Ensure that the data source can handle the complexity of the query. If necessary, consider creating a new, simpler data source or view that aggregates the required data.
  
  
  Optimize Performance: Look for ways to optimize the performance of the query. This may involve indexing, partitioning, or other database optimization techniques.
  
  
  Consult Documentation: Refer to SAP documentation or notes related to query design and limitations for specific guidance on handling complex queries.
  
  
  SAP Support: If the issue persists, consider reaching out to SAP support for assistance. They may provide specific patches or updates that address the issue.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide guidance on query design best practices.
  Query Designer: Familiarize yourself with the Query Designer tool in SAP BW, which can help in visualizing and simplifying complex queries.
  Performance Tuning: Look into performance tuning techniques for SAP BW queries, as this can often alleviate issues related to complexity.
  
  By following these steps, you should be able to resolve the RSRTS_CDS006 error and create the necessary select options for your query.