SAP Knowledge Base Article - Public

3545592 - Report Selection Discrepancy in Sales Quote Report

Symptom

The report ABC is created on top of the data source Sales Quote Item[CODCQTIB] and shows different results compared to the Sales Quote work center when the same filter criteria are applied. (ABC stands your custom report)

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Navigate to the Business Analytics work center.
  2. Select the Design Reports view.
  3. Search and open the report ABC.
  4. Apply the filter criteria and run the report.
  5. Navigate to the Sales work center, Sales Quote view and apply the same filter criteria. The results will differ from the report.

Cause

The report ABC is created on top of the data source Sales Quote Item [CODCQTIB]. This data source only shows quotes with items (Products), which is standard behavior and explains the difference between the report and work center.

Resolution

Build a new report on top of Sales Quote Header [CODCQTHB]. This should provide the expected data, which is the same as the data in the Sales Quote work center.

See Also

Keywords

Sales Quote Analysis, report, filter, quotes, work center, Sales Quote Item [CODCQTIB], Sales Quote Header [CODCQTHB], data source, discrepancy, report selection. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions