Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem when exporting an ALV to Excel

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

Tags:
Former Member
replied

Hi,

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.

Regards

vijay

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question