SAP Knowledge Base Article - Public

3428350 - PaymentInformationDetailV3 is unable to retrieve all data when using snapshot pagination

Symptom

PaymentInformationDetailV3 is unable to retrieve all data when using snapshot pagination.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP SuccessFactors HXM suite
    • Integrations 
      • PaymentInformationDetailV3 entity

Reproducing the Issue

1. POST: odata/v2/PaymentInformationDetailV3?$filter=PaymentInformationV3_worker in 'A','B','C','D','E'&$select=externalCode&$format=json&paging=snapshot

Response: Only return records A, B, and C.

2. POST: odata/v2/PaymentInformationDetailV3?$filter=PaymentInformationV3_worker in 'A','B','C','D','E'&$select=externalCode&$format=json&$top=200&$skip=0

Response: Return all A, B, C, D, E.

Resolution

Please help to add fromDate parameter. e.g.

POST: odata/v2/PaymentInformationDetailV3?$filter=PaymentInformationV3_worker in 'A','B','C','D','E'&$select=externalCode&$format=json&paging=snapshot&fromDate=1900-01-01 

Please notes:

1. The logic of Snapshot Pagination has been optimized. It can also retrieve all data for entities without a start date. However, for the entity PaymentInformationDetailV3 with a parent-child relationship, there is an additional layer of logic related to asOfDate. 

For example, PaymentInformationDetailV3 does not have its start date but relies on the start date of the parent item. However, by default, the implied condition of asOfDate = <today> is added for the start date of the parent item. This can result in different data compared to the data obtained through Client paging.

2. The Client Pagination has been developed over a long period and can retrieve all data for entities without a start date. On the other hand, PaymentInformationDetailV3 does not have its start date and relies on the start date of the parent item. As a result, it can retrieve all records for PaymentInformationDetailV3.

3. The Integration Center Preview page mentioned in KBA 2954518 utilizes Client paging and therefore retrieves all records.

 

Keywords

INC7258044, Snapshot, Client, Pagination, asOfDate, PaymentInformationV3, SF Odata API filter, PaymentInformationV3_worker , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-MDF , Metadata Framework API (MDF) , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem

Product

SAP SuccessFactors HCM Core all versions