How to implement RRI in one web template for a master detail reporting

[Former Member]

Hi All.

I have a web template ZSD_WT_001 in a BW 3.5 system. This web template ZSD_WT_001 as two data providers DP_1 and DP_2 and two table web items TABLE_1 and TABLE_2. TABLE_1 is based on DP_1 and TABLE_2 based on DP_2.

DP_1 is a summary query which displays a list of sales orders in TABLE_1.

DP_2 is a detailed query that displays the details of a sales order in TABLE_2.

So the web template ZSD_WT_001is a master detail report with the upper area/TABLE_1 displaying the summary list of all sales orders. When the user selects a sales order in TABLE_1 and clicks on it the TABLE_2 in the same web template I want the details of the sales order to be displayed.

Can someone kindly share how I can do this.

Thanks

Karen

[former_member182470]

Hi Karen,

You can achieve as per Durgesh's thread. But this is a complicated procedure I believe.

Instead of this, Why don't you jump from the Sales Order from Summary Report to ECC t-code which tells about the Sales Order info completely.

Regards,

Suman

[Former Member]

Hi,

You can check the below thread, may be useful to you.

[;

Regards,

Durgesh.

[former_member188080]

Hi Karen,

See if you can use ABAP report in which you can pass the value of sales order to master data report screen .

Thanks and regards