topic Data extraction from SAP source to Excel in Application Development and Automation Discussions

Data extraction from SAP source to Excel

Former Member — Mon, 23 Feb 2009 10:46:49 GMT

Hi Experts,

I have a requirement to extract FI and HR datas to excel file. Which is the best way to do it? Can i use ABAP Query with LDB or Quickviewer ? Is there any other solution to get it done through writing ABAP/4 source code ? Kindly provide me feasible solution ASAP ..... Thank you

Re: Data extraction from SAP source to Excel

Former Member — Mon, 23 Feb 2009 10:54:50 GMT

through ABAP Query its very easy, you can do it through ABAP code also but its time taken process

Re: Data extraction from SAP source to Excel

Former Member — Mon, 23 Feb 2009 11:06:36 GMT

hi karthikeyan ,

as one of our friend suggested it is better to use abap quick viewer...

Regards

linganna

Re: Data extraction from SAP source to Excel

Former Member — Tue, 24 Feb 2009 06:47:28 GMT

Hi Karthikeyan,

You can use 'GUI_DOWNLOAD' standard function module for this provided you have all the required data fetched in an internal table.

Re: Data extraction from SAP source to Excel

Former Member — Fri, 27 Feb 2009 20:01:21 GMT

Hi,

You can use SAP Query(SQ01), there you can directly maintain the local server file path where you want to download the output. The query in background itself generates a dynamic program.

In case this takes much time to execute, you can create a standard report to generate the output to a local file, as you can implement SORT and all to enhance performance.

Thanks,

Ipsita

Re: Data extraction from SAP source to Excel

Former Member — Mon, 02 Mar 2009 05:53:52 GMT

Hi,

Check below link.....

Re: Data extraction from SAP source to Excel

Former Member — Mon, 02 Mar 2009 06:15:43 GMT

If you want to download ALL the data, do not forget the lines limit of Excel is 65535.

Re: Data extraction from SAP source to Excel

Former Member — Wed, 04 Mar 2009 03:50:51 GMT

Hi all,

Thanks everyone for valuable replies. I was given access to Production server only, where i had lots of limitation to create custom reports to extract large sets of datas. I managed to do with Quickviewer anyway. Thanks once again everyone for your suggestions.