Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Create database view with outer join

Former Member
0 Kudos

Hello Experts,

I have created a database view but couldnu2019t specify outer join conditionu2026 How to create view with using outer join? Please suggest meu2026.

Thanks.

5 REPLIES 5

Former Member
0 Kudos

Hi Vickee,

i think we can only create inner join condition in Database view

Regards,

Kumar M.

Edited by: Kumar M on Jan 7, 2010 8:39 AM

0 Kudos

Dear Sir,

You can only create databse view with inner join. But if you want to create a view with outer join you can create maintainence view for the same. Moreover, it is not recommended to use outer join in the view due to data inconsistency might raise in the Database.

Regards,

Kapil.

Former Member
0 Kudos

Hi,

A Database View always implements an Inner Join. If it is made from only a single table, then you can use it for maintainance also. But if you use a Maintainance View, then it implements an Outer Join.

Have a look at the following link

http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

Hoe this will help.

Thanks,

Samantak.

Former Member
0 Kudos

Hello,

Please go through the link below, it describes you about using joins in view.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/cf/21ed2d446011d189700000e8322d00/frameset.htm

Regards,

Varun.

Former Member
0 Kudos

Hi,

Database view always uses inner join.

so if u want to use outer join then go for HELP VIEW.

Rgds/Abhi