Joining Queries in the Table Interface

[Former Member]

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

[Former Member]

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