topic Re: SELECT in Application Development and Automation Discussions

SELECT

Former Member — Tue, 19 Jun 2007 09:41:57 GMT

i have one select stm which comprises many join stms

due to this performances is degrading .

i need to split this .plz tell me how to do it.

select vlpma~matnr
lips~werks
lips~lfimg
lips~umvkz
lips~umvkn
lips~vbeln
lips~posnr
lips~meins
lips~vrkme

lips~vgbel
vbap~kzwi2
vbap~klmeng
kna1~name1

from vlpma
join vbuk
on vbuk_{vbeln = vlpma}vbeln
join lips
on lips_{vbeln = vlpma}vbeln and
lips_{posnr = vlpma}posnr

join kna1
on vlpma_{kunag = kna1}kunnr
join vbap
on lips_{vgbel = vbap}vbeln
and lips_{vgpos = vbap}posnr
into table it_assigned
for all entries in i_marc
where vlpma~matnr = i_marc-matnr
and vlpma~lfart in s_lfart
and vbuk~wbstk <> 'C'

AND lips~werks = i_marc-werks .

and lips~werks in s_werks
and lips~bwart <> '641'.

regards,

lokesh.

Re: SELECT

Former Member — Tue, 19 Jun 2007 09:43:42 GMT

Hi,

Go for FOR ALL ENTRIES statement instaed of INNER JOINS.

Revert back if any issues,

Reward with points if helpful ,

Regards,

Naveen

Re: SELECT

Former Member — Tue, 19 Jun 2007 09:45:40 GMT

HI,

Split the select statement and use FOR ALL ENTRIES statements instead of using joins to improve performance. Check whether the Internal table that you are making use in your select statement is empty or not...

i.e,

 if not itab[] is initial.

 
 endif.

Re: SELECT

Former Member — Tue, 19 Jun 2007 09:49:08 GMT

please give me the total answer.

i dont know how to use for all entries .

please give the code.

Re: SELECT

Former Member — Tue, 19 Jun 2007 10:02:40 GMT

Hi,

I guess u will have to create separate internal tables and den fetch the header level data initially..den using FOR ALL ENTRIES u can fetch the complete data. Refer to Help for usage of FOR ALL ENTRIES

Message was edited by:

nirav goradia