topic Re: Leading sign problem in Application Development and Automation Discussions

Leading sign problem

Former Member — Fri, 01 Jun 2007 21:12:11 GMT

Hi,

The negative sign of a currency field is being displayed at the end of the value ( i.e at thr right side of the value). I want it at the left, i.e at the begining of the value.. how do i get it ???

<b>i dont want to convert it into a character type..</b>

B'coz i have to download data into Excel. So that all numeric fields should appear

with sign(left side).otherwise excel treats as char field.

regards,

leoiz

Re: Leading sign problem

Former Member — Fri, 01 Jun 2007 21:22:52 GMT

Hi,

Try using the FM CLOI_PUT_SIGN_IN_FRONT

Thanks,

Naren

Re: Leading sign problem

Clemenss — Fri, 01 Jun 2007 23:08:31 GMT

Hi leoiz,

display it as ALV grid and use the built-in ALV-Excel export.

Regards,

Clemens

Re: Leading sign problem

Former Member — Fri, 01 Jun 2007 23:13:45 GMT

I have tried to convert char and again moved to currency format,still it takes right side sign.

I think it is not possible without converting char and do not move it to currency format,try to download with charcter only.

I tried function module but no luck ...

Thanks

Seshu

Re: Leading sign problem

Clemenss — Sat, 02 Jun 2007 13:25:13 GMT

Hi leoiz,

an other way for you is the edit mask option of the WRITE command;


  data:
    lv_price                              TYPE bseg-dmbtr VALUE '123.45-',
    lv_price2                             TYPE bseg-dmbtr VALUE '123.45'.

  WRITE:
    / lv_price  USING EDIT MASK 'RRV__________.__',
    / lv_price2 USING EDIT MASK 'RRV__________.__'.

This will place the sign in front of the value.

Still I think you could use a smarter appoach exporting values to Excel: ALV excel inline grid, ALV calling external excel, OLE intergration with CALL METHOD OF EXCEL and so on.

But just for the purpose of placing the sign, the edit mask should be OK.

Regards,

Clemens

Re: Leading sign problem

abdul_hakim — Sat, 02 Jun 2007 21:00:45 GMT

use the FM CLOI_PUT_SIGN_IN_FRONT