SAP Knowledge Base Article - Preview

2578195 - Unable to fetch historical data from EmpJob SF Odata through a virtual table in HANA SCP, SDI 1.x


  • Unable to use fromdate parameter to fetch historical data from EmpJob Odata entity exposed by SF Employee Central when used through a virtual table created in HANA
  • When querying the same OData entity through an URL format, it will also bring one single record - the active one - for a given employee
  • However, when adding the "fromdate" parameter (not as a filter), it will bring all historical records for a given employee
  • how do we implement the "fromdate" parameter in a SQL query against the virtual table?



  • HANA version is
  • All currently supported SDI versions


SAP Cloud Platform 1.0


KBA , HAN-DP-SDI , SAP HANA smart data integration , 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.