topic Re: last two hours data in Application Development and Automation Discussions

last two hours data

Former Member — Wed, 26 Dec 2007 06:41:39 GMT

Hi,

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

how to achieve this

jayakummar — Wed, 26 Dec 2007 06:55:19 GMT

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 — Fri, 28 Dec 2007 06:38:45 GMT

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 — Fri, 28 Dec 2007 06:44:14 GMT

issue resolved, closing the thread