Data extraction from SAP source to Excel

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi karthikeyan ,

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

Regards

linganna

[Former Member]

Hi Karthikeyan,

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

[Former Member]

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

[Former Member]

Hi,

Check below link.....

[Former Member]

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

[Former Member]

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.