- 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
SAP Business Technology Platform 1.0
KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this pageThis 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.