extract the report into excel file

[Former Member]

how to extract the report into excel file?

which function module i have to use ?

[varma_narayana]

Hi...

You can call the FM LIST_DOWNLOAD for This....

<b>

Reward if Helpful...</b>

[former_member404244]

Hi,

use the FM

EXCEL_OLE_STANDARD_DAT

REGARDS.,

NAGARAJ

[Former Member]

Hi Pavan,

If you want to download the displayed list in the Excel file,then at the time when the list is displayed on the screen, you can go to System option on the menu bar,from there go to List and then Save.You will get a pop up which shows you all the formats of download available.Select the one you want to and mention the target path of the file on the Presentation server.

Secondly,you can use the T-codes "CG3Y" to download the data from the Application Server to the Presentation Server and T-code "CG3Z" for vice-versa.

Or else you can use any of the FMs to first download the ABAP list to the ASCII or the BIN format and then convert it to excel using the FM "SAP_CONVERT_TO_XLS_FORMAT" or "TEXT_CONVERT_XLS_TO_SAP

".

I hope I have tried to answer your query.

In case of any further queries,please let know.

Regards,

Puneet Jhari.