SAP Knowledge Base Article - Public

2680178 - Number of Tickets in The Ticket Reports and Service Work Center are different.

Symptom

You run a report based on Data source Ticket, you notice the number of tickets in a Report do not match to the number of tickets in the tickets view in Service Work Center.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics Work Center.
  2. Go to the Report view and open a ticket report based on Data source CRMSRQHB.
  3. Download the report to Excel and count the total amount of tickets.

The total amount of Tickets that you count is 296 (For example).

Compare this with the Ticket View:

  1. Go to the service Work Center.
  2. Go To the ticket View or Employee Support View.
  3. Search for all tickets.

You can see the total amount of Tickets displayed is 96(For example). This is different to the amount counted in the report.

Cause

This is not the correct way to compare results of the tickets in the report and those in the Service work center. The search criteria is not the same.

In the service work center, Ticket View or Employee Support View the search applies all Ticket types, however in the report the search applies some additional filters. For example, irrelevant tickets are automatically filtered out.

Resolution

You can add the field classification (

Keywords

Ticket report, Data source CRMSRQHB, ticket,  irrelevant tickets, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP HYBRIS C4C CORE all versions