Suppose there are 5 entries with first day (ertag) in table prow:
Suppose system date (sy-datum) is 25.07.2005, I want a SQL that should select the third entry (01.07.2005).
This SQL only selects the first entry:
Select single * from PROW into corresponding fields of ITAB where ERTAG LE SY-DATUM.
Could anyone help ? Thx.