03-19-2008 8:47 AM
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.
03-19-2008 8:53 AM
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...!!!
03-19-2008 8:51 AM
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
03-19-2008 8:53 AM
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...!!!
03-19-2008 8:56 AM
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.