on 2019 Apr 24 1:08 PM
Hello Experts,
I have read a lot of threads regarding passing parameters to FM RRW3_GET_QUERY_VIEW_DATA to fetch query data but I am unsuccessful in every attempt. I am using the same procedure:
data : lt_para type RRXW3TQUERY.
data : ls_para type W3QUERY.
clear ls_para.
ls_para-name = 'VAR_NAME_1'.
ls_para-value = '0I_FPER'.
APPEND ls_para TO lt_para.
ls_para-name = 'VAR_OPERATOR_1'.
ls_para-value = 'BT'.
APPEND ls_para TO lt_para.
ls_para-name = 'VAR_VALUE_LOW_EXT_1'.
ls_para-value = '001.2002'.
APPEND ls_para TO lt_para.
ls_para-name = 'VAR_VALUE_HIGH_EXT_1'.
ls_para-value = '001.2009'.
APPEND ls_para TO lt_para.
ls_para-name = 'var_sign_1'.
ls_para-value = 'I'.
APPEND ls_para TO lt_para.
CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'
EXPORTING
*i_infoprovider = ''
i_query = 'RP_FI008_01'
i_t_parameter = lt_para.
I am using the variable name which is mentioned in the Query Designer.
Every time I get the exception "Invalid Input = 5".
It would be great if anybody could help me with this.
Thanks in advance.
Request clarification before answering.
'var_sign_1' must be in upper case:
ls_para-name = 'VAR_SIGN_1'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What I would test:
1. Try the internal format for the parameter valuer ls_para-value = '2009001'.
2. See if it works without any parameter (try to identify which input parameter is invalid : infoPro, query or parameters)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you fill the parameter I_INFOPROVIDER ? It is mandatory to identify a query. It seems commented in your code.
Regards,
Frederic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
i hope following blog page helps:
https://wiki.scn.sap.com/wiki/display/BI/Function+module+RRW3_GET_QUERY_VIEW_DATA
Regards,
Ender
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
45 | |
9 | |
9 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.