Function Module: RRW3_GET_QUERY_VIEW_DATA with parameters

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Lakshmipathi]

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

G. Lakshmipathi

[Former Member]

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

Regards,

Dhruv Kashyap