One digit is missing while downloading to excel

[Former Member]

Hi Experts,

I am executing a report and the result is in ALV format. When i was trying to download the result into an excel sheet I am missing one digit (last digit) from material number. What could be the reason...Please help me in this regards

Thanks in advance

Regards

G.S.Naidu

[Former Member]

Hi,

Format the cells of xcel sheet. You can see the last digit also.

Open the excel .... Press Ctr+A(select all the rows & columns)-> Right clcik & select format cells-

Under Number Tab -- select the TEXT.

Now see you can see the last digit also.

Regards,

Pravin

[Former Member]

Hi Pravin,

Thanks for the reply.

My problem is in Language EN log in into SAP, downloading is fine.

But while loging into SAP ZH(chinies) Language I am getting problem.

With your solution I didnt get the complete number.

Thanks & Regards

G.S.Naidu

[GauthamV]

Use reference table name and reference field name in fieldcatelog for that field and check.

[kesavadas_thekkillath]

This question has been discussed many times,

and the solution proposed were like increasing the length (output_len)...for ex : give it as 20.

Use conversion exit for materials to remove the leading zeros.

Then try downloading it.

[Former Member]

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 then call the ALV GRID.

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

[Former Member]

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]

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]

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