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.
SAP Knowledge Base Article - Preview