Defining data to be sorted
Before you can restructure the data, you must sort the data.
These are the input parameter properties for sorting:
Sorting Sequence
By default, this property is set to 0
, which
means no sorting. When Sorting Sequence is set to a positive integer value, the data is
sorted on that element. You can set Sorting Sequence for several input parameters for a
Restructure function.
Follow these example sorting sequence:

Sort on supplier name (Sorting Sequence = 1)

Sort on IBANID ()
Sorting Sequence = >0
must be unique
within a Restructure function.Sort Order
If Sorting Sequence is >0
, you can set
the property Sort Order to Ascending or Descending sort order.
For example, 11
is less than 2
due to the different lengths for ascending sort order.
The null value for a nonexisting input element is less than the lowest value for an existing input element. This means, null is less than an empty value and any other value for ascending sort order.
These input parameter properties decide the sorting for the data at the current loop level. The total sorting is constructed from the sorting properties for Restructure functions for all nested restructure loops. See this example:
If data for the outmost restructure loop is sorted on:

1 supplier name

2 IBAN ID
And, if data for the inner restructure loop is sorted on:

date
This becomes the total sorting:
1
supplier name
,
2
IBAN ID
, and
3
date