Applying outer join in table views

[Former Member]

I am joining 3 tables. But when I join them, the system is applying inner join. i.e. if there are no entries in any of the table for given selection, no entries are populated. Whereas I want outer join i.e. if there are entries in any of the one table, they should be shown and the corresponding entries in the other tables should be blank. Is it possible to do this? Is there any setting in table dictionary or SE11 with which I can achieve this.

I tried to do this using select statement in report, but you can only join 2 tables with "left outer join". Hence it failed.

[Former Member]

I am joining 3 tables. But when I join them, the system is applying inner join. i.e. if there are no entries in any of the table for given selection, no entries are populated. Whereas I want outer join i.e. if there are entries in any of the one table, they should be shown and the corresponding entries in the other tables should be blank. Is it possible to do this? Is there any setting in table dictionary or SE11 with which I can achieve this.

I tried to do this using select statement in report, but you can only join 2 tables with "left outer join". Hence it failed.

[ThomasZloch]

DDIC database views always implement inner joins, outer join not possible. Maintenance views implement outer joins, but they cannot be used in SELECT statements.

You can left outer join multiple tables B and C to table A, but not B to A and C to B, if I remember correctly, check ABAP online help for JOIN statement.

Thomas

[former_member200392]

Hi,

Go to SE11->View->Maintainance view

you can create view with left outer join using maintainance view. Options are, you can join multiple tables to maintainance view but foriegn key relationship is mandatory between the tables. if foriegn key relationship is not exist then it will give a error while creating the view itself.

Thanks.