Missing data while download from ALV to Excel

[Former Member]

Hi Experts,

After a report is generated to ALV list, I'm trying to download the report into an Excel file.

Let's say there are 50 records, but in the Excel file only have 6 records, and the last record only have 1st 3 fields out of 14 containing the data and the rest is empty.

I'm using MS Excel 2010, and my system is 4.6C. Not sure what has really gone wrong.

Is there any solutions? Much appreciated for any suggestion and comments

Thanks.

[Former Member]

Hi Experts,

After a report is generated to ALV list, I'm trying to download the report into an Excel file.

Let's say there are 50 records, but in the Excel file only have 6 records, and the last record only have 1st 3 fields out of 14 containing the data and the rest is empty.

I'm using MS Excel 2010, and my system is 4.6C. Not sure what has really gone wrong.

Is there any solutions? Much appreciated for any suggestion and comments

Thanks.

[mithun_shetty4]

Check out SAP Notes if u have this problem with other standard report as well.

Note 372139 - Excel Download in ALV lists in Release 4.6C

Note 855314 - Downloading a list from the ALV to Excel

[DavidLY]

Hello,

Please upgrade the SAPGUI to latest patch level for a affected PC and see if it helps.

Regards,

David

[former_member513833]

I have 106 columns in my ALV report but when I download in excel file format that time data is not coming in proper format. some columns are coming into next line. Any solution for that?

[former_member222709]

Hi,

You'll need to verify your excel data for special characters. These special characters cause inconsistencies in the downloaded data.

Regards,

Pranav.