SELECT * FROM CATSPS INTO TABLE TCATSPS
WHERE TRANSFER = 'X' .
INTO table T_AFRU
for all entries in tcatsps
WHERE CATSBELNR = TCATSPS-BELNR
AND STOKZ = TCATSPS-STOKZ.
In the above statement, Tcatsps internal table is getting around 3 Lakh records. Becos of which when i run the second select statement, time is taken for ever.
Can I improve the performance statment of 2nd select statemtn in any other effective way.