Hi Experts
I'm trying to write code for datasource enhancement and using select with left outer join.
But issue is there is record in left table with id equal to "X" and not in write table my select is not picking up the record. As part of this I need to pick the record in main table even if no entries in write table. Not sure whats the issue here,posting code below
SELECT * INTO CORRESPONDING FIELDS OF
TABLE ITAB
FROM main table AS m left outer join second table AS s ON
m~id = s~id where m~inum NE ''.
Please help if you could.
Thanks