topic Select query and join's in Application Development and Automation Discussions

Select query and join's

Former Member — Thu, 20 Nov 2008 06:10:34 GMT

Hi All,

I had to modify the current select query coz its taking a lot of database time, please suggest the best solution for the below.

SELECT mseg_{bukrs mkpf}budat mkpf~bldat

mseg_{ebeln mkpf}xblnr mseg~mblnr

mseg_{mjahr mseg}zeile mseg~xauto

mseg_{parent_id mseg}werks mseg~umwrk

mseg_{umlgo mseg}parent_id ekko~reswk

mseg_{werks mseg}lgort mseg~matnr

mseg_{erfmg mseg}erfme mseg~shkzg

mseg_{sjahr mseg}smbln mseg~smblp

mseg_{charg ekko}bedat

INTO TABLE g_tbl_main

FROM mkpf JOIN mseg

ON mkpf_{mandt = mseg}mandt AND

mkpf_{mblnr = mseg}mblnr AND

mkpf_{mjahr = mseg}mjahr

JOIN ekko ON mseg_{mandt = ekko}mandt AND

mseg_{ebeln = ekko}ebeln

JOIN likp ON mkpf_{xblnr = likp}vbeln

CLIENT specified

WHERE mkpf~mandt = sy-mandt AND

mkpf~budat IN s_budat AND

ekko~bedat IN s_bedat AND

mseg~ebeln IN s_ebeln AND

mkpf~xblnr IN s_vbeln AND

likp~vstel IN s_vstel AND

ekko~reswk IN s_reswk AND

mseg~werks IN r_werks AND

mseg~lgort IN s_lgort AND

mseg~matnr IN s_matnr AND

mseg~smbln = space AND

mseg~bwart IN s_bwart AND

mseg~kzzug = c_true.

Re: Select query and join's

Former Member — Thu, 20 Nov 2008 06:15:40 GMT

Split the select query and use the for all entries..this will improve the preformence....

Re: Select query and join's

Former Member — Thu, 20 Nov 2008 06:19:40 GMT

Yes, avinash said rightly.

there is another way bit diffict.

use the indexes properly as available in the mseg table and mkpf table even then it is diffcult

else try using BAPI.

some bapi will give the entire details of the MATERAIL DOCUMENT

go to BAPI explorer tcode BAPI.

where you can find the BAPI name like the 'GET_LIST'.

Try this.

hope this will serve your purpose.

Thanks and regards

Ramchander Rao.K

Re: Select query and join's

Former Member — Thu, 20 Nov 2008 06:21:46 GMT

Hi,

Split of the query and then use the for all entries concept.

While using the for all entries concept be aware that you are using the proper indexes.

thanks & Regards

Re: Select query and join's

SujeetMishra — Thu, 20 Nov 2008 06:37:13 GMT

Hi soyunee,

Please take seperate Internal table for each table. and select appropriate fields into same respective internal table.

then take one it_final, final internal table with all these fields for output.

and pass your all internal tables value to it_final in loop.

Regards,

sujeet

Re: Select query and join's

Former Member — Tue, 25 Nov 2008 06:17:42 GMT

Hi all,

I just want to make sure if i can join EKKO and LIKP ,