Skip to Content
avatar image
Former Member

Time out error!!

Hi Experts,

i have the following query which elapsing more time, so it is displaying time out error.

Table ZABCTABle has 10000000 records.

SELECT MATNR

          MAKTG

          MAX( PERCENT_MATCH ) AS PERCENT_MATCH

          MATKL

          MEINS

          MTART

     FROM ZABCTABLE

     INTO CORRESPONDING FIELDS OF TABLE LT_DUPLI

     WHERE (Some Condition)

     AND MATNR_STATUS NE 2

     GROUP BY MATNR MAKTG MATKL MEINS MTART.

Please any one help on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 07, 2016 at 09:16 AM

    Try below,

    • If possible avoid using INTO CORRESPONDING FIELDS, and explicitly list the fields, if there is mismatch in table fields sequence.
    • Also try to use all key fields in WHERE causes, for better indexing. "most important
    • if possible use cursors over SELECT.

    and also have a look at ABAP Performance tips - SCN Wiki

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded