SE11 view with outer-join condition

[Former Member]

Hi,

We have a requirement to create a view on a couple of tables. This view is used as a flat table to extract data from BW using Informatica.

Is there any way we can create a view with 'outer join' conditions?

I think mantenance view, help view, and projection view are out of question. The only type of view we need to create is 'database view.

Is there anyway to create this view with outer join using ABAP? By default a database view is always inner join.

If there is no way to create a view using the 4 types avialable in SE11, is there any other option?

thanks

Gova

[Former Member]

Hi,

We have a requirement to create a view on a couple of tables. This view is used as a flat table to extract data from BW using Informatica.

Is there any way we can create a view with 'outer join' conditions?

I think mantenance view, help view, and projection view are out of question. The only type of view we need to create is 'database view.

Is there anyway to create this view with outer join using ABAP? By default a database view is always inner join.

If there is no way to create a view using the 4 types avialable in SE11, is there any other option?

thanks

Gova

[Former Member]

Moderator message - Welcome to SCN. But please note that cross posting the same question in different forums is not allowed.. Also, Please read and and [Asking Good Questions in the Forums to get Good Answers|/people/rob.burbank/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers] before posting again. Thread locked. Rob