topic Re: Runtime Error - CONVT_NO_NUMBER in Application Development and Automation Discussions

Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 04:31:51 GMT

Hi All,

I am trying to get data based on time and date input....

In the table the filed is having the value like this: 30.07.2010 11:48:51

so i concatenated the input by user and bought it to same format......

but i am gettin an runtime error as

"Error analysis

An exception occurred that is explained in detail below.

This exception cannot be caught in the context of the current statement.

The reason for the exception is:

The program attempted to interpret the value "27.07.2009 14:22:06" as a num

but

since the value contravenes the rules for correct number formats,

this was not possible."

Please let me know.. how to proceed..

Re: Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 04:35:13 GMT

Hi,

Does the Data type of Table field and Generated Input variable are same ?

Regards

Vinod

Re: Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 04:40:51 GMT

Hi Poonam,

Check you data declaration for the Date & time variables.

Follow this link you will get an idea.

Credits to Rich Heilman [;

Regards

Abhii

Re: Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 05:05:11 GMT

Please see this:

finaldt_low(10) type c ,

lv_crtat_low(19) type c,

pa_frmtm TYPE sy-uzeit,

CONCATENATE finaldt_low pa_frmtm INTO lv_crtat_low SEPARATED BY space.

I am using a concatenate so the final field will be of character value....

then i am doing a select

SELECT lgnum

procty

tostat

altme

vsola

weight

rdocid

confirmed_by

FROM /scwm/ordim_c

INTO TABLE it_ordim

FOR ALL ENTRIES IN it_actype

WHERE procty EQ it_actype-procty

AND rdoccat = 'PDI'

AND created_at GE lv_crtat_low

AND created_at LE lv_crtat_high .

here the bold one is a problem...

CREATED_AT -> /SCWM/DE_CREATED_DT... is of this type...

Re: Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 05:07:33 GMT

Hi,

> In the table the filed is having the value like this: 30.07.2010 11:48:51

> so i concatenated the input by user and bought it to same format......

Table will show the date field and time field according to the user settings.(Just for display purpose)

You need to just read them into your variables and use them as they are.

You need not concatenate them into the same format as shown in the table.

Regards,

Srini.

Re: Runtime Error - CONVT_NO_NUMBER

Former Member — Wed, 01 Sep 2010 05:11:46 GMT

I mean to say the selection screen is having date and tme fields.... so to compare i need to concatenate....

one more thing is when i execute SE11... the field shows me like this in the table : 20.100.730.094.851..... this is date n time...