i have a requirement where I need to include 2 country code .
so in selection screen s_bukrs has AU00 - AU99 & NZ00 -NZ99
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.
Is there any best approach to AVOID LOOP INSIDE FOR ALL ENTRIES...any alternative approach to have good performance
APPRECIATE UR HELP