topic Re: ABAP: OUTER JOIN in Application Development and Automation Discussions

ABAP: OUTER JOIN

vallamuthu_madheswaran2 — Mon, 25 Sep 2006 10:17:25 GMT

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 — Mon, 25 Sep 2006 10:22:32 GMT

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 — Mon, 25 Sep 2006 10:25:55 GMT

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 — Mon, 25 Sep 2006 10:28:52 GMT

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 — Mon, 25 Sep 2006 10:33:52 GMT

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.