Error showing while left join

[Former Member]

Dear expert,

can we use both sides table in where condition of any

outer join?

can you give me an example.

i want to create one left join for one view and one std. table.

i want to give some condition for both table , and it is depended on selection critera.

but it is giving error to me that can not use right side table in left outer join.

when i remove left join and put inner joint it's worked or when i put comment on tht perticular critrea then also it works but when i put that condition with outer joins then it will work.

please help me.

thanks

[Former Member]

Dear expert,

can we use both sides table in where condition of any

outer join?

can you give me an example.

i want to create one left join for one view and one std. table.

i want to give some condition for both table , and it is depended on selection critera.

but it is giving error to me that can not use right side table in left outer join.

when i remove left join and put inner joint it's worked or when i put comment on tht perticular critrea then also it works but when i put that condition with outer joins then it will work.

please help me.

thanks

[Former Member]

>

>can not use right side table in left outer join. 
>

Unfortunatly it is true and is limitation of ABAP Left Outer Join.

(Oracle, SQL Server 2000/2005, etc database Native SQL outer join statement supports this)

You need to loop through the internal table to further

filter records based on right side table.

Regards,

Vishal

[Former Member]

not possible in ABAP