Skip to Content
avatar image
Former Member

Download table to a file in background

Hello experts,

I am not an ABAPer, just a lonely business analyst. I am trying to download the entire contents of a large SAP table to a text file using standard SAP. If I try doing that by using standard tcode SE12, I get a dump, because SAP GUI is trying to display too much data.

Is there a way to submit for a contents of a table to be downloaded in the background ? For example, I can go to SE12, provide selection criteria, specify which fields I would like to see, and GUI will display it. From that point on, I can save the output to a text file, XXL spreadsheet, whatever. How can I skip the display piece and submit for this file to be created in the background?

Thank you all in advance.

Sasa

Edited by: Sasa Mitrovic on Jun 23, 2009 4:34 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 25, 2009 at 06:33 PM

    Try this Option

    Execute SE16 and select the table, and select the field you want to download. and execute ( F8 )

    Ensure the output format should be ALV grid Display ( Menu bar )

    from the output you can download directly by clicking Excel icon it will download all the data's

    or

    Execute SE16N and select Table ex.EQUI and select the field you want to view. and execute it will display in ALV grid display format from the application tool bar Select Download and select Microsoft excel it will download all the file.

    Please correct me if i am wrong "Back ground process should not affect the memory overflow "..??

    Hope it helps

    Thanks

    S.N

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2009 at 01:18 PM

    Hi,

    There is way to do that in SE16 itself. .

    After the entering the selection criteria in the SE16 for the table data you want to fetch, go to program menu-> select Exec in background or press F9.

    It will show 'Background Print' Window, in the spool option, uncheck the print immediately & delete after output options and continue. Save the Job as immediate.

    Now execute the SM37, you can find the backgound job which you created. Once the job is completed, check the spool list and save it as local file using system menu-> list -> save -> local file options.

    Hope this will help you!!

    Thanks,

    Muthu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2009 at 03:20 AM

    Hello,

    Dont think that is possible without any code written for that. Morever, you cannot download to presentation server in background mode Correct me if i am wrong.

    What best you can do is filter on some of the fields and download it.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2009 at 09:47 AM

    HI,

    IF U WANT TO TO STORE THE DATA FROM TABLE TO TEXT FILE IN BACK GORUND THEN U HAVE O WRITE A CODE FOR THAT .

    U ASK UR ABAPER TO RIGHT THE SIMPLE QUIRY FOR FRETCHING THE DATA FROM THE TABLE

    IN TO ONE INTERNAL TABLE AND DOWNLOAD THAT IN.TABLE ON THE PRESENTATION SERVER .

    IF U WANT TO STORE THE FILE ON PRESENTATION SERVER THEN U HAVE TO USE '

    ''OPEN DATASET' FOR OUTPUT " STATEMENT .

    TRY THIS.... IT WIL WORK...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2009 at 12:34 PM

    Sounds good - thank you both.

    Sasa

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2009 at 07:07 PM

    .

    Add comment
    10|10000 characters needed characters exceeded