Sort variable values by text

[Former Member]

Dear all,

I would like to know, how is it possible to sort variable values by text in selection screen of a web report.

Thank you all in advance.

-Panos

[former_member188325]

Hi,this feature is not available in bw 3.5 atleast.May be you could achive this using Table Intergace Class.But it's not that easy.

[Former Member]

Arun, as i searched about the abap solution and i could not find any way to sort the values at any step. Can you show me an example if you have managed to do it?

Ingrid, have you tried this and working to you, because i have set the infoobject sorted by text, but the variable values still do not appear sorted.

Kartikey, i can not see any of the ^ and v you suggested in my selection screen.

How do you make these 2 symols appear and do the sorting?

Thank you for your help,

Panos.

[Former Member]

Sure you can Panos.

If you change the settings on the info-object in the query or in BW to order by text your variabel will sort by text also.

Ingrid

[Former Member]

I can suggest a new thing....

While selection.... you can select the small icon in the fashion of ^ and v .

In this way you can sort the selection screen in Ascending or Descending order.

Try it , it should definitely help....

This icon should be right to the description of the screen.

[Former Member]

Thank you Arun,

for your help, it is really a good idea.

Because i am not good at all in abap, could you provide me an example how we would write the code?

-Regards

Panos

[Former Member]

Any help please?

[Former Member]

Hi Panos,

We can ABAP code in user exit.....In CMOD. There we can make use of I_STEP value as 2 (i guess this is for before display and after data retrieval from master data) and sort the values and we can display in selection screen.

Hope this will solve ur issue.

Regards

Arun Thangaraj

[Former Member]

Thanks for the answer Gilian, but my question concerns the values of the variables not the appearance of the variables. e.g for a variable material_var i would like the values be sorted by text (amat,bmat,cmat ...). My question is for the variable/filters in web reporting.

-Panos

Message was edited by:

Panos M

[Former Member]

Panos,

It can be done in the Query designer - select the Query properties and the generic tab you can sequence the variable inputs.

Regards

Gill