Skip to Content
0
Former Member
Jul 30, 2005 at 01:37 AM

How to select a single entry with latest date just LE system date?

300 Views

Hi all,

Suppose there are 5 entries with first day (ertag) in table prow:

01.05.2005

01.06.2005

01.07.2005

01.08.2005

01.09.2005

Suppose system date (sy-datum) is 25.07.2005, I want a SQL that should select the third entry (01.07.2005).

FYI:

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.