Skip to Content
avatar image
Former Member

Write internal table to file GUI_DOWNLOAD or TRANSFER?

Hi, I want to transfer an internal table to a file. Which method is the best regarding performance?

GUI_DOWNLOAD or OPEN DATASET/TRANSFER/CLOSE DATASET?

I would like to dump the table to the file all at once.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Sep 01, 2008 at 12:24 PM

    Hi....

    First you decide where you would like to transfer your file...

    To presentation server?

    Or

    To Apllication server?

    Thanks,

    Naveen.I

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:59 PM

    Dear

    check for the parameters..

    call function 'GUI_DOWNLOAD'

    exporting

    filename = txtfile

    filetype = 'ASC'

    write_field_separator = 'X'

    confirm_overwrite = 'x'

    tables

    data_tab = itab

    .

    -Mahrshi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:25 PM

    Hi Rune,

    Rune wrote :

    Which method is the best regarding performance?
    GUI_DOWNLOAD or OPEN DATASET/TRANSFER/CLOSE DATASET?

    GUI_DOWNLOAD is for downloading into a flat file on presentation server whereas OPEN DATASET/TRANSFER/CLOSE DATASET is for downloading into Application server.

    Go with GUI_DOWNLOAD since you want to dump the table to the flat file all at once.

    Regards,

    Swapna.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:51 PM

    Hi,

    As you want to download the internal table data to a file. Use GUI_DOWNLOAD function module.

    I would suggest you to go through the documentation of OPEN DATASET because OPEN DATASET statement is not used for downloading internal table.

    OPEN DATASET is used to upload the internal table on Application server ( which you can see through transaction AL11) from your report program. It is also used for downloading internal table from Application server to your report program.But to download internal table into a flat file, you have to use function module GUI_DOWNLOAD.

    Regards

    Abhijeet

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 01:01 PM

    dear,

    check this too.

    open dataset fname_oh for output in text mode encoding default.

    loop at itab.

    transfer itab-line to fname_oh.

    endloop.

    -Maharshi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 01:43 PM

    Thanks, seems to be GUI_DOWNLOAD then.The file should be saved somewhere on a filesystem used for integration with other external systems as FTP..

    Add comment
    10|10000 characters needed characters exceeded