‎2007 Jan 09 10:03 AM
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 glpcarbukrs glpcarprctr
glpcarfarea glpcaracct
glpcabudat glpcawsdat
glpcarefdocnr glpcartcur
glpcatsl t001waers
glpcahsl glpcaksl
glpca~sgtxt
into table t_output
from glpca as glpca
inner join t001 as t001
on glpcarbukrs = t001bukrs
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
‎2007 Jan 09 10:59 AM
How many com-codes are in t001?
try to make a loop over t001 and
select glpca for each bukrs
A.