Symptom
- 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?
Read more...
Environment
-
HANA version is 1.00.122.12.1502962396
-
All currently supported SDI versions
Product
SAP Business Technology Platform 1.0
Keywords
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.