select query

[former_member598001]

hi experts, needed a quick solution . i have an internal table it_data and filled the data from view using select query. and i need to add one more field to it_data from ekpo. please let me know how to do it.

[former_member683273]

Hi Karon,

you can use INTO CORRESPONDING FIELDS OF TABLE option to get data from EKPO.

suppose it_data has 5 fields already updated. create another internal table itab with same fields of it_data + 1 extra "field" which you want to be updated from EKPO.

copy data from it_data to itab and then select "field" from EKPO INTO CORRESPONDING FIELDS OF TABLE itab. but you need to use where clause in Select from EKPO to match the data into itab.

I hope this is helpful !

[Sandra_Rossi]

SELECT view~*, ekpo~ebeln FROM view INNER JOIN ekpo ...

Is it what you're looking for?

[michael_piesche]

What ABAP Version do you have installed? the proposed solution from Sandra does not work for older ABAP Versions (e.g. only for >=751 but not <=750).