Skip to Content
0
Sep 25, 2006 at 10:17 AM

ABAP: OUTER JOIN

96 Views

Hi friends,

i want the correct syntax of the following query

SELECT ABEDAT AEBELN Bmatkl BWERKS BMATNR BTXZ01 ARESWK BMENGE B~EBELP

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM EKKO AS A INNER JOIN EKPO AS B ON AEBELN = BEBELN

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