topic Re: Curreny issue in Application Development and Automation Discussions

Curreny issue

Former Member — Thu, 16 Aug 2007 09:00:02 GMT

hi Frnds,

I facing some problem in converting the currency .

The amount value is populated in a character object of length 15

for eg amt = 4,233.89

after uploading the value becomes 4.233.89

hence once while moving this value to a packed value with decimal 2 points , i am facing a dump since ther are decimal points at 2 places.

please help me in solving the issue.

regards,

Khushboo

Re: Curreny issue

varma_narayana — Thu, 16 Aug 2007 09:02:15 GMT

Hi..

You can try this command to Move ur Char field to Pack field.

PACK <CHARFIELD> TO <PACK FIELD>.

<b>Reward if Helpful</b>

Re: Curreny issue

gopi_narendra — Thu, 16 Aug 2007 09:03:52 GMT

You can use this code to change the decimals

This does not involve changing the user settings. This is dynamic and will not effect the user settings.

Hope this works, try it

  select single * from USR01 where BNAME = SY-UNAME.

  case USR01-DCPFM.
    when 'X'.
      translate L_AMT1 using ',.'.
      translate L_AMT2 using ',.'.
    when ' ' .
      translate L_AMT1 using '.,'.
      translate L_AMT2 using '.,'.
    when others.

  endcase.

Regards

Gopi

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:10:50 GMT

Hi Tyagi,

Once Go for Menubar settings~~> user profile-> own data~~> Defaults.

check there for ur Decimal notation Might be here is the problem.

Try it once.

same problem i have faced but at tat time i do changes in type declaration i didnt remember exactly it might be(i,c)

Thanks

Naveen khan

Message was edited by:

Pattan Naveen

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:13:12 GMT

thanks for the reply but issue is that there are 2 points of decimal which are not correct . how to overcome this problem . 4,236.89 is converted to 4.236.89 which is a problem.

<b>reward will be given to the best answer</b>

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:14:52 GMT

i need to do somethng genral cannnot change user's own data settings

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:15:43 GMT

how u are uploading data into SAP ?

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:22:19 GMT

read dataset thats from application server

Re: Curreny issue

Former Member — Thu, 16 Aug 2007 09:42:06 GMT

Hi,

Try using the REPLACE command.

Regards,

Yogesh