How to use sub select & left outer join?

[Former Member]

I'm trying to perform the below sql-statement:

But there I got a syntax error on line 43, which says the select statement is not allowed here.

I tried also

the error message says "SELECT" is in ABAP-Dictionay not as table, projection or db-view declaerd. Finally I modified the sql statement as below

and got the error message: 'JOIN' was expected here.

How can sub select be used after a left outer join or inner join statement as table correctly?

[Ankit_Maskara]

Select...Endselect construct is not advised to be used due to performance issues.

Instead, refactor as below-

1. Fetch data from VBRL in an internal table with a where condition matching your requirement.

2. Fetch all records from VBRK table with a where condition matching your requirement.

3. Loop at the result table of step2.

4. Inside the loop at step 3, put a loop at table of step 1 and pick the requisite records with condition similar to where clause of JOIN.

5. Create a final table(similar to l_it_fakbuch) and use.

* You can also try implementing parallel cursor based on nature of data.