Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get last 24 hrs date

Hi All,

we have a requirement where i need to get records that are changed in last 24 hrs from E070 table .

we have 2 fields last changed date and last creation time.

date can be changed based on the time. suppose last 24 hrs time may get date in between yesterday to today's date. how to get this date.

Thanks

Preethi.

Tags:
Former Member
Former Member replied
data: date TYPE sy-datum,
      t_e070 TYPE TABLE OF e070.
date = sy-datum - 1.
select * from e070 INTO TABLE t_e070 WHERE ( AS4DATE EQ date AND AS4TIME GT sy-uzeit ) or
                         ( AS4DATE EQ sy-datum AND AS4TIME LE sy-uzeit ).
0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question