01-07-2010 6:42 AM
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.
01-07-2010 7:18 AM
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
01-07-2010 11:07 AM
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.
01-08-2010 5:22 AM
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.
01-08-2010 8:39 AM
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.
01-23-2010 3:48 PM
Hi,
Database view always uses inner join.
so if u want to use outer join then go for HELP VIEW.
Rgds/Abhi