- 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 1.00.122.12.1502962396
All currently supported SDI versions
SAP Cloud Platform 1.0
KBA , HAN-DP-SDI , SAP HANA smart data integration , 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.