is it possible to join 3 tables using left and right outer joins...!

[Former Member]

hi friends,

Can any one tell is it possible to join 3 tables using left and right outer joins...i tried by taking some fields of vbap,vbak,makt but it says some error... plz give a sample code with some fields.

[Former Member]

Hi Arun

chk this statement

SELECT vbpa_{vbelnINTO TABLE itabFROM vbap LEFT JOIN vbpaON vbap}vbeln = vbpa_{vbeln AND vbap}posnr = vbpa_{posnrleft join vbkd on vbap}vbeln = vbkd~vbeln .

SELECT a_{vbeln b}posnr c~posnr

INTO TABLE gt_vbeln

FROM vbak AS a

INNER JOIN vbkd AS b ON b_{vbeln = a}vbeln

LEFT OUTER JOIN vbap AS c ON c_{vbeln = b}vbeln

AND c_{posnr = b}posnr

please reward points for helpful ans's

kiran.M

[Former Member]

but i wan only outer joins...!

[varma_narayana]

Hi..

This is the code join 3 tables using inner join.

select VBAK_{VBELN VBAK}KUNNR

VBAP_{POSNR VBAP}MATNR

MARA_{MTART MARA}MBRSH

FROM VBAK AS VBAK

INNER JOIN VBAP AS VBAP

ON VBAK_{VBELN = VBAP}VBELN

INNER JOIN MARA AS MARA

ON VBAP_{MATNR = MARA}MATNR

INTO TABLE ITAB.

<b>Reward if Helpful</b>