Skip to Content

Bex Query Designer: selection variable, define list of available input values in input help

SAP BW 7.0, Bex Query Designer

Hi all,

I am creating a query in Bex Query Designer with a selection variable (characteristic value) with manual input processing for the company code.

1) Now I want to configure the selection, so the user only gets a list of only 2 available company codes (for example 0300 and 0400) when he uses the input help (and not the complete list of existing codes).

2) I must also prevent that the user can manually type in some other codes than these 2 mentioned company codes in the selection field. 

How can I configure this functionality ?

Kind regards,

Guy Verschueren

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 11, 2012 at 06:16 AM

    HI,


    You can achive this using BADI to restrict F4 selection.


    Please see below link its very easy to implement, you can create one temporary internal table and hardcode these values.


    Please let me know how it helps.


    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4009b0a8-7adc-2e10-48b3-a111c8f407af?QuickLink=index&overridelayout=true


    I have done this earlier to hardcode the business partners in selection screen instead of those coming from infoproiver or master data.


    Regards,

    Deepak Chavan.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2012 at 12:20 PM

    Hi,

    In input variable list ,it will take all the company code available in infoprovider . if you want to display only two code . Create a authorization object on company code , assign desired come . code . I think data level restriction at inprovider can solve the issue.

    Regards,

    Anand Mehrotra.

    Add comment
    10|10000 characters needed characters exceeded