SELECT MATNR
MEINS
FERTH
FROM MARA
INTO TABLE GT_CMATNR
FOR ALL ENTRIES IN GT_FERTH
WHERE ( MTART EQ 'HALB' OR MTART EQ 'FERT' ) AND
FERTH EQ GT_FERTH-FERTH AND
SPART = '27'.
The above select query fetches more than 100,000 records and is giving a short dump.... how can i improve the performance of this one.