Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

Former Member
0 Likes
330

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

1 REPLY 1
Read only

andreas_mann3
Active Contributor
0 Likes
287

How many com-codes are in t001?

try to make a loop over t001 and

select glpca for each bukrs

A.