topic Re: check if numeric value in Application Development and Automation Discussions

check if numeric value

Former Member — Thu, 17 Aug 2006 13:52:57 GMT

Hello,

please tell me a possibility how i can check if the value of a variable is numeric.

Thank you!

Ronny

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 13:56:20 GMT

Hi,

make a constant

c_numeric type string value ' .,0123456789'.

if value cn c_numeric.

not numeric

else.

numeric

endif.

grtz

Koen

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 13:57:46 GMT

Hello,

Use the FM NUMERIC_CHECK.

Reward if helps.

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 13:58:11 GMT

try this

if var CO '0123456789'.
  *var is numeric.
else.
 *non numeric.
endif.

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 13:58:40 GMT

Hi ronald,

1. This is one way

2. we can use CO (contains only relational operator)

3. just copy paste

NOTE :

'0123456789. ' (There is a SPACE after .DOT)

report abc.

PARAMETERS : A(15) TYPE C.

WRITE 😕 'NUMBER'.

ELSE.

WRITE 😕 'NOT A Number'.

ENDIF.

regards,

amit m.

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 13:59:22 GMT

data : v_char(10) type c value '0123456789'.

if v_number CO v_char.

its a number

else.

its not a number

endif.

Re: check if numeric value

RichHeilman — Thu, 17 Aug 2006 13:59:59 GMT

Yep, try this.




report zrich_0001.

data: str type string.

str = '15263459846'.

if str co '1234567890'.
  write:/ 'This is numeric'.
else.
  write:/ 'This is not numeric'.
endif.

Regards,

Rich Heilman

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 14:00:01 GMT

thank you guys!

Re: check if numeric value

Former Member — Thu, 17 Aug 2006 14:00:16 GMT

IF lnum CO '0123456789'

numeric.

endif.

Re: check if numeric value

Laxmana_Appana_ — Thu, 17 Aug 2006 14:01:40 GMT

Hi,

check this :

IF x_data <b>CN</b> '12345 67890'.
   write : ' Not a number'.
ELSE.
   write : 'Number'.
ENDIF.

Regards

Appana

Re: check if numeric value

RichHeilman — Thu, 17 Aug 2006 14:07:02 GMT

Also, if your field is a fix length and your value does not take up the entire field, you should check the length and check only that part of the field.



report zrich_0001.

data: c(20) type c value '123456'.
data: length type i.

length = strlen( c ).

if c+0(length) co '1234567890'.
  write:/ 'It is a numeric'.
else.
  write:/ 'It is not a numeric'.
endif.

Regards,

Rich Heilman

Re: check if numeric value

RichHeilman — Thu, 17 Aug 2006 14:07:48 GMT

Please make sure to award points for these helpful answers and mark your post as solved when solved completely. THanks and welcome to SDN.

Regards,

Rich Heilman

Re: check if numeric value

Former Member — Wed, 23 Oct 2013 05:15:54 GMT

Hi,

I want to check for only numeric value for material i.e. if my material contains only numbers then i want to set indicator to Y. I have written following code in field level routine.

DATA: lc_num(12) TYPE c VALUE '0123456789'.

DATA: lv_string TYPE c.

lv_string = SOURCE_FIELDS-MATERIAL .

   IF lv_string CO lc_num.
      RESULT = 'Y'.
   ENDIF.

The problem is when i input '1234' value it sets indicator to Y which is correct,when i input value 'K1234' it sets indicator to blank which is right but when i input value '1234K' it sets indicator to Y which is incorrect as value is not numeric.

Please help.....

Re: check if numeric value

Former Member — Wed, 23 Oct 2013 05:28:14 GMT

Hi Anuradha,

Use 'NUMERIC_CHECK' Function Module to check value is char or int.

Regards

Lingaraj

Re: check if numeric value

Former Member — Thu, 24 Oct 2013 04:02:10 GMT

Hi Lingaraj,

Thanks for your suggestion. I have used NUMERIC CHECK function module and it's working fine.

Regards,

Anuradha

Re: check if numeric value

Former Member — Thu, 27 Mar 2014 05:45:46 GMT

thanks Labie koen, I had the same doubt your answer clarified my doubt.

Re: check if numeric value

Former Member — Fri, 25 Jul 2014 19:13:42 GMT

Hello Ronald,

you can try FM - CATS_NUMERIC_INPUT_CHECK [It helps me]

This FM fetches the user's default setting on decimal place.

and then accordingly, classify if entered data is numeric or not.

Infact, this FM is internally used by SAP standard program especially to check quantity value liek ekpo-menge.

this FM is sophisticated enough that it wont allow any alphabets except digits and literals like comma and decimal.

At least it will help one, who comes across this page.

FYI - NUMERIC CHECK [is not good enough to distinguish NUMC and CHAR if u enter comma/deccimal]

Thank you.

best regards,

Rahul Agarwal

Re: check if numeric value

mbukli — Sun, 23 Oct 2022 18:49:14 GMT

Hello there,

How do we do it using the Numeric_Check function.

Re: check if numeric value

ethantew12 — Fri, 05 May 2023 04:16:25 GMT

thanks, this helped me.

Re: check if numeric value

kevin_albrecht — Wed, 13 Sep 2023 10:58:27 GMT

Hi everyone,

I know this is an old thread, but maybe someone will come across it anyway. You could try something like this:

DATA(value) = '-20233.44'.

IF value CO '0123456789.,-'.
  TRY.
      DATA(test) = CONV decfloat16( value ).
      DATA(is_numeric) = abap_true.
    CATCH cx_sy_conversion_no_number.
      is_numeric = abap_false.
  ENDTRY.
ENDIF.

However, if you'd like date and time values not to be considered as numeric values, the logic above must be extended accordingly.