Skip to Content
0
Former Member
Sep 14, 2009 at 11:08 AM

TIME-OUT error in BSAK select query(Progress Indicator is also used)

64 Views

Hi,

In my report program one select query is there on BSAK table, which is as follows --

SELECT BUKRS

BELNR

GJAHR

SHKZG

BSCHL

UMSKZ

LIFNR

EBELN

EBELP

WRBTR

DMBTR

XZAHL

REBZG

AUGBL

BLART

AUFNR

AUGDT

BUZEI FROM BSAK

INTO TABLE IT_BSAK

FOR ALL ENTRIES IN IT_BKPF1

WHERE BUKRS = IT_BKPF1-BUKRS

AND AUGDT = IT_BKPF1-BUDAT

AND AUGBL = IT_BKPF1-BELNR

AND BSCHL IN ('31' , '29', '26', '39', '25').

I used Progress Indicator befor running this query and after this query also. But still It's giving me TIME-OUT error in this select query only.

I run the same query for 10 records in IT_BKPF1 table, it runs perfectly. But when I run it for 1000 records it giving dump.

And in actual bussiness my records are always more than 100 only.

I also check the indexing. It having secondary indexing on this BUKRS, AUGDT, AUGBL fields. Then also it's giving error.

so, How can I solve this dump..?? What could be the reason..??

Thanks in advance...!!

Regards,

Poonam.