Left join in view ?

[Former Member]

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 ?

[Former Member]

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 ?

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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,

[Former Member]

not possible in ABAP