Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Packets

Former Member
0 Kudos

Hi,

If I am supposed to get say 1 Million records and if application server's memory is not sufficient how can u get the records into chunk of packets ?

1 ACCEPTED SOLUTION

Vinod_Chandran
Active Contributor
0 Kudos

You may use the following example.

DATA: itab TYPE STANDARD TABLE OF SCARR WITH NON-UNIQUE

DEFAULT KEY INITIAL SIZE 10.

FIELD-SYMBOLS: <FS> TYPE scarr.

SELECT * INTO TABLE itab PACKAGE SIZE 20 FROM scarr.

LOOP AT itab ASSIGNING <FS>.

WRITE: / <FS>-carrid, <FS>-carrname.

ENDLOOP.

ENDSELECT.

3 REPLIES 3

Vinod_Chandran
Active Contributor
0 Kudos

You may use the following example.

DATA: itab TYPE STANDARD TABLE OF SCARR WITH NON-UNIQUE

DEFAULT KEY INITIAL SIZE 10.

FIELD-SYMBOLS: <FS> TYPE scarr.

SELECT * INTO TABLE itab PACKAGE SIZE 20 FROM scarr.

LOOP AT itab ASSIGNING <FS>.

WRITE: / <FS>-carrid, <FS>-carrname.

ENDLOOP.

ENDSELECT.

Former Member
0 Kudos

Hi,

If you getting records using a select statement, then use the Cursor, Fetch statement.

Thanks.

Kshitij

Former Member
0 Kudos

Hi Nitin,

Generally, the application server's memory can be considered to be virtually unlimited. However, it is the memory for the work process that will be limited. Even so, in most cases it would be capable of holding very huge volumes of data without any problem. It can even acquire additional space from the SAP Extended Memory.

The memory for a work process and the size of the Extended Memory can be configured using some profile parameters.

Are you getting any errors / short dumps because of the volume of the data? Is there a scope to improvise the logic of the program ? For example, not all of these million records may be needed. The SELECT statements can be written with more restrictive where-clause etc.,

Further troubleshooting can be given if the exact nature of your problem is known.

Regards,

Anand Mandalika.