topic Re: RE: avoid the select statements in loop in Application Development and Automation Discussions

RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 09:41:43 GMT

Hi all,

Plz suggest me how to avoid the select statement in loop ?

any alternative is there?

loop at t_dfkkop.

clear dfkkko.

if not t_dfkkop-augbl is initial and

t_dfkkop-xragl is initial.

select single * from dfkkko

where opbel = t_dfkkop-augbl.

if sy-subrc = 0 and

dfkkko-blart = 'A3'.

delete t_dfkkop.

continue.

endif.

clear : w_augdt, w_stdat, w_process.

select max( augdt ) max( stdat )

into (w_augdt, w_stdat)

from dfkkrapt where opbel = t_dfkkop-opbel

and opupw = t_dfkkop-opupw

and opupk = t_dfkkop-opupk

and stdat ge w_clrfr

and stdat le w_clrto

group by opbel opupw opupk augdt stdat.

endselect.

Re: RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 10:17:37 GMT

outside the loop .

use for all entries for table dfkkko ....... in the loop use read statement .

like that you will populate the data.

Re: RE: avoid the select statements in loop

narin_nandivada3 — Mon, 18 Aug 2008 10:22:47 GMT

Hi,

Where exactly the ENDLOOP is placed? Can you tell that?

- Narin.

Re: RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 10:29:59 GMT

Create an internal Table it_dfkkko with ur required fields.

then

select single field

into table it_dfkkko

from dfkkko

where opbel = t_dfkkop-augbl.

loop at t_dfkkop.

if not t_dfkkop-augbl is initial and

t_dfkkop-xragl is initial.

read table it_dfkkko with key field = t_dfkkop-field.

if sy-subrc = 0 and

dfkkko-blart = 'A3'.

delete t_dfkkop.

continue.

endif.

clear : w_augdt, w_stdat, w_process.

select max( augdt ) max( stdat )

into (w_augdt, w_stdat)

from dfkkrapt where opbel = t_dfkkop-opbel

and opupw = t_dfkkop-opupw

and opupk = t_dfkkop-opupk

and stdat ge w_clrfr

and stdat le w_clrto

group by opbel opupw opupk augdt stdat.

endselect.

Re: RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 10:34:03 GMT

Hi,

Please add

select single field

into table it_dfkkko

from dfkkko

for all entries in table t_dfkkop

where opbel = t_dfkkop-augbl.

Re: RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 11:13:20 GMT

really your reply helps me a lot.

Thank you for your due response.

Regards,

sam.

Re: RE: avoid the select statements in loop

Former Member — Mon, 18 Aug 2008 11:32:52 GMT

After the endselect two performs are there ,in these performs also too many select statements are used ,but those taking less time.

after that ENDLOOP is there.

Re: RE: avoid the select statements in loop

Former Member — Wed, 20 Aug 2008 18:04:00 GMT

Have you solved the issue?

Re: RE: avoid the select statements in loop

Former Member — Fri, 29 Aug 2008 07:17:10 GMT

not yet solved.