select likp~mandt likp~vbeln
into ( likp-mandt, likp-vbeln )
from vbap
left outer join vbak
on
( vbak~mandt = vbap-mandt and vbak~vbeln = vbap-vbeln )
inner join vbuk
on
( vbuk~mandt = vbak-mandt and vbuk~vbeln = vbap-vbeln )
inner join vbkd
on
( vbkd~mandt = vbak-mandt and vbkd~vbeln = vbak-vbeln )
left outer join vbep
on
( vbep~mandt = vbap-mandt and vbep~vbeln = vbap-vbeln
vbep-posnr = vbap-posnr and max ( vbep~etenr ) )
inner join likp
on
likp~vbeln = vbuk~vbeln
left outer join lips
on
( lips~mandt = vbap-mandt and lips~vgbel = vbap-vbeln and
lips~vgpos = vbap-posnr )
Comma without preceding colon (after SELECT ?). 에러가 납니다 .
오류좀 찾아 주세요
조인문 수정이 필요한것 같은데요. vbak~mandt = vbap~mandt 보통 이렇게 하는걸로 알고 있는데 vbap-mandt 되어 있군요-_-;;