Generating 1 report by merging 2 reports

[Former Member]

Hi all ,

I have a issue  i have 2 tables

table 1 ( consolidated )

PROFIT	PERIODS	TRADES	RANK
223	1	1	100
333	4	2	98
449	8	3	96
123	7	2	12

PROFIT	YEAR	PERIODS	TRADES	RANK
223	2007	1	1	88
333	2008	4	2	34
449	2009	8	3	56
123	2010	7	2	23II

Table 2 ( year by year )

I need to combine these tables  then generate report

report goal is to sort the table 1 (rank) in the order of top to bottom  so that its corresponding columns gets sorted accordingly . i need to compare table 2

Eg - if rank 100 so that its (profit periods trades ) have a value table 1 so in table 2 have to  check the values (profit periods year trades) have the same rank or not

This my issue please help me out

Thank you

[Former Member]

Hi Jana,

One way to provide the information is to use the Sender receiver functionality (Transaction code: RSBBS).

The user will be able to right-click on the value of column "rank" in 1st query and then GoTo> 2nd query where all records with the specific rank value will be displayed. This will work only if the IObject used for rank is a characteristic and can be applied as a filter in the Query.

Regards,

[Anand71]

Hello,

Simple option is create a work book. In First  sheet get First query and secound sheet get  secound query. In third sheet use excel formula (Vloop) and try to get desire results by combining first and secound excel sheet which contains report.

Thanks.

With regards,

Anand Kumar

[Former Member]

Hi Janarthan,

Create a view for these two tables in source sytem, load data into BI and then go for reporting.

Check the below link for the step by step procedue.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40394d9b-93b9-2d10-9f9a-f13118a47...

Hope it helps.

Regards,

Shilpa

[former_member182470]

Hi,

Try to Create an APD by considering two Queries results and apply the logic in the ABAP Code and finally Aggregate the data.

or

Create an Infoset on top of the data providers for these two Queries. Use inner join here.

You may take an ABAPer help

Regards,

Suman

[Former Member]

Hi Suman ,

Thank you for your reply , but is it possible to do without ABAP help