Syntax error with innerjoins

Former Member — Fri, 12 Dec 2008 06:59:51 GMT

Hello,

Kinldy check the below select statement and correct the error.

Error is : You cannot compare with 'MVKE-MATNR' Each comparision in the ON condition must contain a field from the RH table.

select j_1bnflin_{werks j_1bnflin}matnr j_1bnflin~menge

j_1bnflin_{nbm j_1bnfdoc}nfnum j_1bnfdoc~series

j_1bnfdoc_{pstdat j_1bnfdoc}docnum j_1bnfdoc~parid

j_1bnflin_{itmnum j_1bnflin}statit j_1bnflin~refkey

j_1bnflin_{refitm j_1bnfdoc}branch j_1bnflin~charg

j_1bnfdoc_{nftype j_1bnflin}cfop

into table ti_aux_detalhe

from j_1bnflin

inner join nast

on j_1bnflin_{docnum = nast}objky

inner join j_1bnfdoc

on j_1bnflin_{docnum = j_1bnfdoc}docnum

inner join mara

on j_1bnflin_{matnr = mara}matnr

inner join mvke

on j_1bnflin~matnr = mvke-matnr

where j_1bnfdoc~branch in so_bran

and j_1bnflin~werks in p_centro

and mara~mtart in r_mtart.

Re: Syntax error with innerjoins

Former Member — Fri, 12 Dec 2008 07:01:41 GMT

problem is solved