topic Re: Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters in Application Development and Automation Discussions

Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

Former Member — Sun, 28 Jun 2015 15:42:04 GMT

Hi Experts,

I am trying to read a Bex query in ECC system using the RFC RRW3_GET_QUERY_VIEW_DATA from BW system. I need to pass some variables to the query using the above mentioned function module. The two parameters are calendar month variable 'Z1' and currency variable 'Z2'.

Please let me now how can I pass the variable to input parameter I_T_PARAMETER.

Regards,

Dhruv Kashyap

Re: Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

Former Member — Mon, 29 Jun 2015 07:40:12 GMT

Hi Dhruv Kashyap,

Instead of using "VAR_VALUE_EXT_I" I had to use "VAR_VALUE_LOW_EXT_I" and "VAR_VALUE_HIGH_EXT_I". That's all

Regards

Susheel Aitha

Re: Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

Lakshmipathi — Mon, 29 Jun 2015 07:54:46 GMT

Moved from SAP ERP Sales and Distribution (SAP SD) to ABAP Development. Try to post in the right forum

G. Lakshmipathi

Re: Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

Former Member — Mon, 29 Jun 2015 08:46:06 GMT

Hi Susheel,

Thank you for your response. However it does not work still.

Below is the BW query:

PAGENO=1&CMD=PROCESS_VARIABLES&REQUEST_NO=0&CMD=PROCESS_VARIABLES&SUBCMD=VAR_SUBMIT&

VARID=&VAR_ID_2=ZCMNTH_YTD_END%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%200004&

VAR_VALUE_EXT_2=03%2f2014

So the variable is ZCMNTH_YTD_END and the infotype of the variable is 0CALMONTH.

I am using the below code to append the parameter.

CLEAR wa_i_parameter.

wa_i_parameter-name = 'VAR_NAME_1'.

wa_i_parameter-value = 'ZCMNTH_YTD_END'.

INSERT wa_i_parameter INTO TABLE t_i_parameter.

* CLEAR wa_i_parameter.

* wa_i_parameter-name = 'VAR_ID_1'.

* wa_i_parameter-value = 'ZCMNTH_YTD_END'.

* INSERT wa_i_parameter INTO TABLE t_i_parameter.

CLEAR wa_i_parameter.

wa_i_parameter-name = 'VAR_SIGN_1'.

wa_i_parameter-value = 'I'.

INSERT wa_i_parameter INTO TABLE t_i_parameter.

CLEAR wa_i_parameter.

wa_i_parameter-name = 'VAR_OPERATOR_1'.

wa_i_parameter-value = 'EQ'.

INSERT wa_i_parameter INTO TABLE t_i_parameter.

CLEAR wa_i_parameter.

wa_i_parameter-name = 'VAR_VALUE_LOW_EXT_1'.

wa_i_parameter-value = p_month.

INSERT wa_i_parameter INTO TABLE t_i_parameter.

CLEAR wa_i_parameter.

wa_i_parameter-name = 'VAR_VALUE_HIGH_EXT_1'.

wa_i_parameter-value = p_month.

INSERT wa_i_parameter INTO TABLE t_i_parameter.

I am wondering if the 'VAR_ID_2' has to be passed or something. Do I need to change the variable to VAR_NAME_2 or something.

P_MONTH is a parameter and not select option of type /BI0/OICALMONTH and the object name is 0CALMONTH.

Can you please help me with this?

Regards,

Dhruv Kashyap

Re: Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

Former Member — Mon, 29 Jun 2015 08:48:01 GMT

Thanks. I will make sure of it from next time.

Regards,

Dhruv Kashyap