Skip to Content
0
Mar 16, 2007 at 05:50 AM

HELP in Sql Queri... Urgent..

14 Views

Hi All,

Can anyone lemme know using this will effet to our performance ??

And the sys is throwing ' ( ' syntax error... If u have any alternative for this queri plz lemme know....

SELECT A~VBELN

A~WADAT

A~WADAT_IST

A~LFART

B~WERKS

B~MATNR

c~maktx

d~werks

INTO CORRESPONDING FIELDS OF TABLE I_LIKP

FROM ( ( ( LIKP AS A INNER JOIN LIPS AS B

on AVBELN = BVBELN where

A~LFART in S_LFART AND

A~WADAT_IST in S_WADAT AND

B~WERKS in S_WERKS )

inner join makt as c on cmatnr = bmatnr )

inner join t001w as d on dwerks = bwerks ).

if not i_likp is initial.

select e~tknum

e~vsart

f~vbeln

into corresponding fields of table i_vttk

from vttk as e inner join vttp as f

on etknum = ftknum

for all entries in i_likp where f~vbeln = i_likp-vbeln.

endif.

Regards,

Parvez.