Problem when exporting an ALV to Excel

[Former Member]

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

[former_member188685]

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

[Former Member]

hi vijay,

When i am using the formating option

i am keeping the target field(it_output_alv-gehalt_eff ) as type char only, Field catalog we are passing just the text heading for the field there.

Regards,

krishna

[sbhutani1]

Hi krishan,

take a variable type i then assign this decimal value to integer variable it will eleminate all the decimal places

Regards

Sumit Bhutani

Ps reward pts if helpful

[Former Member]

chk out this

sapdevelopment.co.uk