Execute a query

[Former Member]

Hi guys,

I'm trying to execute a query in BW, to get the data stored in bw table

Any idea ?

[Former Member]

Hi

data : zparam2 type RRXW3TQUERY.

data : zparam type W3QUERY.

zparam-NAME = 'VAR_NAME_1'.

zparam-VALUE = 'ZUPGDDAT'.

append zparam to zparam2.

zparam-NAME = 'VAR_VALUE_EXT_1'.

zparam-VALUE = '24/08/2007'.

append zparam to zparam2.

BREAK-POINT.

CALL FUNCTION 'RRW3_GET_QUERY_VIEW_DATA'

EXPORTING

• i_infoprovider = 'ZMC_STCK'

i_query = 'ZVALMB_PMPUPGRD'

i_t_parameter = zparam2

IMPORTING

e_axis_data = wa_axis_data

e_cell_data = wa_CELL_DATA.

it works fine Except for variable type Date

Any suggestion ?

[Former Member]

Thank you Franck for your reply

Actually, We have many programs that use class CL_RSR_query_variable, this class is not available any more since NW2004s.

We're trying to find FM, that we can use without major modification on our programs, the programs execute some BW queries and store the data in tables.

We found that the FM : RRW3_GET_QUERY_VIEW_DATA works fine, but we have troubles only in one case, that we're trying to solve, when we put in date

parameter to FM, the error Brain 629 occurs.

The FM you're suggesting actually retreives data from InfoProviders, but we're looking for FM to Execute BW Queries

thanks for your help

[Former Member]

Thank you for your reply

Actually I'm trying to use this FM : RRW3_GET_QUERY_VIEW_DATA

I have some trouble to pass date parameter

[Former Member]

Hi again,

is function module RSDRI_INFOPROV_READ what you are looking for?

(See function module documentation)

Source can be: DSO, Cube, Multiprov

For an example see Report RSDRI_INFOPROV_READ_DEMO

Best regards,

Frank

[Former Member]

Hi,

either take a DSO as "table" and then you can build reports on it or use Visual Composer and call a function module, where you make a select on the table.

Best regards,

Frank