Problem using SY-DATUM in (SQL) BETWEEN

[luis_rod]

Hi all,

Have the following (pseudo) code:

SELECT myfile~field1 FROM myfile INTO (w_field1) WHERE sy-datum between myfile~begda and myfile~endda

I get a syntax error that states that sy-datum is unknown.

Any ideas?

Thanks,

Luis Rodríguez

[luis_rod]

Hi all,

Have the following (pseudo) code:

SELECT myfile~field1 FROM myfile INTO (w_field1) WHERE sy-datum between myfile~begda and myfile~endda

I get a syntax error that states that sy-datum is unknown.

Any ideas?

Thanks,

Luis Rodríguez

[Former Member]

Hi, you can not use sy-datum in SQL.

check this post

https://archive.sap.com/discussions/thread/1044301

Regards

Miguel

[luis_rod]

Miguel,

Thanks for the info. It seems a silly limitation. Sigh... Already coded the workaround (not the most elegant of solutions, though).

Thanks again,

Luis