topic Re: Left join in view ? in Application Development and Automation Discussions

Left join in view ?

Former Member — Thu, 23 Oct 2008 04:49:46 GMT

Hello expert

Can we create left join in view ?

means in view i wanna two tables in inner join

and add another table as left join

how can i do this ?

Re: Left join in view ?

Former Member — Thu, 23 Oct 2008 05:02:50 GMT

Resulting set for outer join

The outer join basically creates the same resulting set as the inner join, with the difference that at least one line is created in the resulting set for every selected line on the left-hand side, even if no line on the right-hand side fulfills the join_cond condition. The columns on the right-hand side that do not fulfill the join_cond condition are filled with null values.

So i think obviously you can use left join here for a view table...

Regards,

Arunima

Re: Left join in view ?

Former Member — Thu, 23 Oct 2008 06:35:40 GMT

Hi,

Views in the ABAP Dictionary are implemented as inner joins. If the inner table contains no lines that correspond to lines in the outer table, no data is transferred. This is not always the desired result. For example, when you read data from a text table, you want to include lines in the selection even if the corresponding text does not exist in the required language. If you want to include all of the data from the outer table, you can program a left outer join in ABAP.

Regards,

Re: Left join in view ?

Former Member — Thu, 23 Oct 2008 06:36:10 GMT

Thanks Arunima

but i think you didn' t get my question?

that i 'm creating a database view .

and i need a perticular left join in this view.

if it is possible then reply as soon as possible

Re: Left join in view ?

Former Member — Fri, 20 Mar 2009 10:03:04 GMT

not possible in ABAP