SAP Knowledge Base Article - Public

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

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:

  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

Keywords

Holiday, Holiday Calendar, EmployeeTimeCalendar, TIMX_CALENDAR, Employee Time Calendar, Holiday Calendar List , KBA , SRD-HR-TLM , Time and Labour Management , Problem

Product

SAP Business ByDesign all versions