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 1.00.122.12.1502962396
• All currently supported SDI versions

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem