2884613 - Category ID from Service Catalog Shows Wrong Description in Reporting

You are reporting on tickets, the service catalog and the categories by using the data source Ticket (CRMSRQHB). You display a category ID, for example an object category ID, and you change the characteristic setting to show the description as well.

SAP Cloud for Customer

1. Go to the work center Business Analytics and the view Design Reports.
2. Open your report based on the data source CRMSRQHB.
3. Make the required selection.
4. Take a category ID field, for example, Object Category ID.
5. In the view, click on this field and open the settings.
6. Change the display to ID and Description, or Description only.

You see that the description for this ID is not correct. It comes from another catalog. You expect the description to be picked depending on the ticket type of the ticket, and the ticket type that was set in the catalog.

The option to have a specific catalog for a certain ticket type is a relatively new feature. The description of a category ID is an old feature which cannot consider the different catalogs and which ticket type they belong to. If several catalogs are active, the description is picked randomly.

This is an enhancement request which we have taken up into the planning for the future releases.

The behavior happens because the categories in the various catalogs are not unique. Such a setup is not recommended. We would strongly recommend that each catalog as well as each catalog version has IDs and descriptions which are unique. Such IDs are used in the system to identify and differentiate one object from another, but if they are re-used multiple times across several catalogs or versions, the identification is not clear.

See also: KBA 2693915 - Reporting on Ticket, Service Categories and Service Catalogs

object category, incident category, cause category, service category, resolution category, description, duplicate, report, tickets, data source, ID, ticket type , KBA , category id , ticket data source , crmsrqhb , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-SRP , Service Request Processing , Product Enhancement

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