Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Pass Parameters in FM "RRW3_GET_QUERY_VIEW_DATA" for CDS "I_GLACCTBALANCECUBE"

NooruBohra
Active Participant
0 Kudos
289

Hi Gurus,

I'm trying to fetch data from CDS I_GLACCTBALANCECUBE in ABAP program.

To achieve this, I am using FM "RRW3_GET_QUERY_VIEW_DATA". This function module is working fine and providing me the data from the cube as well.

However, when I try to pass the date value to filter out the results then it throws "invalid_input" exception. I'm passing the parameter values in below Import parameter.

It seems like I can't pass parameters using this approach, Company code and other values are getting accepted by FM. Only issue is with date.

ls_parameter-name = 'VAR_NAME_2'.
ls_parameter-value = '!CDS_P_P_FROMPOSTINGDATE'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_SIGN_2'.
ls_parameter-value = 'I'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_OPERATOR_2'.
ls_parameter-value = 'EQ'.
APPEND ls_parameter TO i_t_parameter.
CLEAR:ls_parameter.
ls_parameter-name = 'VAR_VALUE_LOW_EXT_2'.
ls_parameter-value = '01.01.2023'.
APPEND ls_parameter TO i_t_parameter.
0 REPLIES 0