topic Re: Create database view with outer join in Application Development and Automation Discussions

Create database view with outer join

Former Member — Thu, 07 Jan 2010 06:42:26 GMT

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.

Re: Create database view with outer join

Former Member — Thu, 07 Jan 2010 07:18:37 GMT

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

Re: Create database view with outer join

Former Member — Thu, 07 Jan 2010 11:07:06 GMT

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.

Re: Create database view with outer join

Former Member — Fri, 08 Jan 2010 05:22:07 GMT

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.

Re: Create database view with outer join

Former Member — Fri, 08 Jan 2010 08:39:54 GMT

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.

Re: Create database view with outer join

Former Member — Sat, 23 Jan 2010 15:48:36 GMT

Hi,

Database view always uses inner join.

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

Rgds/Abhi