How can I crate a view with tables which require "Left outer join"?

[Former Member]

Hi guys,

how can I define a view with tables which require "Left outer join"?. In SE11 "View",->tab "Join condition", it seems that it valid only for "Inner Join".

Please give me some hint.

Thanks in advance.

Regards,

Liying

[Former Member]

There are four kind of view which uses parituclar type of joins ...

for eg

Database view/ normal view.. and projection view uses inner join .. where as maintanence view and help view uses outerleft join.. each view have some specific use.. but you can use all of them to fetch data in you program..

No Rewards Plz..

[Former Member]

Hi,

You can use Inner join and use the condition to link the tables.

Thanks,

Sriram Ponna.

[Former Member]

Thanks.

But I have to define "Left Outer Join" using SE11, without using porgram? Is it possible?

Regards,

[Former Member]

Hi

Inner Join and Outer Join 

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.

With an inner join, you only get the records of the cross-product for which there is an entry in all tables used in the view.

With an outer join, records are also selected for which there is no entry in some of the tables used in the view. (ABAP allows left outer join.)

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.

[Former Member]

yes you can do it without the program codes..

so if u want to create a view with a outer join select maintainence view or help view. when you enter the view name in se11 and click create.. system will give you option of 4 view type select maintainence or help view

regards

No Rewards Plz..

[Former Member]

The view I defined is DB View.

As the SAP help Dokument mentions, DB View can not build LEFT OUT JOIN. So i have to use "User Exit" to load my

data from the third table. I have not used the "User Exit" for that, can anynbody give me some hint for that?

Thanks a lot!