topic Re: statement construction in Application Development and Automation Discussions

statement construction

Former Member — Thu, 13 Sep 2007 03:59:57 GMT

i have written sql like this, program is running for hour, andw heni run se30 it showed the program is taking lion's share of runtime. how to tune this statement?

SELECT vbeln

wadat

FROM likp

INTO TABLE t_likp

FOR ALL ENTRIES IN t_vbak

WHERE vkorg = t_vbak-vkorg

AND kunag = t_vbak-kunnr

AND wadat_ist IN so_budat.

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:06:23 GMT

Your select statement takes long time to execute

because you are not using the key fields to retrive the data

in likp key fields are vbeln(delivery number)

If there is no way to get the delivery number

try creating the secondary index for the fields you are using to retrive the data

if you do not use key fields the selects will be costly selects

Regards,

siva

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:14:50 GMT

Hi Nihi,

What are the contents of the table t_vbak and if you have vbeln in that then you can reconstruct your select statement as follows:

SELECT vbeln

wadat

FROM likp

INTO TABLE t_likp

FOR ALL ENTRIES IN t_vbak

WHERE vbeln = t_vbak-vbeln

and vkorg = t_vbak-vkorg

AND kunag = t_vbak-kunnr

AND wadat_ist IN so_budat.

Check this.

Reward if helpful.

Regards,

Ravi G

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:17:05 GMT

Hi Siva,

I am here trying to get the delivery number from LIKP.

I executed the table through se16 by passing the same parameters as in program and i got the out put very fast...

I guess LIKP is very fast if we pass sales org and customer date range...

I will try creating the indexes but not very comfortable in creating them..

Thanks alot for the reply

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:23:49 GMT

IF NOT T_VBAK[] IS INITIAL.

SORT T_VBAK by VKORG KUNAG.

SELECT vbeln

wadat

FROM likp

INTO TABLE t_likp

FOR ALL ENTRIES IN t_vbak

WHERE vkorg = t_vbak-vkorg

AND wadat_ist IN so_budat

AND kunag = t_vbak-kunnr.

ENDIF.

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:24:06 GMT

Hi Ravi,

I don't think it will work,,

vbak-vbeln is sales doc where as likp-vbeln is delivery note

Re: statement construction

Former Member — Thu, 13 Sep 2007 04:41:23 GMT

Hi prashanth,

Isuue resolved.. offcoursw other elements in my program which i rectified them too..

But your suggestion worked..awarding points to you

Thanks all..