topic Re: run time error in Application Development and Automation Discussions

run time error

Former Member — Fri, 07 Sep 2007 08:01:38 GMT

Hi all.

please go through this code

SELECT-OPTIONS : DATE FOR T_ZATTM-CDAT OBLIGATORY.

loop at t_zattm.

SELECT * FROM ZOTTAB INTO OTTAB

WHERE ECODE = T_ZATTM-ECOD AND

ODATE IN DATE."= t_zattm-cdat.

endloop.

my problem is if i give date range above 2 year am geting run time error. like this

Unable to interpret "*00" as a number.

please tell me that is the error and how to solve this .

Re: run time error

Former Member — Fri, 07 Sep 2007 08:14:16 GMT

Hi!

Are you sure, this error is occurred during the SELECT?

This error means, in a NUMBER type field, there is a "*" sign, which is NOT a number. Number fields like integer, numc, etc... Contains only 0-9 numbers.

You might check out not only the DATE, but the ECODE field also in your ZOTTAB, maybe that's the problem.

Regards

Tamá

Re: run time error

Former Member — Fri, 07 Sep 2007 08:15:01 GMT

Hi Prajwal

I think you should check the data in the table .Just check the data in the tables corresponding to that date range.

Second thing is change the date range and check if the same problem comes. I think the problem lies with the data.

regards

Sourabh Verma

Re: run time error

Former Member — Fri, 07 Sep 2007 08:23:32 GMT

good

i would suggest you to check your table T_ZATTM-CDAT ,and test it manually that wheather it contain any vale move than 2 yr from the current date.

thanks

mrutyun^

Re: run time error

Former Member — Fri, 07 Sep 2007 08:36:42 GMT

thanks to all i will chick that .

program is working fine if i use this code .

SELECT * FROM ZOTTAB INTO OTTAB

WHERE ECODE = T_ZATTM-ECOD AND

ODATE = t_zattm-cdat.

if i give odate in date its giving problem.

Re: run time error

Former Member — Fri, 07 Sep 2007 08:46:32 GMT

Hi,

Pls check your data type of T_ZATTM-CDAT field. it must be dats type. else you well get error. and check in runtime what value you are getting into DATE parameter. SAP date format is yyyymmdd (20070607) pls take care while using the date values..

regards

Rajesh V

Re: run time error

Former Member — Fri, 07 Sep 2007 10:28:38 GMT

Hi prajwal,

try giving a different name to the date select-option like s_date.

SELECT-OPTIONS : DATE FOR T_ZATTM-CDAT OBLIGATORY.

Regards,

Sheron