Skip to Content
avatar image
Former Member

Execute a query

Hi guys,

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

Any idea ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 22, 2007 at 03:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2007 at 10:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 24, 2007 at 11:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2007 at 01:33 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded