topic Re: Data from multiple reports into one table in Application Development and Automation Discussions

Data from multiple reports into one table

Former Member — Thu, 23 Jan 2014 03:04:44 GMT

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

Re: Data from multiple reports into one table

ramakrishnappa — Thu, 23 Jan 2014 03:36:37 GMT

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

Re: Data from multiple reports into one table

Former Member — Thu, 23 Jan 2014 03:43:29 GMT

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