Calendar holidays

[Former Member]

Hi all,

I have a requirement..Can any one of u suggest me a Function module which returns me the holidays in a factory calendar.

So that i dont have to schedule my report to run on those particular holidays.

Itz an urgent issue.

Thanks in advance..

Arun

[Former Member]

Hi

check the fun modules

CATSXT_GET_HOLIDAYS

<b>HOLIDAY_CALENDAR_GET </b>

HOLIDAY_GET

Regards

Anji

[ferry_lianto]

Hi,

Please check the FM HOLIDAY_GET.

Regards,

Ferry Lianto

[Former Member]

Hi,

You can use :

CATSXT_GET_HOLIDAYS

CHECK_HOLIDAY

HOLIDAY_CALENDAR_GET

Thanks,

Sriram Ponna.

[former_member387317]

Hi arun,

here is the solution..

<b>HOLIDAY_GET</b> Provides a table of all the holidays based upon a Factory Calendar &/ Holiday Calendar.

<b>HOLIDAY_CHECK_AND_GET_INFO</b> Useful for determining whether or not a date is a holiday. Give the function a date, and a holiday calendar, and you can determine if the

date is a holiday by checking the parameter HOLIDAY_FOUND.

<b>Example:</b> HOLIDAY_CHECK_AND_GET_INFO

data: ld_date like scal-datum default sy-datum,

lc_holiday_cal_id like scal-hcalid default 'CA',

ltab_holiday_attributes like thol occurs 0 with header line,

lc_holiday_found like scal-indicator.

CALL FUNCTION 'HOLIDAY_CHECK_AND_GET_INFO'

EXPORTING

date = ld_date

holiday_calendar_id = lc_holiday_cal_id

WITH_HOLIDAY_ATTRIBUTES = 'X'

IMPORTING

HOLIDAY_FOUND = lc_holiday_found

tables

holiday_attributes = ltab_holiday_attributes

EXCEPTIONS

CALENDAR_BUFFER_NOT_LOADABLE = 1

DATE_AFTER_RANGE = 2

DATE_BEFORE_RANGE = 3

DATE_INVALID = 4

HOLIDAY_CALENDAR_ID_MISSING = 5

HOLIDAY_CALENDAR_NOT_FOUND = 6

OTHERS = 7.

if sy-subrc = 0 and

lc_holiday_found = 'X'.

write: / ld_date, 'is a holiday'.

else.

write: / ld_date, 'is not a holiday, or there was an error calling the function'.

endif.

Check out these as well

CATSXT_GET_HOLIDAYS

HOLIDAY_CALENDAR_GET

HOLIDAY_GET

<b>

Reward Points if it is helpful.</b>

Thanks & Regards

ilesh 24x7

[Former Member]

Hi thanks 4 the quick reply.

But where do i get the holiday calendar id.

Do u know the table where the holiday calendar id is stored.

Thanks.

Arun

[former_member387317]

Hi sorry for being late in relpy..

as ferry said..

Check out the below tables

<b>T001W

TFACD</b>

<b>Don't forget to reward points for all useful helps..</b>

Thanks & Regards

ilesh 24x7

[ferry_lianto]

Hi,

Please check tables T001W and TFACD.

Regards,

Ferry Lianto

[Former Member]

THANKS