Skip to Content

Variable selection defaults?

Hi experts,

I am trying to set the defaults displayed for values on a variable in a Bex report.

In Query designer, for the variable on the characteristic I went to the 'User Settings' button and under the 'Value restrictions' tab, 'No of displayed values' section tried both 'All Values' and later with '3500' in the 'Maximum number of values displayed'. In both cases, the Query still shows the default Maximum Records '1000' when we try to enter a value from the selection screen.

In addition to changing the default 'max # of records' displayed, I would also like to change the default sort order to be descending, but I don't see any place to do this?

Thanks!

Darryl

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 02:22 PM

    default is 1000 set up by SAP.. for asceding order or decending order, its in the query ut self you can choose variable order from right properties.. if you are using f4 .u can set it up in the infoobject to use cube or master data and try at infoobject level.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Amer,

      thanks again for your time. For the max # of values displayed, that is what I mentioned trying in my original question. In our system, the setting doesn't appear to have any effect as the number of values always stays at 1000.

      I opened a ticket with SAP for this issue as well as the sort order - will see what they recommend.

      Thanks,

      Darryl

      -


      Update: info from SAP Support:

      A final update: SAP Support confirmed the 1000 value default setting cannot be modified. The users can increase the limit and resubmit the search request to get more values if required.

      - Darryl

      Edited by: Darryl Goveas on Dec 2, 2011 9:38 AM

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2011 at 06:50 AM

    Hi,

    Selector will show maximum of 1000. If there is more than 1000 values, then you have to go for search.

    Thanks,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 19, 2014 at 04:17 AM

    Hi Darryl,

    Any update on the sort order issue?

    - Ajina

    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.