topic Re: Calendar Functions in Application Development and Automation Discussions

Calendar Functions

Former Member — Mon, 05 Jun 2006 14:37:19 GMT

Hello all.

Wich functions should i use to obtain the calendars and their associations with the plant? Is there any function that returns the nonworking days as intervals?

I also would like to know how to obtain shifts.

Thank you

Nuno Silva

Re: Calendar Functions

former_member181966 — Mon, 05 Jun 2006 14:43:21 GMT

Try

call function 'CY_GET_TIMEINTERVAL' exporting

calendar_id = rc65a-kalid

fiscal_year_variant = rc65a-periv

period_type = rc65a-zaper

sdatefrom = rc65a-zavon

sdateto = rc65a-zabis

importing

datefrom = rc65a-lidav

dateto = rc65a-lidab

datefrom_string = rc65a-zavon

dateto_string = rc65a-zabis

exceptions

interval_cannot_be_computed = 01.

FYI

INCLUDE PROG :MC65AFP1

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 14:47:27 GMT

YOu can get the factory id from plants table T001w-FABKL.

FABKL is the field.

YOu can use the fm K_ABC_WORKDAYS_FOR_PERIODS_GET to get the working days in the interval specified.

The rest are non-working days.

Regards,

ravi

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 14:48:42 GMT

hi,

use factory calender for working days.

FM.

WSAF_GET_LAST_DAY_OF_MONTH

FKK_ADD_WORKINGDAY

check if day of the month is a working day or not

CALL FUNCTION 'ISU_CHECK_HOLIDAY'

EXPORTING

i_date = xyv_read_end

i_calendar1 = gc_factory_cal

IMPORTING

e_x_no_workingday = flg_is_non_working

e_x_is_holiday = flg_is_holiday

EXCEPTIONS

not_found = 1

calendar_error = 2

OTHERS = 3.

IF sy-subrc <> 0 .

do nothing

ENDIF.

regards

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 14:51:15 GMT

YOu can use the fm HOLIDAY_GET to get the non working days.

Regards,

Ravi

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 15:35:42 GMT

Saquib,

I could not get the function to work the way it should. It says the interval is not valid

Thank you

Message was edited by: Nuno Silva

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 15:38:20 GMT

Ravi Kanth Talagana,

Thank you for the info on the plant's calendar.

That specific function asks for a parameter called CALL_PROG. What should i put there?

Function HOLIDAY_GET is quite usefull, but is there any way to convert this into intervals?

Thank you.

Re: Calendar Functions

Former Member — Mon, 05 Jun 2006 15:51:03 GMT

HI NUno,

The FM DATE_CONVERT_TO_FACTORYDATE will be more relevant to your requirement.

date1 = start_date.

do.

if date1 = end_date.

exit.

endif.

CALL FUNCTION 'DATE_CONVERT_TO_FACTORYDATE'

EXPORTING DATE = DATE1

FACTORY_CALENDAR_ID = CALENDAR

IMPORTING DATE = DATE2

FACTORYDATE = FACTORYD

WORKINGDAY_INDICATOR = WORKDAY

EXCEPTIONS CORRECT_OPTION_INVALID = 1

DATE_AFTER_RANGE = 2

DATE_BEFORE_RANGE = 3

DATE_INVALID = 4

FACTORY_CALENDAR_NOT_FOUND = 5.

if workday <> 'X'.

it_non_work_day-date = date1.

append it_non_work_day.

clear it_non_work_day.

endif.

date_1 = date_1 + 1.

enddo.

REgards,

Ravi