topic Re: Converting number in Application Development and Automation Discussions

Converting number

Former Member — Thu, 08 Apr 2010 09:31:06 GMT

Dear All,

I have to change number i.e 34567897 to 3,45,67,897 (, seperated), please help me is there any standard f.M or any way to do it.

Thanks in advance,

RRK.

Re: Converting number

franois_henrotte — Thu, 08 Apr 2010 09:42:07 GMT

WRITE w_value USING EDIT MASK  '_,__,__,___'.

Re: Converting number

Former Member — Thu, 08 Apr 2010 09:49:20 GMT

Use function module "WOSI_CONVERT_STRING_TO_NUM"

Pass values as follows

P_ACTION : 2J

P_STRING_100 : Input Value

Output value "P_SWERT" will have the value in the format required by you.

Regards

Vinod

Re: Converting number

arunprakash_karuppanan — Thu, 08 Apr 2010 10:03:12 GMT

Hi,

For fun, you can try doing it the hard way.


Data: lt_string type stringtab,
         lv_temp type string,
         lv_int type int4,
        lv_itemp type i.

*assume initial value to be converted is in lv_int.
if lv_int ge 1000.
 lv_1000 = 'X'.
endif.

while lv_int is not initial.
if lv_1000 = 'X'.
 lv_itemp = lv_int mod 1000.
 if lv_itemp is initial.
  lv_temp = '000'.
else.
lv_temp = lv_itemp.
endif.
insert lv_temp into lt_string index 1.
lv_int = lv_int div 1000.
clear lv_1000.
endif.

if lv_int ge 100.

 lv_itemp = lv_int mod 100.
 if lv_itemp is initial.
  lv_temp = '00'.
else.
lv_temp = lv_itemp.
endif.
insert lv_temp into lt_string index 1.
lv_int = lv_int div 100.
endif.

else.

lv_temp = lv_int.
insert lv_temp into lt_string index 1.
lv_int = 0. "or use exit to break loop
endif.

endwhile.

concatelate lines of lt_string into lv_string separated by ','.

*final result.

Regards,

Arun Prakash

Re: Converting number

Former Member — Thu, 08 Apr 2010 10:09:34 GMT

Is it a currency field? If yes, you can use FM HRCM_AMOUNT_TO_STRING_CONVERT.

Otherwise use the statement

WRITE WF_PRICE TO WF_PRICE_STR decimals 0 .

The target field should be of character type.

Re: Converting number

Former Member — Thu, 08 Apr 2010 10:39:05 GMT

Hi Satyajit,

It is a amount but type is char, now i have to display this amount with , or .

37,23,345 instead of 3723345

Re: Converting number

Former Member — Thu, 08 Apr 2010 10:39:27 GMT

hi,

write it like this.


DATA : len type i,
           num type i.  " your number 

len = strlen( num ).
num1 = num.
case len.

when 4.
num = '_,___'.
when 5.
num = '__,___'.
when 6.
num = '_,__,___'.
when 7.
num = '__,__,___'.
endcase.
write: num1 right-justified using edit mase num.

thanks and regards,

tanmaya

Re: Converting number

Former Member — Thu, 08 Apr 2010 10:40:59 GMT

Have you tried the function module "WOSI_CONVERT_STRING_TO_NUM"

Regards

Vinod

Re: Converting number

Former Member — Thu, 08 Apr 2010 10:52:06 GMT

Yes, i tried its not working when i am using it in my code.

Re: Converting number

Former Member — Thu, 08 Apr 2010 11:07:13 GMT

Try this one,and pass currency also.

FITP_RFC_TRANSLATE_AMOUNT

Re: Converting number

Former Member — Thu, 08 Apr 2010 11:27:17 GMT

Hi Dharma,

This is not working.

Re: Converting number

Former Member — Thu, 08 Apr 2010 11:32:22 GMT

Try this

ISM_CONVERT_CHAR_TO_DEC

which version you are using?

Re: Converting number

Former Member — Thu, 08 Apr 2010 12:38:35 GMT

Iam using SAP ECC 6.0

I tried with this ISM_CONVERT_CHAR_TO_DEC

still half problem solved. i.e if i pass 3456789123 iam getting like this 34567.89123 seperating by only one decimal.

Any clue.

Re: Converting number

Former Member — Thu, 08 Apr 2010 12:56:49 GMT

Use a write statement with addition currency key,

For Example

Write amount to amount currency 'USD' where amount is of type character..you will get it the result in the desired format

Thanks

Rajesh

Re: Converting number

Former Member — Thu, 08 Apr 2010 13:05:21 GMT

Hi Raj,

I have written like this

DATA: MSG TYPE CHAR30.

Write MSG to MSG currency 'USD'.

still problem persists, help me out if any thing wrong here.

Re: Converting number

Former Member — Thu, 08 Apr 2010 13:34:52 GMT

Hi,

Move that character value into a currency field, you will get the desired format.

DATA: m type char30 VALUE '1234',

m1 TYPE dmbtr.

WRITE m to m CURRENCY 'USD'.

m1 = m.

write m1.

Thanks!!

Rajesh

Re: Converting number

Former Member — Thu, 08 Apr 2010 13:41:15 GMT

Hello,

How about something like this?


data: var type char30 VALUE '3456789123',
      var1 type p.

var1 = var.
write: var1.

vikranth

Re: Converting number

Former Member — Thu, 08 Apr 2010 13:46:14 GMT

Hi Ravi,

Plesae refer the thread [;.

Re: Converting number

Former Member — Thu, 08 Apr 2010 15:25:09 GMT

Hello Ravimani,

I think you should look into the solution provided by both François Henrotte and gundapaneni raj.

If you know the exact way you want to format like in your case n,nn,nn,nnn then do what François adviced:

WRITE w_value USING EDIT MASK '_,__,__,___'.

If however you don't know the exact format and lets say that you want to convert a char field to currency then

gundapaneni raj suggestion. move your source field into a currency field. This will get you a desired format and then use the currency option while writing.

Cheers!

Neeraj

Re: Converting number

dibakar_balida — Thu, 08 Apr 2010 16:39:53 GMT

Hi Ravimani have u tried with François Henrotte's solution. I think it is the best solution and easy to use. You can do easily by edit mask what ever , is needed.