Symptom
Your requirement is to read the Holiday Calendar using a Business Object. You want to know how to get the list of all the Holidays valid for the Employee for a provided date period.
Environment
SAP Business ByDesign
Resolution
You may use the below for your Holiday Calendar List.
Business Object : TIMX_CALENDAR (Employee Time Calendar)
Business Object Node : PERIOD_ITEM
Business Object Node Query : QUERY_BY_DATE (You can provide parameters like : Employee ID, Date Period, and Step Type Code = '0022' to execute the query)
Steps to fetch list of holidays are as follows:
- Login to Cloud Application Studio
- Go to View
- Select Repository Explorer
- Search for Business Object EmployeeTimeCalendar
- Go to Node PeriodItem
- Right Click and select Execute Query on QueryByDate
- Provide input parameters to above query like Employee ID, Date Period and Step Type Code = 0022
- Select all the entries
- Using Navigation by Association option select ToParent
- You get a list of all the Holidays valid for this Employee for a provided date period
Keywords
Holiday, Holiday Calendar, EmployeeTimeCalendar, TIMX_CALENDAR, Employee Time Calendar, Holiday Calendar List , KBA , holiday calendar , timx_calendar , period_item , employee time calendar , holiday calendar list , employeetimecalendar , holiday , SRD-HR-TLM , Time and Labour Management , Problem