Download SAP data into excel

[Former Member]

I am an ordinary user I run following reports/transactions on daily basis VA05, LOADSUM & O4B1 and then download in MS excel. is there a way that it can directly be downloaded into exce.i have seen and article on forum it ask to run transaction SE37 for setup but don't have the acess of that transaction. Is there any other simple way by which I can directly get data into my required excel file.

Thanks

[moazzam_ali]

Dear Siva

Please go through the original requirement again and see what you are suggesting.

Dear Sarfraz Khan

Have you discussed this with your BASIS guy. They can schedule a back ground job and an Email will be forwarded to your Email address. Search SDN for schedule back ground job and you will get a lot of content on this. You have to check whether excel format is supported or not. I am sure about PDF but I hope excel is also supported. Please check and update.

Thank$

[siva_vasireddy2]

Hi,

   Follow this procedure for eg.VA05

[sarthak_mohantysd]

Hello Sarfaraz,

Please refer the below link for the Standard Options available for Downloading SAP data related to report into excel tracker automatically...Hope this would resolve your query and ensure to close your thread once your question is answered !!

Download data in Excel sheet with the HEADER.

Thanks,

Sarthak

[Former Member]

Hi Sarthak,

Thanks for your reply but this link is not working. It gives blank page.

Regards

[Former Member]

Hi Sarfaraz Khan,

Follow this path

System->List->Local File-> spread sheet

Thanks,

Siva.

[former_member184080]

Hi,

Check if this helps you.

http://home4sap.com/Blog/2010/03/ecc5-0-alv-default-file-format-when-extracting-files-to-excel/

Regards, Sai Krishna.

[Former Member]

The option provided here is normal downloading procedure whereas I am intrested in downloading directly in Excel from SAP. Something like using ODBC