topic Re: Time calculation in Application Development and Automation Discussions

Time calculation

Former Member — Wed, 02 Nov 2011 11:17:57 GMT

I've found a number of datetime function modules that take two date-time values and spit out the time between these date-time values in all sorts of ways. But what I really need is a function module that takes two date-time values and returns the business hours between the two values including taking into account the holiday calendar in SAP config.

As an example of what I'm refering to... Operating hours for my business is 8am to 5pm (Monday thru Friday) and, for instance, May 1st is a holiday in SAP config. The first date-time value is April 30th, 10:00:00 and the second date-time value is May 2nd, 10:00:00. Total time is 48 hours, however, total business hours is 18 hours (9 hr day) but you need to take out the holiday in between as well so that drops the "business time difference" is 9 hours.

Any thoughts?

Thanks

Re: Time calculation

kesavadas_thekkillath — Wed, 02 Nov 2011 11:27:28 GMT

Its a date time time question and doesnt look basic.

You can have look at COPF_DETERMINE_DURATION. Please note that you have to pass the factory calendar to the function

Kesav

Re: Time calculation

Former Member — Wed, 02 Nov 2011 11:31:13 GMT

i'm in CRM7 and COPF_DETERMINE_DURATION does not exist.

Re: Time calculation

kesavadas_thekkillath — Wed, 02 Nov 2011 11:38:48 GMT

Hi,

I donot have a CRM system here, May be you can login to other system and check the logic written in it. There should be some functions existing in CRM to get the working days between two dates, Making use of that please build the custom logic.

Kesav

Re: Time calculation

Former Member — Wed, 02 Nov 2011 12:51:07 GMT

the DURATION_DETERMINE exists in CRM. i'll use it.

Thanx.

Points rewarded.

Re: Time calculation

Former Member — Wed, 20 Apr 2016 12:19:55 GMT

Dear Andre,

I am not sure whether this will help or not