I am writing a function module to access an external Oracle database that has been defined in our ABAP system using DBConnect.
I would like to use Open SQL instead of Native SQL to access the data in the remote table. Is this possible? I believe that in order to do this, a view of the remote table would have to be defined in the ABAP data dictionary via SE11, but I am unable to do this.
Does anyone know if this is possible, or am I required to use Native SQL when accessing an external database?