ABAP: OUTER JOIN

[vallamuthu_madheswaran2]

Hi friends,

i want the correct syntax of the following query

SELECT A_{BEDAT A}EBELN B_{matkl B}WERKS B_{MATNR B}TXZ01 A_{RESWK B}MENGE B~EBELP

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM EKKO AS A INNER JOIN EKPO AS B ON A_{EBELN = B}EBELN

WHERE a~reswk IN SUP_PLNT

and A~BEDAT IN STO_DATE

AND B~MATKL IN mat_grp

AND B~MATNR IN MAT_CODE

AND A~BSART = 'KRUB'.

thanks & regards

vallamuthu.M

[Former Member]

The code looks to be fine..are you getting any error ??

Secondly, you specified the topic for Outer join and ur code is for inner join ..can you please give the exact issue.

[vallamuthu_madheswaran2]

HI,

SORRY, THE BELOW QUERY IS THE CORRECT QUERY PLEASE HELP ME.

SELECT A_{BEDAT A}EBELN B_{matkl B}WERKS B_{MATNR B}TXZ01 A_{RESWK B}MENGE B~EBELP

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM EKKO LEFT OUTER JOIN EKPO ON A_{EBELN = B}EBELN

WHERE a~reswk IN SUP_PLNT

and A~BEDAT IN STO_DATE

AND B~MATKL IN mat_grp

AND B~MATNR IN MAT_CODE

AND A~BSART = 'KRUB'.

[Former Member]

U cannot use filters for fields from the right table..In your case EKPO.

So if you <b>take out the filters for maktl and matnr</b> it should work...surely you can apply the same filter later on to the internal table.

[Former Member]

Hi,

Just change the bold code and check.

SELECT A_{BEDAT A}EBELN B_{matkl B}WERKS B_{MATNR B}TXZ01 A_{RESWK B}MENGE B~EBELP

INTO CORRESPONDING FIELDS OF TABLE ITAB

<b>FROM EKKO as A LEFT OUTER JOIN EKPO as B</b> ON A_{EBELN = B}EBELN

WHERE a~reswk IN SUP_PLNT

and A~BEDAT IN STO_DATE

AND B~MATKL IN mat_grp

AND B~MATNR IN MAT_CODE

AND A~BSART = 'KRUB'.

Hope this helps.