topic Re: Retriving Data from Function module in update task in Application Development and Automation Discussions

Retriving Data from Function module in update task

Former Member — Tue, 10 Apr 2012 08:26:17 GMT

Hi Everyone,

My requirement is like in a report in one perform i want to select huge data (Millions of records) and then display at the end.

so i thought to do these select by using Function Module In Update Task so that it ll increase my performance.

So i created a function module of Processing type "Update module" (start immediate ) and start fetching required data from database tables.

Now i want this data (In my internal Table) back to report .

But as this is FM in Update task it will not allow for export parameters , also tables parameter will work like importing parameter.

So I tried using EXPORT/IMPORT to MEMORY ID but this is also not working .

So can you please suggest me how i can get my data in internal table back to report .

Thanks in Advance .

Re: Retriving Data from Function module in update task

kesavadas_thekkillath — Tue, 10 Apr 2012 08:29:21 GMT

How does selecting data in an update function improve performance.

I think so you were referring something to parallel processing using function modules. If so, please search for it & you will find some good blogs & discussions.

Re: Retriving Data from Function module in update task

Private_Member_49934 — Tue, 10 Apr 2012 08:32:10 GMT

You are calling the FM in Update Task? and expecting it will improve the performance in a report? 😮

Please check SAP help get clarity regarding the update FM.

Re: Retriving Data from Function module in update task

Former Member — Tue, 10 Apr 2012 08:40:40 GMT

Thanks Kesavadas ,

Yes i m looking for parallel processing itself. i thought doing it in update task will help as update module will create its own LUW .

Can you suggest how to retrieve data from function module in update task .. ?

Re: Retriving Data from Function module in update task

Former Member — Tue, 10 Apr 2012 08:42:59 GMT

Thnaks Gaurav

Actully i m looking for parallel processing . I thought doing it in update task will help as update module will create its own LUW .

Can you suggest how to retrieve data from function module in update task .. ?

Re: Retriving Data from Function module in update task

kesavadas_thekkillath — Tue, 10 Apr 2012 08:45:22 GMT

For "Selecting" data parallel processing is not going to help you. Forget about update task( Its some thing different & not going to help you in this case ). You have millions of records to be selected, so you should focus on background processing, selection using cursor's , selection using right indexes etc etc. Search & you will get it. FYI - There is a specific discussion forum for performance & tuning ( close this & post it there ).