Skip to Content
-1

How to avoid truncating issue while data downloading to excel sheet

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 20, 2017 at 09:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 09:24 AM

    Which ALV report? Standard or own developed?

    Never saw that trailing zeros have been missed in a download

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 10:12 AM

    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 :)

    Add comment
    10|10000 characters needed characters exceeded