Skip to Content

BW: Restricting the value help in the variables screen of a query

Restricting the value help in the variables screen of a BW query

If you have been looking for a way to restrict the list of values returned by F4 selection help on the selection screen of a BW query then there is finally a easy solution to this.

With BW 7.3 support pack 3 the BADI RSR_VARIABLE_F4_RESTRICT_BADI is finally working and can be used to restrict the value displayed on F4 help.

For the implementation please refer to the good documentation in IMG for the enhancement.

Here is a short illustration of the implementation.

Step 1- Create Enhancement implementation

Step 2- There are three options for creating the implementation class.

a-      Create empty class

b-      Copy example class

c-      Inherit from example class

For using option ‘c’ you would need to create your own example class first as the example class provided is declared as final.

Step 3- Choose a filter value for the BADI implementation.

Step 4- There are three methods in the implementation class.

Refer to the documentation for more details of the methods.

Step 5- Maintain the code of the implementation.

Example code. 

  IF i_vnam EQ ‘0D_FC_P21’.
    IF sy-subrc = 0.
      l_s_range-iobjnm = i_iobjnm.
      l_s_range-sign   = ‘I’.  “including
      l_s_range-option = ‘BT’. “between
      l_s_range-low    = ‘FC001’. ” in internal format
      l_s_range-high   = ‘FC005’.
      APPEND l_s_range TO c_t_range.
      l_s_range-iobjnm = i_iobjnm.
      l_s_range-sign   = ‘I’.  “including
      l_s_range-option = ‘CP’. “Contains pattern
      l_s_range-low    = ‘FC01*’. ” in internal format
      CLEAR l_s_range-high.
      APPEND l_s_range TO c_t_range.

Related SAP Notes

Note 1461962 – Enhancements with SAP NetWeaver BW 7.02

As per this note this functionality is available from BW 7.02 (SAP NW BW 7.0 EHP2)

Note 1416952 – F4 BAdI

As per this note this new BADI can be used from SAP NetWeaver BW 7. 01 (SAPKW70109) or SAP NetWeaver BW 7. 30 (SAPKW73003)

1 Comment
You must be Logged on to comment or reply to a post.