Problem when exporting an ALV to Excel
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
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.
if it should not dump then it_output_alv-gehalt_eff this should be of type C. is it type char.
and can you show the fieldcat of the field <b>gehalt_eff</b>, that might causing the problem. though you changed the type.