Skip to Content
0
Former Member
Sep 30, 2005 at 09:20 AM

Time limit exceeded ?

69 Views

Hi Everyone,

I am trying the following code which runs in debug mode but when I execute program without debugging mode it is giving short dump.

The message statement in the code outputs message in debug mode but not in normal one.

Earier it was giving "sql statement too large" error thats why I have broken it into pieces still it is giving timeout.

T_MARA & T_VENDOR are the internal tables that contains values to select from EINA (Info records).

*********************************************************

DO.

REFRESH S_MATNR.

S_MATNR-SIGN = 'I'.

S_MATNR-OPTION = 'EQ'.

LOOP AT T_MARA FROM INDEX_FROM TO INDEX_TO.

S_MATNR-LOW = T_MARA-MATNR.

APPEND S_MATNR.

ENDLOOP.

SELECT * FROM EINA APPENDING TABLE T_EINA

WHERE MATNR IN S_MATNR

AND LIFNR IN S_LIFNR

AND LOEKZ EQ ' '.

INDEX_FROM = INDEX_TO + 1.

IF INDEX_FROM > MAXLINE.

EXIT.

ENDIF.

INDEX_TO = INDEX_TO + 1000.

<b>MESSAGE</b> S005(ZSRS) WITH 'selecting records from ' INDEX_FROM ' to '

INDEX_TO.

ENDDO.

*******************************************************

This is somewhat urgent.

Thanks & Regards,

Ankur