Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select Query !!!

Hi All,

Consider the following scenario.

A select query has to select very large amount of data from the table ( based on some condition ).

Now, because of that and also because of time taken in the network communication, the program is getting timed-out.

Is there any way in which we can select the data in <b>PACKETS</b> from the table WITHOUT CHANGING THE SELECT QUERY i.e. WITHOUT CHANGING THE WHERE CLAUSE ETC.

I repeat the requirement once more:

There should be no change in the select query except few minor changes which might be needed in the same as a part of the syntax.

Regards

Anshul

Tags:
replied

Hi anshul,

1. U already have the answer.

2. The syntax is also very simple.

3. Just copy paste to get a taste of it.

4.

REPORT abc.

DATA : t001 LIKE TABLE OF t001 WITH HEADER LINE.

DATA : ctr TYPE i.

*----


selection screen.

PARAMETERS : a TYPE c.

*----


START-OF-SELECTION.

<b>SELECT * FROM t001

INTO TABLE t001

PACKAGE SIZE 5 .</b>

ctr = ctr + 1.

WRITE :/ '----


Loop Pass # ' , ctr.

LOOP AT t001.

WRITE :/ t001-bukrs , t001-butxt.

ENDLOOP.

ENDSELECT.

regards,

amit m.<b></b>

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question