SAP Knowledge Base Article - Public

3540132 - Service Tickets are not Getting Sorted Based on the Status Code

Symptom

In the Ticket's OWL (Object Work List), tickets are not getting sorted in an ascending order as per status number-code.

Environment

SAP CLOUD FOR CUSTOMER.

Reproducing the Issue

  1. Go to the Service work center.
  2. Go to the Tickets view and select standard query All Tickets.
  3. Now select the column name Status and click on Sort Ascending.

You will see the ticket list is not sorted in an ascending order (For example: Ticket with status code as 5 is showing at the top, whereas tickets with the status code as 1 is showing below in the list).

Cause

You have not correctly adapted, how the status based on status code or status description should be sorted.

Resolution

  1. Go to the Service work center.
  2. Go to the Tickets view and select standard query All Tickets.
  3. Go to the Adaptation Mode and select the Ticket List.
  4. Now, right click on the Status column and then in the Overview section of Adaptation Mode click on Value - Drill Down.
  5. Further click on Code List - Drill Down, where you have set Display as Code and Value.
  6. However, for the Sort option you have selected the Ascending Description.
  7. You need to select sort option as Ascending Code, so that in the Ticket List the tickets will be sorted in ascending order based on the status number - code instead of status description.
  8. After making the adaptation changes, click on the End Adaptation.

Now, you will see the tickets are getting sorted based on status code (For example: Ticket with status code as 1 is showing at the top, whereas tickets with the status code as 5 is showing below in the list).

Keywords

Ticket Status, Sorting, Ascending Order, Adaptation, Ascending Code, Ascending Description , KBA , LOD-CRM-SRP , Service Request Processing , Problem

Product

SAP Cloud for Customer core applications 2411