Skip to Content
0
Former Member
Jun 05, 2009 at 08:52 AM

Time out error while fetching records from table BKPF

126 Views

Hi,

I am fetching records from table BKPF using BUKRS & AWKEY in where clause. Query is as follows:

SELECT BELNR XBLNR AWKEY

FROM BKPF

INTO TABLE L_I_BKPF_TEMP

PACKAGE SIZE 500

WHERE BUKRS LIKE L_C_EG

AND AWKEY IN L_R_AWKEY .

APPEND LINES OF L_I_BKPF_TEMP TO I_BKPF .

ENDSELECT .

Program is giving time out error. There are 25628 records in range L_R_AWKEY , i m fetching 500 records at a time using PACKAGE SIZE. But the execution of prog stops on this query.

Please suggest something to overcome this problem.