Skip to Content
0
Jul 22, 2008 at 02:45 PM

problem with select query

25 Views

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.