run time error

[Former Member]

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

<b>Unable to interpret "*00" as a number.</b>

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

[Former Member]

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á

[Former Member]

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

[Former Member]

hi

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^

[Former Member]

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 <b>odate in date</b> its giving problem.

[Former Member]

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

[Former Member]

Hi prajwal,

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

SELECT-OPTIONS : <b>DATE</b> FOR T_ZATTM-CDAT OBLIGATORY.

Regards,

Sheron