Skip to Content
0
Former Member
Feb 24, 2014 at 03:58 PM

left outer join problem

18 Views

Hi all,

Below is my code:

SELECT a~column1

a~column2

b~column3

b~year

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ztab1 AS a

LEFT OUTER JOIN ztab2 AS b

ON a~column1 = b~column1 AND

a~column2 = b~column2 AND

b~year = sy-datum+0(4).

This outer join is picking all the entries where the date is '000000'.

Please let me know what is wrong.