Bex query variable value restriction

[Former Member]

Hello,

Using RSR_VARIABLE_F4_RESTRICT_BADI, Implementing Class - IF_RSR_VARIABLE_F4_RESTRICT~GET_RESTRICTION_FLAT, I added the below code for 0Material variable 'BLMTNO_01' (Mutliple single values,variable ready for input ticked) to restrict the values to the range from 1800000000 - 1800009999. In the Filter Values I have mentioned 0material as the iobjnm. When activated didnt get any error.

   IF i_vnam EQ 'BLMTNO_01'.
    READ TABLE i_t_compid WITH TABLE KEY table_line = 'BILLDATA_Q0001' TRANSPORTING NO FIELDS.
    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    = '1800000000'. " in internal format 1800000000 - 1800009999
      l_s_range-high   = '1800009999'.
      APPEND l_s_range TO c_t_range.
    ENDIF.
  ENDIF.

When I run the query 'BILLDATA_Q0001' which is on an infoset and open the 'BLMTNO_01' for input help values it still shows all values from Master data and not the ones restricted in the above BADI.

Please kindly help me to know what is the issue here.

Thank you

Anima

[anilkumar_kalkivai · Accepted solution]

Hi,

Please refer below links,

http://scn.sap.com/thread/1528692

http://www.stechno.net/sap-notes.html?view=sapnote&id=1416952

Regards,

Anil.

[Former Member · Accepted solution]

Hi Anil,

I saw that note before.

My BW system is SAP EHP 1 for SAP NetWeaver 7.0 (SAPKW70110).

Does it only work in Enhacement Pack 2 (7.02)?

Thanks & Kind Regards

Anima