topic Re: Function module to get time taking into account breaks in Application Development and Automation Discussions

Function module to get time taking into account breaks

Former Member — Thu, 31 Jan 2013 16:16:52 GMT

Hello,

Does anybody know any function module to retrieve a finish date and finish time according to the initial date, the initial time and the shift time?

I know:

Initial date DD/MM/YYYY
Initial time HH:MM:SS
Time: minutes
Shift time: the job can only be scheduled from 8:00 -13:00 and 14:45-18:00

I would like to get:

Finish date DD/MM/YYYY
Finish time: HH:MM:SS

So, if the job begins at:

Initial date: 31/01/2013
Initial time: 17:55
Time to finish: 30 minutes
Shift time: 8:00 -13:00 and 14:45-18:00

The function module should give the following result:

Finish date: 01/02/2013
Finish time: 8:25

Is it possible?

Thanks in advance,

Oscar

Re: Function module to get time taking into account breaks

Former Member — Fri, 01 Feb 2013 10:46:07 GMT

No answers?

Re: Function module to get time taking into account breaks

Former Member — Fri, 01 Feb 2013 11:30:40 GMT

Hi Oscar,

There is no standard function module that suits your requirement

But refer to Standard function module CATT_ADD_TO_TIME and you can copy this function module to a custom function module.

The function module has the code as follows

DATA: LOW-DATE TYPE D VALUE '19000101'.
DATA: S(16) TYPE P.
S = ( IDATE - LOW-DATE ) * 86400 + ITIME.
S = S + STDAZ * 3600.
EDATE = LOW-DATE + ( S DIV 86400 ).
ETIME = S MOD 86400.

You will just need to replace the seconds 86400 to the seconds of the shift hours 5 hrs ( 18000 seconds).

Hope this helps. Let me know if additional info is required.

Thanks,

Tooshar Bendale

Re: Function module to get time taking into account breaks

Former Member — Fri, 01 Feb 2013 13:41:27 GMT

Thank you Tooshar.