Data from multiple reports into one table

[Former Member]

I have 3 reports which have some selection criteria and final internal table  and my requirement is to get the data for some fields of those final internal table of 3 reports into one table , it might be in program or se11 table.

Tried of DDIC table but sending data into ddic table from report resulting in incorrect data like in DDIC table primary key field must be unique.

Tried EXPORT  FINAL_INTERNAL_TABLE to memory id  to another program .

So friends please suggest me which is the best and efficient way so that easily we can fetch data.

Thanks and Regards

[ramakrishnappa]

Hi Kittu,

I think, your requirement is to run all 3 reports and get the result of all reports and modify as per your requirement in other program and Finally save into database.

You can achieve your requirement as below

Create a FINAL_REPORT program and call all programs by using SUBMIT or CALL TRANSACTION
Create a class ZCL_MY_DATA and add static attributes like GT_DATA1, GT_DATA2, GT_DATA3
In your progams you can fill the final result into global attributes
Now, you can access the data of all internal tables in your program FINAL_REPORT

         ZCL_MY_DATA=>GT_DATA1, ZCL_MY_DATA=>GT_DATA2.....

Hope this helps you.

Regards,

Rama

[Former Member]

Hi Kittu,

I suggest you can create a program. In this program, you can use submit the 3 reports and return, in those 3 report add the export final table to memory id. in the new report use import from memory id.

Maybe it is easy to implement your requirement.

Regards,

Yawa