Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Pronlem while downloading ALV grid to excel

Former Member
0 Kudos

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.

8 REPLIES 8

raymond_giuseppi
Active Contributor
0 Kudos

- 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

0 Kudos

Can you please further elaborate about the steps to be taken.

0 Kudos

Nt Answered.

I have been through the Note, no help.

0 Kudos

Hi Varun,

In Excel, u wont be able to get the leading zeroes of the ALV value because by default excel cells are formated as non numeric.

Regards,

Vimal.

Former Member
0 Kudos

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'.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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