2578195 - Unable to fetch historical data from SF EmpJob OData virtual table in SDI

• 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?

• SAP Hana 1.0 SPS12 Rev 14 (1.00.122.14) or before
• SAP Hana 2.0 SPS00 Rev 2.02 (2.00.002.02) or before
• SAP Hana 2.0 SPS01 Rev 12.03 (2.00.012.03) or before
• SAP Hana 2.0 SPS02 Rev 23 (2.00.023.00) or before

effective-dated entities, SuccessFactors, Success Factors , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem