Download transparent table data in excel

[Former Member]

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

[former_member555112]

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

[Former Member]

Hi Ankur,

Thanks for the reply.

I agree that there is ALV grid option. But that would result in point (2) I mentioned above. Evnthough, all columns are displayed, the rows gets splitted in excel. Also, last few columns does not get downloaded.

Thanks,

Prasad

[former_member183990]

it is because the excel has hold max of 99 colums i guess

if possible can u countercheck it once again

with regards

s.janagar

[former_member555112]

Hi,

i tried with 190 field in VBRP table with the grid option and with the Spreadsheet button (CntrShiftF7).

My data was downloaded correctly with all coumns. There was no splitting.

Regards,

Ankur Parab

[Former Member]

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

[former_member183990]

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

[Former Member]

Use WS_DOWNLOAD FM for this.

Regds,

Anil

[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