prob on retrieving huge data

[Former Member]

hi,

this is vincent here i have a problem on retrieving more than 5000 or 10000 material data on se16 transaction pls provide me some guidelines.

i tried using MARA table it goes for dump.

[Former Member]

Hi Vincent,

u can use T-code se16n & se11 For getting related data.

try to retrieve data in small Group say one time Extract 250 data then again retrieve 250 data in chain.

this won't gwt Dump.

if u will retrieve Huge amt of data then it w'd give Dump.

Hope it helps u...!!!

Pls reward if helpful...!!!

[Former Member]

Hi

It is because of the load on the server if the data is huge in the table

try to use more fields in selection criteria to get it fastly

Regards

Shiva

[Former Member]

Hi Vincent,

u can use T-code se16n & se11 For getting related data.

try to retrieve data in small Group say one time Extract 250 data then again retrieve 250 data in chain.

this won't gwt Dump.

if u will retrieve Huge amt of data then it w'd give Dump.

Hope it helps u...!!!

Pls reward if helpful...!!!

[Former Member]

hi,

retrieve the data as small small chunks using the following syntax.

SELECT ... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab [PACKAGE SIZE n] ...

it will solve ur problem.