Skip to Content
0
Former Member
May 12, 2006 at 09:28 AM

Problem when exporting an ALV to Excel

111 Views

Hi all,

I have a report program,Initially i am declaring

an internal table with a currency field like this,

data : begin of itab,

CURR_key type DDIC-FNAME,

End of itab.

Then i am moving this table to one more internal tablw

there i am declaring the currency field as char(15).

Then to avoid decimals in the output as per the client requirement

I am using the following

WRITE it_output-gehalt_eff

TO it_output_alv-gehalt_eff decimals 0.

Now the output will be like 424.473.825 while displayed at alv.

So when i export to excel it dumps

with the following

Runtime Error CONVT_NO_NUMBER

Unable to interpret " 424.473.825 " as a number.

in program OFFICEINTEGRATIONDOCPROXYIMP.

Now i want to retain the same output but it should not Dump whether is there any possibility as such.

Best Regards,

krishnakumar