get a solution for the pg.

[Former Member]

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?

by

karthi.

[Former Member]

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?

by

karthi.

[Former Member]

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.

 

[Former Member]

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.

[Former Member]

Hi

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