Show variable selection in descending order.

[former_member494935]

Hi Experts,

As per a requirement, i need to apply variable on calyear/month. When i am executing query and selecting variable, list is coming in default format like oldest first to newest. But i need in reverse order.

Example:

Currently it is displaying as

Jan 2014

Feb 2014

.

.

.

.

Nov 2015

But i want to display as

Nov 2015

Oct 2015

Sept 2015

.

.

.

.

Regards,

Sumadhur

[karthik_vasudevan · Accepted solution]

Hi Sumadhar

I can't think of any setting in query designer with which you could achieve this. But you could get this done once you get the input help screen as below.

Once you click on F4 or input help from the variable screen, you will get the below screen.

Click on the header line highlighted which is to sort it ascending or descending. Then you will get what you need.

Hope this helps

Regards

Karthik

[Former Member]

Hi Sumadhur,

Sorting values in report output only possible with query designer options, not variable screen entries. It is the standard functionality.

You have 1 typical chance with ABAP coding. Take abap person help and explain him on your variable coding and requirement on F4 help. It may reduce the performance.

Regards - Kumar

[former_member220624]

Hi,

Let me know you have issue with Web? If yes please check the below solution:

After execute a query ->f4 help on variable -> shows selection screen

here you can't able to sort the values based on Ascending/Descending.

Currently this functionality is not available.

Workaround:

===========

But after executing the query -> select "infoobjct" -> right click

"filter" -> select filter value -> here you can the setting icon here

you can change the value as "Ascending/descending".

Thanks,

Amit