ABAP HR: Public Holiday (Table Name)

[Former Member]

Dear All,

right now i m working on HR Report.

as per requirement i want to Show the public holidays in report.

i want the table name where public holidays are stored after configuring or fixing by any organizatio n..

Waiting for reply

Anshuman

[GauthamV]

hi,

use these tables.

T5C14

T5C15

T5ITGC

THOLU.

[Former Member]

thanx for quick response,

I think THOLU will be useful for me.

becoz, for october month my organization's fixed 28, 29, 30 for holiday.

when i exwcute the THOLU table all above 3 dates are present.

but the problem is that how can i fetch the adject data for particular month???

and what is FTGID - Public holiday key.

In sort, i want to say plz tell me step by step how can i fetch the data.

[GauthamV]

hi,

FTGID is used to indicate the reason for holiday.

for ex: 171 deepavali,180 bakrid...

also you have year,month and date avaaailable for the holiday.

so select the data from that table according to your requirement.

[Former Member]

Hi Dear,

Suppose i have FTGID 503 for Diwali.

when i run the table THOLU with 503, coming result is

FTGID JAHR MONAT TAG

504 2008 08 16

Suppose, in next year Diwali will be on 12 Nov.

so my question is is this FTGID 504 will be same for the next year.

if yes then in 2009 i want to find 2008 diwali date, so how can

Reply soon

thanx

Anshuman

[Mohamed_Mukhtar]

Hi Anshuman,

Go through the below link

/message/6334238#6334238 [original link is broken]

Thanks & Regards

[Former Member]

Hi,

Try with the table 'T5ITGC'.

Hope it is useful,

Thanks,

Sandeep.

[MarcinPciak]

THOCI - holiday calendar

TFACD - factory calendar

You combine certain WS with desired calendar via table T552A.

[Former Member]

hi,

public holidays vary from pernr to pernr. As a pernr in diffrent subareas have diff public holidays. For this in HR, each subarea is linked to a Calander ID. Get the list of these IDs from your Functional.

Use FM

HOLIDAY_GET

pass that ID to HOLIDAY_CALENDAR of this FM and you will get list of public holidays

[Former Member]

Hi,

Check below tables:

thoc " public holidays calender

thod " public holidays definition

thoci " public holidays calender index

thoct " public holidays calender text

thol " public holidays

tholt " public holiday text

tholu " Dates of movable public holidays

You can also use a function module holiday_get as follows

call function holiday_get

exporting

HOLIDAY_CALENDAR = 'x' " will get you list of public holidays

FACTORY_CALENDAR = 'x' " will get you list weekly offs like sat, sun

Cheers..

Reward Points if useful

Edited by: SAKKTHISS KUMAAR on Oct 14, 2008 9:02 AM

[Former Member]

How cani get the Public holiday IDs?????????????????

for run the FM Public Holidays ID is required

[Former Member]

holiay calander IDs are linked to personal subarea

You can get these IDs from your functional consultant