- [Instructor] Sometimes, we need to mold our report results
to make our data more useful.
The sort function is a helpful way
to order our numerical or date fields.
We can sort to see data in order
from oldest, newest, biggest or smallest.
Let's sort a report in our system.
First, we need some data.
We'll go into our list of sales orders report
using transaction code VA05.
We'll now execute this report
without adding any selection criteria.
In our first sorting scenario,
let's say we want to see their sales order
with the largest net value by item.
To sort this column, we'll click the column title.
Then we'll click the sort in descending order icon.
We now see a little red arrow pointing down,
which denotes that we've got an active sort,
and that sort is descending.
We can also see that our largest order
by net value per item is $120,000 U.S.
In our next sorting scenario,
we want to see the oldest order in our system.
To do this, we'll go to our document date column and click.
Now we'll click the sort in ascending icon.
We can now see that the oldest order in our system
is from March 4th, 2018.
The little red arrow pointing up shows
that we've got an active sort, and that sort is ascending.
Sorting can be a powerful tool to help us visualize
our SAP report results in a more useful way.