topic Re: get a solution for the pg. in Application Development and Automation Discussions

get a solution for the pg.

Former Member — Fri, 22 Feb 2008 07:50:14 GMT

data : begin of itab occurs 0,

mblnr like mseg-mblnr,

menge like mseg-menge,

meng1 like ekpo-menge,

end of itab.

select a_{mblnr a}menge b~menge into corresponding fields of

table itab from mseg as a inner join ekpo as b on b_{ebeln = a}ebeln.

loop at itab.

write 😕 itab-mblnr,itab-menge,.

endloop.

i cant get the value for the meng1 field, why?

karthi.

Re: get a solution for the pg.

Former Member — Fri, 22 Feb 2008 07:55:38 GMT

remove corresponding fields of and give into table


select a~mblnr a~menge b~menge into 
table itab from mseg as a inner join ekpo as b on b~ebeln = a~ebeln.

loop at itab.
write :/ itab-mblnr,itab-menge,.
endloop.

Re: get a solution for the pg.

Former Member — Fri, 22 Feb 2008 07:57:40 GMT

Fristly when you are using CORRESPONDING FIELDS OF, it expects same field name in database table and internal table. In your case MENGE is database table field whereas in internal table it is MENGE1, both do not match so MENGE1 will not be populated. Remove CORRESPONDING FIELDS OF from your statement. Next this statement will execute forever as you are retreiving with conditions andMSEG consists huge data. Try to optimize SELECT query for better performance.

Re: get a solution for the pg.

Former Member — Fri, 22 Feb 2008 07:59:39 GMT

Try like this..

select a~mblnr

a~menge

b~menge AS menge1

into corresponding fields of

table itab

from mseg as a

inner join

ekpo as b

on a_{ebeln = b}ebeln.

Let us know then..

Thanks . Praveen