SAP Knowledge Base Article - Public

3708464 - Unable to retrieve Pending Employee Time records using recordStatus='pending' or Workflow Navigation

Symptom

  • API queries intended to fetch "Pending" leave requests return no data or errors.
  • The query parameter recordStatus='pending' does not return expected results for the Employee Time entity.
  • Attempts to retrieve data through wfRequestNav (Workflow Navigation) using pending status flags fail to show the underlying Time Off details.

Cause

This behavior is due to the architectural design of the Employee Time entity:

  • Pending Data Concept: Unlike other MDF entities, Employee Time does not utilize the "Pending Data" state. The record is created directly in the main entity table upon submission.
  • Entity Limitations: The recordStatus parameter and certain workflow navigation filters are not supported for Employee Time because the record exists as a standard entry with a status attribute rather than a "pending" metadata flag.

Resolution

To successfully retrieve records awaiting approval, you must query the Employee Time entity directly and filter by the record's internal status field.

Correct API Approach: Use the approvalStatus field in your OData filter.

  • Endpoint: /odata/v2/EmployeeTime
  • Query Filter: $filter=approvalStatus eq 'PENDING'

See Also

2230086 - Is it possible to update the Time Off/Time Sheet workflow fields in the workflow approval page?

Keywords

EmployeeTime, OData API, Pending Data, MDF, approvalStatus, wfRequestNav, Time Off, RecordStatus , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-EC-TIM , Time Off , Problem

Product

SAP SuccessFactors HCM Suite all versions