Skip to Content
avatar image
Former Member

Values in Input Parameter screen is not clearing in Query Monitor RSRT SAP BW

Hi,

Good day!

I am having an issue in RSRT and I need your expertise on this guys.

Example, i will access RSRT and view the query in HTML having this variable_screen=X. Then i will be directed to the input variables.

Sample variables:

Project ID

Project Title

Project Status

Initially all the fields don't have any values, then i will place PROJECT 1 in Project ID and execute. The report output will be showing the details of PROJECT 1.

When i return to the Query monitor screen and execute the query once again, the value for Project ID field was not cleared or deleted, it is still PROJECT 1.

Requirement is that, PROJECT 1 should be cleared whenever we are back to the Query Monitor Screen and execute again. This requirement goes with other fields.

Is this an issue in CMOD or we just need to change something in configurations?

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 19, 2017 at 08:10 AM

    Hello;

    I think that in CMOD you need to clean the variable values in I_STEP = 1.

    Hope it helps;

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ricardo,

      Thank you for responding! :)

      I have added this code in CMOD
      CASE I_STEP.
      WHEN 1.
      CLEAR: E_T_RANGE[], I_T_VAR_RANGE[].
      ENDCASE.

      But I_T_VAR_RANGE is empty in step 1.
      Do i miss something? How can get the variables in step 1?
      Sorry i am new in CMOD and i only know a little on how this functions.

  • avatar image
    Former Member
    Apr 19, 2017 at 09:04 AM

    Hi;

    Try this:

    CASE I_STEP.
    WHEN 1.
    CLEAR: E_T_RANGE[], I_T_VAR_RANGE[].

    READ TABLE i_t_var_range

    WITH KEY vnam = 'YOUR VARIABLE'

    *sign = 'I'

    *opt= 'EQ'

    INTO loc_var_range.

    IF sy-subrc = 0.

    IF loc_var_range IS NOT INITIAL.

    *.Clear Previous Entry

    REFRESH e_t_range.

    ENDIF.

    ENDIF.
    ENDCASE.

    Let me know if it works...

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      it is giving a warning message and the Project ID input field is having '#'.

      And when i place another filter example project status = completed, same issue is occurring. the value is not erased

      5.jpg (22.8 kB)
      6.jpg (12.0 kB)
  • avatar image
    Former Member
    Apr 19, 2017 at 11:39 AM

    Hi;

    Are you able to debug to see if it's in CMOD that the # is populated?

    Also, please try this

    CASE I_STEP.
    WHEN 1.
    CLEAR: l_s_range.

    IF i-vnam = 'YOUR VARIABLE'

    *.Clear Previous Entry

    REFRESH e_t_range.

    ENDIF.
    ENDCASE.

    Hope it helps;

    Add comment
    10|10000 characters needed characters exceeded