3631289 - Error: "You don't have permission to view the Successor entity" while selecting through Virtual table created from ODataAdapter connection

• User is testing a HANA upgrade to version 2.0 rev 79.2 and observed changed behavior when performing federated joins using the ODataAdapter against a SuccessFactors source.
• In production (HANA 2.0.037), federated joins between ODATA virtual tables are pushed down correctly to the SuccessFactors source.
• In sandbox (HANA 2.0.079), the same join query is not pushed down. Instead, it returns the error: "[COE0020] You don't have permission to view the Successor entity"
• This error is documented in KBA 3001998 – [COE0020] You don't have permission to view the Successor entity.  Direct select is already avoided through "Inner Join", but the same "Inner Join" is not working in upgraded HANA version

SAP HANA smart data integration (SDI)

hana upgrade, federated joins, odata sda adapter, successfactors, permission error, successor entity, inner join, left join, navigation properties, sandbox environment, production environment, sdi , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem