FM to find n.of working days

See sample code below:

report zcalculate_days.

• Sample code to calculate total working days and holidays between 2 dates.

data: total_days(4) type c,

v_holidays type i,

v_work_days type i,

v_total_days type i.

data: begin of holidays occurs 0.

include structure iscal_day.

data: end of holidays.

parameters: from_dt like sy-datum,

to_date like sy-datum,

calendar like scal-hcalid.

start-of-selection.

• Get total days between 2 dates

call function 'DAYS_BETWEEN_TWO_DATES'

exporting

i_datum_bis = to_date

i_datum_von = from_dt

i_kz_excl_von = '0'

i_kz_incl_bis = '1'

i_kz_ult_bis = ' '

i_kz_ult_von = ' '

i_stgmeth = '0'

i_szbmeth = '2'

importing

e_tage = total_days

exceptions

days_method_not_defined = 1

others = 2.

• Get Holidays between 2 dates

call function 'HOLIDAY_GET'

exporting

holiday_calendar = calendar

factory_calendar = calendar

date_from = from_dt

date_to = to_date

tables

holidays = holidays

exceptions

factory_calendar_not_found = 1

holiday_calendar_not_found = 2

date_has_invalid_format = 3

date_inconsistency = 4

others = 5.

describe table holidays lines v_holidays. "Total holidays

v_total_days = total_days. "Total days

v_work_days = total_days - v_holidays. "Total working days

write:/ 'Start date : ', from_dt.

write:/ 'End date : ', to_date.

write:/ 'Calendar : ', calendar.

write:/ 'Total days : ', v_total_days.

write:/ 'Working days : ', v_work_days.

write:/ 'Holidays : ', v_holidays.