Skip to Content
avatar image
Former Member

Download transparent table data in excel

Hi all

I have ECC 6.0 system. I have a transparent table with 112 fields. Sufficient amount of data is present in that table. I need to download this data into an excel file. But I found there are some inconsistencies:

1. I used SE16. But we know that list output of the SE16 screen is limited to 1023 characters. Hence all the columns are not displayed. In my case it is displaying only 52 columns. Eventhough if we download this using System->List->Save->Local File->Spreadsheet, only those 52 columns are displayed in excel. So this SE16 was out of option.

2. I used SE16n. Here I could see all the 112 columns in the screen. But if I go for Export->Local File->Spreadsheet , each row gets splitted into two rows in excel. Also last few columns are not downloaded. All in all, it is an incomplete download and is not readable. Hence this method is out of option.

3. I used a manual method. In SE16n I copied all the data to the clip board using Ctrl+A and pasted them in a new excel document. The data got copied fully and properly. But the header line was missing.

What could be the solution other than writing a separate ABAP program?

Thanks,

Prasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 13, 2009 at 09:17 AM

    Hi,

    IN SE16 you display the report in a grid format in Settings-->User Parameters and from there you select download to spreadsheet button.

    It will download all the columns.

    Regards,

    Ankur Parab

    Edited by: Ankur Parab on Jul 13, 2009 2:48 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ankur Parab

      Hi Ankur!

      Thanx!It worked!But i had to do some "Save as" activity. Actually ctrlshiftf7 saves the file in "MHTML" format but opens in excel. So I did a "Save as" and saved it as excel and it worked.

      Regards,

      Prasad

  • Jul 13, 2009 at 09:21 AM

    hi prasad

    please check in SCN before asking such type of question

    the table output is similar to ALV grid or it can be ALV list display

    and in the ALV tool bar u can find option for downloading the output to excel

    use that to download it

    cheers

    s.janagar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 13, 2009 at 09:26 AM

    Use WS_DOWNLOAD FM for this.

    Regds,

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anil,

      Thanks for the reply,

      But I do want to write a progam for this. It should be done without writing any programs,

      Thanks,

      Prasad