Skip to Content
0
Former Member
May 14, 2008 at 08:28 AM

how to join three tables?

51 Views

I have used this query to join three tables but it displays an error : field vbak-vbeln is unknown.

please help me out..

SELECT vbak-vbeln vbak-bstnk vbap-matnr vbap-zmeng makt-maktx

INTO CORRESPONDING FIELDs OF TABLE itab FROM vbak

inner JOIN vbap ON vbak-vbeln eq vbap-vbeln

inner JOIN makt ON vbap-matnr eq makt-matnr

WHERE vbak-bstnk = s_bstnk.