Skip to Content
-1

Issue with Parameters in FM 'RRW3_GET_QUERY_VIEW_DATA'

Hello all,

I am trying to retrieve the query data from the FM 'RRW3_GET_QUERY_VIEW_DATA'.

I have created 8 variables for the query for which i will provide the data at the time of query execution.

While trying to write the FM i am trying to use only one of the variable from that 8 variables.

For that purpose i am creating filling internal table 'l_t_parameter' as follows;

The parameter is designed to take single value.

L_S_PARAMETER-NAME = 'VAR_NAME_1'.
L_S_PARAMETER-VALUE = 'YSMART_GRPAUTH'."Variable Name(Technical)
APPEND l_s_parameter TO l_t_parameter.

L_S_PARAMETER-NAME = 'VAR_SIGN_1'.
L_S_PARAMETER-VALUE = 'I'.
APPEND l_s_parameter TO l_t_parameter.

L_S_PARAMETER-NAME = 'VAR_OPERATOR_1'.
L_S_PARAMETER-VALUE = 'EQ'.
APPEND l_s_parameter TO l_t_parameter.

L_S_PARAMETER-NAME = 'VAR_VALUE_LOW_EXT_1'.
L_S_PARAMETER-VALUE = 'BASIS'.
APPEND l_s_parameter TO l_t_parameter.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'   "Get Query Data
      EXPORTING
        i_infoprovider          = wf_ip
        i_query                 = wf_query
*       i_view_id               = wf_view  "Commented
        i_t_parameter           = l_t_parameter[]
      IMPORTING
        e_axis_info             = i_axis_info
        e_cell_data             = i_cell_data
        e_axis_data             = i_axis_data
        e_txt_symbols           = i_txt_symbols
      EXCEPTIONS
        no_applicable_data      = 1
        invalid_variable_values = 2
        no_authority            = 3
        abort                   = 4
        invalid_input           = 5
        invalid_view            = 6
        OTHERS                  = 7.

But when i execute the query,my query is not getting filtered.Instead it shows all records from query everytime.

I have explored all possible source of help.But i am not getting why output is not getting filtered.

Kindly help!!

Regards,

Akil Syed.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 10, 2017 at 06:47 PM

    Hi Akil,

    I believe you maybe already have done but it's better to jump in deep debugging!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2017 at 11:37 AM

    Hello Akil,

    Just try to omit the "[ ]" for the "i_t_parameter" parameter. Anyway, I have never used it (the []) when calling this FM.

    CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'   "Get Query Data
          EXPORTING
            i_infoprovider          = wf_ip
            i_query                 = wf_query
    *       i_view_id               = wf_view  "Commented
            i_t_parameter           = l_t_parameter
          IMPORTING
            e_axis_info             = i_axis_info
            e_cell_data             = i_cell_data
            e_axis_data             = i_axis_data
            e_txt_symbols           = i_txt_symbols
          EXCEPTIONS
            no_applicable_data      = 1
            invalid_variable_values = 2
            no_authority            = 3
            abort                   = 4
            invalid_input           = 5
            invalid_view            = 6
            OTHERS                  = 7.
    Add comment
    10|10000 characters needed characters exceeded

    • Frédéric - Using [] depends on how the internal table is defined. If l_t_parameter is defined with work area (old school / obsolete) you have to use [], otherwise you don't need to use though using should not hurt anything!