SAP Knowledge Base Article - Public

2470903 - How to use "Effective From" and "Effective To" filters to obtain historical/future records - Integration Center

Symptom

You are trying to query data from SFSF using integration center and the query does not return the future dated or historical records in the output file, only the recent time slice is returned in the output.

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
    • Integration Center

Reproducing the Issue

  1. Go to Admin Center > Integration Center
  2. Create a simple CSV outbound integration
  3. Choose an effective-dated (like EmpJob, for example) as the base entity and select the fields needed
  4. Now click on Configure Fields tab and notice that only the latest time slice record is shown

latestRecord.jpg

Cause

OData queries by default fetches only the As Of Date record, hence we need to apply From Date and To Date filters to fetch historical/future. Since Integration Center runs on OData, same behavior applies to it too.

Resolution

  1. Go to "Filter and Sort" tab
  2. Under "Time-Based Filters", you'll be able to see the "Effective From" and "Effective To" filters.

    timeBasedFilters.jpg

  3. Choose the values for "Effective From" and "Effective To" according to your requirement by clicking in the pencil icon next to it.
    For example: if we want to fetch the complete information pertaining to an employee from 2001-05-10 until today, we can set the "Effective From" to that value:

    configuringFilter.jpg

  4. Now all the historical data for that employee will be properly shown according to the period set on "Effective From" and "Effective To" filters

historicalRecords.jpg

Note: the filters available under Time-Based Filters section (including the "Modified Since Query Mode" filter) will only work on effective dated entities. If you configure these filters and your integration is selecting only fields from non-effective dated entities, they will be ignored.

See Also

What is Effective Dating?

Integration Center (IC) Guide

Keywords

Future dated records, Historical records, Inactive users, Integration center, effective dated, effective-dated, historical, past, future, inactive, time based filter, filters, time-based, successfactors, ic, integration center, configure fields, preview, latest, recent, active, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-API , API & Adhoc API Framework , Problem

Product

SAP SuccessFactors HXM Suite all versions