Skip to Content
0
Former Member
May 29, 2007 at 07:14 PM

How to retrieve value with RRW3_GET_QUERY_VIEW_DATA FM

885 Views

Hi experts,

I have a problem to use data retrieved by Function Module RRW3_GET_QUERY_VIEW_DATA

I've developped an abap function module which calls RRW3_GET_QUERY_VIEW_DATA.

My ABAP Code is the following :

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

i_infoprovider = s_CubeName

i_query = s_QueryToExecute

  • i_t_parameter = t_VarInputParameters

IMPORTING

E_CELL_DATA = t_cell_data

E_AXIS_INFO = t_axis_info

E_AXIS_DATA = t_axis_data.

The query call is OK.

The data I need are into E_CELL_DATA and looks like this :

CELL_O VALUE FORMATTED_VALUE V CURRE UNI M N N C BACK_COL

000000 X Q 0 0 00

000001 X Q 0 0 00

000002 0.78947368400000 0,7895 Q 0 0 00

000003 0.78947368400000 0,7895 Q 0 0 00

000004 0.81818181800000 0,8182 Q 0 0 00

000005 0.81818181800000 0,8182 Q 0 0 00

The header column are :

CELL_ORDINAL

VALUE

FORMATTED_VALUE

VALUE_TYPE

CURRENCY

UNIT

MWKZ

NUM_SCALE

NUM_PREC

CELL_STATUS

BACK_COLOR

My problem is that I don't see how to use the CELL_ORDINAL column in order to determine what

are the row (time unit) and column (key figures) associated.

An other question : if I need to add a i_t_parameter into abap FM call (for RRW3_GET_QUERY_VIEW_DATA),

where can I find the variables names into the bex application ? (I don't know what value to use for my ABAP call)

Thanks for your help