SAP Knowledge Base Article - Preview

3752016 - Timestamp discrepancies between SAP SuccessFactors and target table - SAP HANA Smart Data Integration

Symptom

  • Data is replicated via ODataAdapter and SAP SuccessFactors is the source system.
  • No conversion is performed by the ODataAdapter when reading from the SuccessFactors API.
  • A field that contains a timestamp (for example: "lastModifiedDate") shows different timestamps between SAP SuccessFactors and the associated Remote Table in SAP Datasphere.
  • The timestamps differ by hours.
  • Both Virtual Table (database level) and target table hold the same value, which rules out a display/UI issue.


Read more...

Environment

  • SAP HANA smart data integration
  • SAP Datasphere
  • SAP SuccessFactors

Product

SAP HANA smart data integration all versions

Keywords

timestamp difference, lastModifiedDate, timezone, time zone, utc, local time, odata v2, remote table, virtual table, SAP successfactors, SAP datasphere, jobapplicationaudit, time conversion, api vs ui, difference, different, divergent, discrepancy, sf, sdi, odata, display, displayed, incorrect, wrong, time, date, odata adapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , DS-DI-RT , Remote Tables , 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 for Me (Login required).

Search for additional results

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