SAP Knowledge Base Article - Public

2807404 - Is it Possible to Read the Holiday Calendar in Business ByDesign Using a Business Object?


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.


SAP Business ByDesign


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:

  1. Login to Cloud Application Studio
  2. Go to View
  3. Select Repository Explorer
  4. Search for Business Object EmployeeTimeCalendar
  5. Go to Node PeriodItem
  6. Right Click and select Execute Query on QueryByDate
  7. Provide input parameters to above query like Employee ID, Date Period and Step Type Code = 0022
  8. Select all the entries
  9. Using Navigation by Association option select ToParent
  10. You get a list of all the Holidays valid for this Employee for a provided date period


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


SAP Business ByDesign all versions