SAP Knowledge Base Article - Public

2833998 - Cannot extend the analytical query C_SALESVOLUMEANALYTICSQRY

Symptom

Customer has copied query C_SALESVOLUMEANALYTICSQRY. After selecting the field SalesVolumeQuantity to add it to the query, the following errors are presented when saving the draft:

  • Conditions for different elements or negations must be combined with AND
  • Select option cannot be created; condition is too complex
  • Error while processing WHERE clause

Environment

 SAP S/4HANA CLOUD 1908

Reproducing the Issue

  1. Open the "Custom Analytical Queries" application
  2. Copy query "C_SALESVOLUMEANALYTICSQRY"
  3. Select the field SalesVolumeQuantity to add it
  4. Save the draft

Cause

 Filter "SDDocumentCategory" is creating a complex condition on save of query.

Resolution

  1. Open the Copied query
  2. Click "Filters" tab
  3. Search "SDDocumentCategory" and it displays "contains error" message
  4. Navigate to the right panel "Fixed Values"
  5. Edit and follow the steps in the document "Query_Condition_Solution.docx" attached

Keywords

C_SALESVOLUMEANALYTICSQRY, Analytical, Query, Custom Analytical Queries, SDDocumentCategory , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud all versions

Attachments

Query_Condition_Solution.docx