Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 12, 2006 at 09:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 12, 2006 at 09:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2006 at 09:37 AM

    chk out this

    sapdevelopment.co.uk

    Add comment
    10|10000 characters needed characters exceeded