How to get last 24 hrs date
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.
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 ).