Skip to Content
avatar image
Former Member

extract the report into excel file

how to extract the report into excel file?

which function module i have to use ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 07:55 AM

    Hi,

    use the FM

    EXCEL_OLE_STANDARD_DAT

    REGARDS.,

    NAGARAJ

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 22, 2007 at 07:54 AM

    Hi...

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

    <b>

    Reward if Helpful...</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 08:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded