last two hours data

[Former Member]

Hi,

for every run of the program i want to take last two hours data of vbak table.

how to achieve this

[jayakummar]

hai ,

do below code,

data : cur type sy-uzeit value sy-uziet.

data : per type sy-uzeit value sy-uzeit.

per+find the correct possition of hours) = per - 2.

select * from vbak into table inttable where erzet le cur and erzet ge per.

reward if useful.

regards,

jai.m

[Former Member]

Hi Jayakumar,

thanks for the input

Issue has been resolved and written as below

RANGES : o_cr_time FOR sy-uzeit.

o_cr_time-low = sy-uzeit - 7200.

o_cr_time-high = sy-uzeit.

o_cr_time-option = 'BT'.

o_cr_time-sign = 'I'.

APPEND o_cr_time.

Select a b c into itab where erzet in o_cr_time.

[Former Member]

issue resolved, closing the thread