topic Re: ABAP function in Application Development and Automation Discussions

ABAP function

Former Member — Wed, 06 Jul 2005 14:55:15 GMT

Hi experts,

Can someone guide me how to calculate business days (factory calendar days) no holidays or weekends between two dates. There is a function called 'DATE_CONVERT_TO_FACTORYDATE' but I need to calculate late shipment days between two dates (business days only) without holidays or weekends. Is there another function which can achieve this. Any help is appreciated. Thanks.

Re: ABAP function

RichHeilman — Wed, 06 Jul 2005 15:02:13 GMT

Can you use the function module DURATION_DETERMINE.

Regards,

Rich Heilman

Re: ABAP function

FredericGirod — Wed, 06 Jul 2005 15:02:29 GMT

Don't understand what you don't understand.

Your function give you the number of the day for a date.

You use two times to have two number and you make diff between this two number. This diff is the diff of working day.

Is it not easy ?

Frédéric

Re: ABAP function

RichHeilman — Wed, 06 Jul 2005 15:06:34 GMT

Here is a sample....



data: xt001w type t001w.
data: duration type i.
data: sdate type sy-datum.
data: edate type sy-datum.

* Get the factory calendar for specific plant
select single * from t001w into xt001w
                   where werks = '0004'.   " Use your plant

* Set start/end dates
sdate = sy-datum.
edate = '20050731'.

call function 'DURATION_DETERMINE'
 exporting
   factory_calendar                 = xt001w-fabkl
 importing
   duration                         = duration     " In days
 changing
   start_date                       = sdate
   end_date                         = edate
 exceptions
   factory_calendar_not_found       = 1
   date_out_of_calendar_range       = 2
   date_not_valid                   = 3
   unit_conversion_error            = 4
   si_unit_missing                  = 5
   parameters_not_valid             = 6
   others                           = 7.

write:/ duration.

Regards,

Rich Heilman

Re: ABAP function

Former Member — Wed, 06 Jul 2005 16:06:13 GMT

Mr. Helman,

Thanks so much for your help.

Regards,