topic SE11 view with outer-join condition in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/se11-view-with-outer-join-condition/m-p/6965135#M1490390 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Is there any way we can create a view with 'outer join' conditions?</P><P></P><P>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.</P><P></P><P>Is there anyway to create this view with outer join using ABAP? By default a database view is always inner join.</P><P></P><P>If there is no way to create a view using the 4 types avialable in SE11, is there any other option?</P><P></P><P>thanks</P><P>Gova</P></BODY></HTML> Mon, 14 Jun 2010 20:05:39 GMT Former Member 2010-06-14T20:05:39Z SE11 view with outer-join condition https://community.sap.com/t5/application-development-and-automation-discussions/se11-view-with-outer-join-condition/m-p/6965135#M1490390 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Is there any way we can create a view with 'outer join' conditions?</P><P></P><P>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.</P><P></P><P>Is there anyway to create this view with outer join using ABAP? By default a database view is always inner join.</P><P></P><P>If there is no way to create a view using the 4 types avialable in SE11, is there any other option?</P><P></P><P>thanks</P><P>Gova</P></BODY></HTML> Mon, 14 Jun 2010 20:05:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/se11-view-with-outer-join-condition/m-p/6965135#M1490390 Former Member 2010-06-14T20:05:39Z Re: SE11 view with outer-join condition https://community.sap.com/t5/application-development-and-automation-discussions/se11-view-with-outer-join-condition/m-p/6965136#M1490391 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="green" __jive_macro_name="color">Moderator message - Welcome to SCN. But please note that cross posting the same question in different forums is not allowed.. Also, Please read <SPAN __jive_macro_name="thread" id="927634"></SPAN> and <SPAN __jive_macro_name="thread" id="1170968"></SPAN> 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</SPAN></P></BODY></HTML> Mon, 14 Jun 2010 20:42:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/se11-view-with-outer-join-condition/m-p/6965136#M1490391 Former Member 2010-06-14T20:42:49Z