SAP Knowledge Base Article - Preview

2959633 - Duplicated records are being returned when querying on expanded navigated fields using fromDate/toDate - OData API


Considering there are 3 entity types: A, B and C. A has an 1->1 navigation "bNav" to B, B has an 1->many navigation "cNav" to C. A has 2 timeslice records a1, a2 for a code k. Both a1 and a2 are associated to a B record b. And record b associated to C record c1 and c2.
Then do query A?$expand=bNav/cNav&$filter=code eq 'k'&fromDate=... to query for both 2 records of A, the data under cNav will be duplicated.



  • SAP SuccessFactors HXM Suite
    • OData API


duplicated, records, results, duplicate, dupe, odata, api, call, query, select, expand, navigation, nav, release, b2011, sf, successfactors, success factors, time-based filter, fromdate, from date, todate, to date, effective-dated, effective dated, effective date, historical record, custom, nav, link, links , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.