NESTED SELECT STATEMENTS
Instead of nested SELECT statements the joins INNER or OUTER should be used or VIEWS should be created in ABAP
DICTIONARY if possibel another
alternative is to use
FOR ALL ENTRIES IN itab
If we use FOR ALL ENTRIES IN itab , care should be taken that it is not
empty otherwise DBMS will return all the rows from the table specified
in the FROM clause of SELECT statement .