topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Thu, 30 Jul 2020 11:16:48 GMT

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.

Re: select query

former_member683273 — Thu, 30 Jul 2020 12:24:54 GMT

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 !

Re: select query

Sandra_Rossi — Thu, 30 Jul 2020 13:53:27 GMT

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

Is it what you're looking for?

Re: select query

michael_piesche — Thu, 30 Jul 2020 14:45:36 GMT

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).