how to resolve the memory issue while retrieving the data from data base t

Former Member — Tue, 09 Jan 2007 10:03:58 GMT

when i am retrieving the data from GLPCA table into internal table i am getting the error is memory is not avilable. while i executed the program in background and foreground also. can send the sample code.my code is

if read_db = 'X'. "Inserted - ITG #48124

select glpca_{rbukrs glpca}rprctr

glpca_{rfarea glpca}racct

glpca_{budat glpca}wsdat

glpca_{refdocnr glpca}rtcur

glpca_{tsl t001}waers

glpca_{hsl glpca}ksl

glpca~sgtxt

into table t_output

from glpca as glpca

inner join t001 as t001

on glpca_{rbukrs = t001}bukrs

where glpca~kokrs = p_kokrs

and glpca~ryear in s_ryear

Index 1 Conditions

and glpca~rprctr in s_rprctr

and glpca~rvers in s_rvers

and glpca~racct in s_racct

Index 7 Conditions

and glpca~rhoart in s_rhoart

and glpca~activ in s_activ

and glpca~poper in s_poper

and glpca~rbukrs in s_rbukrs

and glpca~rfarea in s_rfarea

and glpca~budat in s_budat

and glpca~rrcty in s_rrcty

and glpca~rtcur in s_rtcur.

endif. "Inserted - ITG #48124

Re: how to resolve the memory issue while retrieving the data from data base t

andreas_mann3 — Tue, 09 Jan 2007 10:59:49 GMT

How many com-codes are in t001?

try to make a loop over t001 and

select glpca for each bukrs

topic how to resolve the memory issue while retrieving the data from data base t in Application Development and Automation Discussions

how to resolve the memory issue while retrieving the data from data base t

Re: how to resolve the memory issue while retrieving the data from data base t