Skip to Content
0
Former Member
Jul 06, 2006 at 09:03 PM

Problem when doing inner join for three tables....

57 Views

DATA: V3 TYPE VBAP-MAKTL.

SELECT single vbap~matkl into V3

from VBAP

inner join VBFA

inner join LIPS

on LIPSPOSNR = VBFAPOSNN

and vbapvbeln = vbfavbelv

and vbapposnr = vbfaposnv

where LIPSVBELN = VBFAVBELN = '0080000834'

and vbfa~vbtyp_n = 'J'

and LIPS~J_3ASIZE = '0884'.

Error: Wrong expression "INNER" in from clause...