Skip to Content
0
Former Member
Oct 16, 2006 at 09:43 AM

Performance select statement

23 Views

SELECT * FROM CATSPS INTO TABLE TCATSPS

WHERE TRANSFER = 'X' .

SELECT RUECK

STOKZ

CATSBELNR

FROM AFRU

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.

Thanks

Regds

Venu