Skip to Content
-1

How to avoid truncating issue while data downloading to excel sheet

Jun 20, 2017 at 07:53 AM

94

avatar image

Hello Experts,

I have requirement in alv report, in report output when i am downloading to excel sheet few fields value getting truncate like vendor field value showing in sap output - 0123450 but after download to excel the value downloading to excel 12345 it should download 123450.

Anyone can help me on this.

Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mangesh Parihar Jun 20, 2017 at 09:24 AM
0

Hi,

Before downloading, move those field to the another table table2 which well have same number of fields but of type string.

And download the table2. That should work.

Regards,

Mangesh Parihar

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Jun 20, 2017 at 09:24 AM
0

Which ALV report? Standard or own developed?

Never saw that trailing zeros have been missed in a download

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Own developed report.

0

Then it might be of some help to show the coding that is used around the download

1
Daniel Pereira Jun 20, 2017 at 10:12 AM
0

Hej Ramesh,

Have you tried with ALV format 10-Excel (in Office 2007 XLSX Format).

These settings can be overwritten in SE38 with program SALV_BS_ADMIN_MAINTAIN.

Table SALV_CSQ_PARAMS display settings per User.

Hope it helps :)


Share
10 |10000 characters needed characters left characters exceeded