Skip to Content
avatar image
Former Member

Joining Queries in the Table Interface

Hi there

I have been tasked with determining how to join 2 queries into a single result, probably using the Table Interface Class to achieve this.

Apparantley this is possible, but I have yet to find any documentation on this and would appreciate any feedback.

It appears as though the requirement is to have 2 queries displayed in a single table (through the WAD). The first query would display normally in the table web item, and the table interface would hopefully be able to take the 2nd query and join it onto the table.

This is not just adding rows onto the table, but rather adding columns. 1 column from the first query would be used as a key to lookup the corresponding result in the second query, and populate the data accordingly.

Anybody seen something like this.

Any reference material?

Cheers,

Andrew

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 23, 2006 at 09:46 AM

    Hi,

    Use following coding in the table interface to read the Data of your second query:

    select single * from rsrrepdir into wa_repdir

    where compid = 'YOUR_SECOND_QUERY' and

    objvers = 'A'.

    create object r_request

    exporting I_GENUNIID = wa_repdir-genuniid.

    r_dataset = cl_rsr_data_set=>get( i_r_request = r_request ).

    r_dataset->refresh( i_version = 1 ).

    debug it and browse through the attributes of r_dataset.

    You'll find the output of the query there.

    Kind Regards,

    Alican Polat

    Add comment
    10|10000 characters needed characters exceeded