3202766 - Error "Cannot get remote source objects: Could not get tables" in ABAP On-Premise Connection - SAP Datasphere

Import of Remote Tables using ABAP based source system connections like  SAP BW/SAP ABAP/ SAP ECC/SAP S/4HANA On-Premise in SAP Datasphere, fails with an error:

HTTP Status: 500 Internal Server Error
Error Code: getChildrenFailed
Technical Message: internal error: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000

OR

- Remote tables are partially available for this connection.

Furthermore, validation of the corresponding connection fails with below error:

Remote Tables: Probably authorizations are missing from ABAP tables: internal error: cannot get remote source objects: Could not get tables, code 403, SQL State: HY000

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Datasphere

Cannot get remote source objects, Could not get tables, getChildrenFailed, dwc, data warehouse cloud, proper, Internal Server Error, getChildrenFailed, code 403, DQL State:HY000, SQL State: HY000, Could not get tables, authorizations, missing, ABAP Tables, ABAP adapter, dwc, data warehouse cloud , KBA , DS-DI-CON , Connections , HAN-DP-SDI , SAP HANA smart data integration (SDI) , DS-DI-RT , Remote Tables , Problem