on 2017 Apr 06 12:26 PM
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.
Hi Akil,
I believe you maybe already have done but it's better to jump in deep debugging!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
12 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.