Access external database views on different tablespace

Former Member — Wed, 12 Mar 2008 12:37:56 GMT

Hi everybody,

I'm trying to access a external Oracle database (dbcon entry is set successfully) and read data from a view wich does not belong to my schema. In other IDEs the statement is simple:

select *

from schema.view

In ABAP the code looks like this:

...

SELECT *

FROM ('schema.view').

...

But ABAP splits this literal into two pieces and so I get an error message view does not exist.

Any idea how to correct the FROM part?

For your information. I tried to link the view on the oracle database over a synonym to access the view in the other schema. Normally this works fine, but synonyms will not be publicated to SAP so I can't read the data furthermore.

Thx so far!

Sincerely,

Bastian

Edited by: Bastian Gröbl on Mar 13, 2008 8:56 AM

Edited by: Bastian Gröbl on Mar 13, 2008 9:21 AM

Re: Access external database views on different tablespace

Former Member — Fri, 14 Mar 2008 08:32:21 GMT

Instead of accessing the views on an different schema I created my own views.

topic Access external database views on different tablespace in Application Development and Automation Discussions

Access external database views on different tablespace

Re: Access external database views on different tablespace