topic Re: tunning during selection in Application Development and Automation Discussions

tunning during selection

Former Member — Wed, 03 Dec 2008 03:04:21 GMT

Hi Experts,

I have wrote a select statement as below and basically it is taking a lot of time to execute this particular statement.

Can anyone guide me to make the below statement to execute faster.

i_vbfa = standard table

i_likp_lips = standard table

SELECT vbelv posnv vbeln posnn

FROM vbfa INTO TABLE i_vbfa

FOR ALL ENTRIES IN i_likp_lips

WHERE vbeln EQ i_likp_lips-vbeln AND

posnn EQ i_likp_lips-posnr AND

vbtyp_n IN s_vbtypn AND

vbtyp_v IN s_vbtypv.

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 03:15:51 GMT

If not i_likp_lips[] is initial.

SELECT vbelv posnv vbeln posnn

FROM vbfa INTO TABLE i_vbfa

FOR ALL ENTRIES IN i_likp_lips

WHERE vbeln EQ i_likp_lips-vbeln AND

posnn EQ i_likp_lips-posnr AND

vbtyp_n IN s_vbtypn AND

vbtyp_v IN s_vbtypv.

Endif.

Second just check the the Secondary index .

I think if you create secondary index on the fileds you mentioned it will be much faster.

Regards

Neha

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 03:17:59 GMT

HI Neha,

Sorry what is the meaning with secondary index.

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 03:27:13 GMT

Hi saravannan sithambaram,

Wht do you mean by standard tables, Try to post how did You declare the two internal tables and wht fields do they contain.

And what values are You giving input to s_vbtypn and s_vbtypv.

And how are you selecting data fo i_likp_lips.

Thanks,

Edited by: Suneel Kumar Gopisetty on Dec 3, 2008 11:27 AM

Re: tunning during selection

JoffyJohn — Wed, 03 Dec 2008 03:30:08 GMT

Rather than doing manipulation directly in table

Get the content of VBFA table based on

vbtyp_n IN s_vbtypn AND

vbtyp_v IN s_vbtypv.

into an internal table and then manipulate that internal table data.

As it takes less take.

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 03:37:57 GMT

Hi saravannan sithambaram ,

In your where condition change as follows :

VBFA-VBELV should be EQ likp_lips-VBELN

VBFA-POSSV should be EQ likp_lips-POSSN.

WHERE vbelv EQ i_likp_lips-vbeln AND

posnv EQ i_likp_lips-posnr AND

vbtyp_n IN s_vbtypn AND

vbtyp_v IN s_vbtypv.

Regards,

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 04:19:58 GMT

Hi ...

Have able to Tune Your Statement.

Regards,

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 06:23:58 GMT

Hi Suneel,

I have tried but it seems not wroking fine.

Re: tunning during selection

Former Member — Wed, 03 Dec 2008 06:26:31 GMT

Hi,

Create a secondary index for your table using the fields

on which you are placing the selection criterion.

Regards,

Rajat

Re: tunning during selection

Former Member — Tue, 20 Jan 2009 09:32:15 GMT

thanks everyone