Skip to Content
0
Former Member
Dec 18, 2006 at 08:57 AM

ABAP select statements takes too long

638 Views

Hi,

I have a select statement as shown below.

SELECT * FROM BSEG INTO TABLE ITAB_BSEG

WHERE BUKRS = CO_CODE

AND BELNR IN W_DOCNO

AND GJAHR = THISYEAR

AND AUGBL NE SPACE.

This select statement runs fine in all of R/3 systems except for 1. The problem that is shown with this particular system is that the query takes very long ( up to an hour for if W_DOCNO consists of 5 entries). Sometimes, before the query can complete, an ABAP runtime error is encountered as shown below:

<b>Database error text........: "ORA-01555: snapshot too old: rollback segment

number 7 with name "PRS_5" too small?"

Internal call code.........: "[RSQL/FTCH/BSEG ]"

Please check the entries in the system log (Transaction SM21). </b>

Please help me on this issue. However, do not give me suggestions about selecting from a smaller table (bsik, bsak) as my situation does not permit it.

I will reward points.