Skip to Content
author's profile photo Former Member
Former Member

Pronlem while downloading ALV grid to excel

Hi Experts,

My ALV report is working fine, but problem is that when i am downloading it to excel some data is missing from some coloum

like MATNR is 0000234567 in display but after downloading to excel it comes only 23456

last digit is missing in all the rows of matnr after downloading.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2009 at 03:17 PM

    When filling IT_FIELDCAT for FM: REUSE_ALV_GRID_DISPLAY, write no-zero for your column MATNR or wherever you have this issue.

    fieldcat-no_zero      = 'X'.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2009 at 07:12 AM

    - First perform [the Consistency Check|http://help.sap.com/saphelp_sm32/helpdata/EN/d6/23253963143e6ae10000000a11402f/frameset.htm] of your ALV, even if the display is fine (use shift+double click right on a free surface of the ALV)

    - Look at [ Note 1075315 - Excel download: last character missing|https://service.sap.com/sap/support/notes/1075315]

    - Look at [Note 358644 - ALV Export Excel: Recommendations and known errors|https://service.sap.com/sap/support/notes/358644]

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 12:22 PM

    Hi,

    I have faced the similar problem and able to resolve in below manner,

    Declare a new variable of data type Char 10, and assign the value whose last digit is missing to the new variable and then append the new value to the internal table and call the ALV GRID.

    Now try downloading the output to Excel, this will definatly solve your problem

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 12:23 PM

    Hi,

    I have faced the similar problem and able to resolve in below manner,

    Declare a new variable of data type Char 10, and assign the value whose last digit is missing to the new variable and then append the new value to the internal table and call the ALV GRID.

    Now try downloading the output to Excel, this will definatly solve your problem

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 12:23 PM

    Hi,

    I have faced the similar problem and able to resolve in below manner,

    Declare a new variable of data type Char 10, and assign the value whose last digit is missing to the new variable and then append the new value to the internal table and call the ALV GRID.

    Now try downloading the output to Excel, this will definatly solve your problem

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.