Skip to Content
author's profile photo Former Member
Former Member

Sort variable values by text

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 02:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 04:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 08:14 AM

    Any help please?

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 07:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 10:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 08:45 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 09:00 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.