topic Re: Number Conversion Error in Application Development and Automation Discussions

Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:01:51 GMT

Hi All,

In smartforms a variable is defined as;

v_gamng(13) type c

A query put's the following value in this variable;

v_gamng = 1,000.000

When I goto do a calculation it throws a error message;

The program attempted to interpret the value "1,000.000 " as a number, but

since the value contravenes the rules for correct number formats, this was not possible.

Then I declared the following variable;

v_gamng_n like afko-gamng

This is a numeric when I went to assign;

v_gamng_n = v_gamng.

Yet it thows the same above error message.

Thanks,

Kishan

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:04:18 GMT

Kishan,

I am not sure why you have declared V_GAMNG as C. Shouldn't it be of TYPE I / P?

Regards,

Ravi

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:07:50 GMT

Hi Ravikumar,

Assume it has to be declared as V_GAMNG Type C. How could I convert this to numeric?

Thanks,

Kishan

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:11:37 GMT

What is the requirement that is forcing you to populate the values first into a Char field and then into a Packed value??

Re: Number Conversion Error

vinod_gunaware2 — Wed, 29 Mar 2006 06:12:03 GMT

if u use data type c then v_gamng = <b>'</b>1,000.000<b>'</b>.

otherwise use F,P,I with decimals.

U can use format which store in profile->own data

or OY01

regards

vinod

Re: Number Conversion Error

jayanthi_jayaraman — Wed, 29 Mar 2006 06:14:23 GMT

Hi,

Just try putting the value from query into v_gamng_n.

Use the same for calculation.

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:15:04 GMT

See if you can use this function - CONVERT_FROM_CHAR_SORT_RFW

Regards,

Ravi

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:19:43 GMT

Hi,

Try using this data element.

P05_DEC15_4

Regards,

Gayathri

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:20:45 GMT

Hi,

DATA: v_gamng(13) type c,

v_gamng_n like afko-gamng.

v_gamng = '10'.

SHIFT v_gamng LEFT DELETING LEADING space.

TRANSLATE v_gamng USING ', '.

CONDENSE v_gamng NO-GAPS.

MOVE v_gamng TO v_gamng_n.

Thanks,

Pramod

Re: Number Conversion Error

jayanthi_jayaraman — Wed, 29 Mar 2006 06:23:40 GMT

Hi,

Here is the sample code for converting the char into numeric.

data : v1(13),

v2 type afko-gamng.

v1 = '10,000.00'.

replace all occurrences of ',' in v1 with ''.

v2 = v1.

write v2.

Re: Number Conversion Error

Former Member — Wed, 29 Mar 2006 06:31:20 GMT

Points awarded accordingly.

If someone could give a example of using the FM CONVERT_FROM_CHAR_SORT_RFW. I would close the thread as solved.

Thanks,

Kishan

Re: Number Conversion Error

athavanraja — Wed, 29 Mar 2006 06:49:58 GMT

use this code.

data: amt(20) .

data: pamt(16) type p decimals 2 .

amt = '1,2345678.80' .

CALL FUNCTION 'MOVE_CHAR_TO_NUM'

EXPORTING

chr = amt

IMPORTING

NUM = pamt

EXCEPTIONS

CONVT_NO_NUMBER = 1

CONVT_OVERFLOW = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Raja

Re: Number Conversion Error

Former Member — Mon, 04 Dec 2006 15:43:40 GMT

Hi Kishnan,

"The program attempted to interpret the value "1,000.000 " as a number, but

since the value contravenes the rules for correct number formats, this was not possible. "

In my opinion the problem is that 1,000.000 is indeed no number. 1.000,000 would be a better way to use that. But you should try first to eliminate ',' and then try if '.' or ',' is recommended for correct number conversion.

If you solved that problem yet please let me know because i encountered another problem with packed numbers in smartforms.

Hope it helps,

Claus