OUTER JOIN

[Former Member]

Hi to all

can i use left outer join n then use for all entries to fetech the rest of the data. i am developing sales register report ( i.e. complete flow ) contract -> sales order - > delivery - > token - > pgi -- > invoice. the problem is if i populate contract first in itab then i can not insert multiple Sales order against those contract. so in this case can i use outer join or is there any other way to resolve this problem.

thnx

Fozia

[Former Member]

Hi,

Make sure u'll get the necessary data use left outer join- specify the condition properly. and u can as well join the table to get all the relevant data in one step, instead of having for all entries.

regards,

madhu