topic calculate the time difference. in Application Development and Automation Discussions

calculate the time difference.

Former Member — Fri, 08 May 2009 12:00:35 GMT

Hi,

I have to develop a report which should provide the PO list which has been created in the last 30 min.

I can take the current time from SY-UZEIT.

Can anybody help me if there any FM for this to find the PO list which has been created in the last 30min.

Regards,

Prabu

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:05:22 GMT

NAST-UHRVR based on this field ,you can calculate PO list in 30 mins by passing the value I hope but I am not sure

Edited by: Gayathri G on May 8, 2009 2:05 PM

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:10:19 GMT

Hi Prabu


I have to develop a report which should provide the PO list which has been created in the last 30 min.
I can take the current time from SY-UZEIT.

=> Check if the PO creation date and time is stored in some table and do comparison accordingly.

Can anybody help me if there any FM for this to find the PO list which has been created in the last 30min.

=> I dont think there is any FM for the same

Regards

Shital

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:11:18 GMT

Hello,

Check this it is working fine.

move:'003000' to y_v_time.

y_v_time = sy-uzeit - y_v_time.

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:15:49 GMT

Hi,

try like this.

w_time = sy_uzeit - 30.

so in w_time , u can get last 30 minutes.

Then using this w_time,

put query on ekbe table where cpudt = sy-datum and cputm = w_time.

Then use EKKO,EKPO table & display PO list.

Hope this will solve ur problem.

Thanks & Regards,

Anagha Deshmukh

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:37:42 GMT

Hi Prabhu,

Try This

w_cur_time = sy-uzeit.

w_po_time = w_cur_time = 30.

select objectid from cdhdr into table t_tdhdr

where objectclass = 'EINKBELEG' and

udate = sy-datum

and utime in between w_cur_time , w_po_time and

tcode = 'ME21' and CHANGE_IND = 'I'.

Hope this works

Regards

Krishna

Re: calculate the time difference.

Former Member — Fri, 08 May 2009 12:52:43 GMT

Hi Everybody,

Thanks a lot of your information.

I solved this problem.

Regards,

Prabu