SAP Knowledge Base Article - Public

2883503 - Sorting of Line Item ID is Not Working As Expected For Adjustment Confirmation

Symptom

For Adjustment Confirmations, when you click on Sort Ascending on field Line Item ID, the order is like 1, 10, 11...19, 2, 20...;

And it is not the order you expect, your expected order is in ascending order of number, like 1, 2, 3, 4, 5...10,11...

Environment

SAP Business ByDesign

Reproducing the Issue

  1.  Navigate to Outbound Logistics Work Center
  2.  Click on Monitoring - By Warehouse Order view.
  3.  Highlight one Warehose Order and click on button "Edit".
  4.  Click on button "Adjustment Confirmation".
  5.  Sort Ascending on field Line Item ID

You find it is sorted like 1, 10, 11...19, 2, 20...; Instead of in ascending order of number.

Cause

Field Line Item ID is a set of characters instead of number.

Thus, when you sorting Line Item ID, it is NOT following ascending order of number.

Resolution

It is the system behavior.

The order of Line Item ID is in ascending order of characters.

Keywords

 Sorting, Line Item ID, Characters , KBA , AP-SLP-LOT , Site Logistics Lot , AP-RC-UIF-RT-B , ByD HTML5 Client (not for Cloud for Customer) , Problem

Product

SAP Business ByDesign all versions