BEX Cascading Variable

[Former Member]

Good Morning,

I have a BEx query with 2 variables.  Fiscal Year, Budget Version.   The request is for Budget Version selections to only display values for the year previously entered in Fiscal Year.  I am not seeing anything recent on this topic except that BEx does not support this feature...but that was in an older post.

Any suggestions?

Thanks for your help!

Roseanne

[former_member231709 · Accepted solution]

Maybe BADI RSR_VARIABLE_F4_RESTRICT helps you:

https://wiki.scn.sap.com/wiki/display/BI/F4+BADI

http://scn.sap.com/people/andrey.uryukin/blog/2011/12/12/bex-query--control-the-values-which-are-sho...

For cascading try to implement method IF_RSR_VARIABLE_F4_RESTRICT~GET_RESTRICTION_FLAT. Example for GET_RESTRICTION_FLAT:

DATA: l_s_rng LIKE LINE OF c_t_range,

      l_s_varrng LIKE LINE OF i_t_var_range.

IF i_vnam = '[Budget Version var]'.

  READ TABLE i_t_var_range  WITH KEY vnam = '[Fiscal Year var]' INTO l_s_varrng.

  IF sy-subrc = 0.

      " process l_s_varrng like:

      IF l_s_varrng-low = '2016'.

        l_s_rng-low    = 'VER16'

        l_s_rng-iobjnm = i_iobjnm.

        l_s_rng-sign   = 'I'.

        l_s_rng-option = 'EQ'.

        APPEND l_s_rng TO c_t_range.

      ENDIF.

  ENDIF.

ENDIF.

[Former Member · Accepted solution]

Thanks Eugeniy!  I will give this a try.