topic prob on retrieving huge data in Application Development and Automation Discussions

prob on retrieving huge data

Former Member — Wed, 19 Mar 2008 08:47:46 GMT

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 — Wed, 19 Mar 2008 08:51:07 GMT

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 — Wed, 19 Mar 2008 08:53:24 GMT

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 — Wed, 19 Mar 2008 08:56:37 GMT

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.