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 from date parameter to fetch historical data from EmpJob Odata entity exposed by SF Employee Central when used through a virtual table created in HANA
  • Querying the same OData entity through a URL format returns one single record - the active one - for a given employee
  • Adding the "fromdate" parameter (not as a filter), brings all historical records for a given employee
  • How can the "fromdate" parameter be implemented in a SQL query against the virtual table?



  • HANA version is
  • All currently supported SDI versions


SAP Business Technology Platform 1.0


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