Skip to Content
0
Former Member
Feb 18, 2010 at 12:06 AM

How to handle Loop within Select For all entries

23 Views

hi all,

i have a requirement where I need to include 2 country code .

so in selection screen s_bukrs has AU00 - AU99 & NZ00 -NZ99

select countrycode

from ZCTYCOD

into table lt_zctycod

where ( land1 ge s_bukrs-low(02) AND

land1 Le s_bukrs-HIGH(02).

SO countrycode entries r in table lt_zctycod.

Now I need to loop into this SELECT ...FOR ALL ENTRIES....

LOOP AT LT_ZCTCOD.

SELECT * FROM zbase

APPENDING TABLE ts_base

FOR ALL ENTRIES IN ts_zdocket

WHERE zzumicur = ts_docket-zzumicur AND

( status = c_rej OR

status = c_sus ) AND

CTYCOD = LT_ZCTCOD-Ctycod.

ENDIF.

Is there any best approach to AVOID LOOP INSIDE FOR ALL ENTRIES...any alternative approach to have good performance

APPRECIATE UR HELP

THANKS