sy-datum in database view?
How to get data from database table for date field = current system date?
Thanks!
Not sure what your question is. You seem to know what SY-DATUM is and you must have a table in mind, so do you not know how to use OPEN SQL and the WHERE clause? Be more specific please.
I have big table with two fields of dates ...
It is necessary to receive each day sample of the data for the current date (DAT1<=sy-datum<=DAT2)
I want to work with the available data and to not do each time SELECT WHERE...
can u elaborate the question plz ?
Catman .
ORACLE VIEW:~
create view ..... where dat1 <= sysdate and ... - WORKS!
ABAP DICTIONARY VIEW: how to ???