Skip to Content
-1

Issue with Parameters in FM 'RRW3_GET_QUERY_VIEW_DATA'

Apr 06, 2017 at 11:26 AM

185

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tuncay Karaca Apr 10, 2017 at 06:47 PM
1

Hi Akil,

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

Share
10 |10000 characters needed characters left characters exceeded
Frédéric Cincet Apr 10, 2017 at 11:37 AM
0

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.
Show 1 Share
10 |10000 characters needed characters left 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!

0