topic Re: select and endselect with append statment in Application Development and Automation Discussions

select and endselect with append statment

former_member770121 — Wed, 29 Dec 2021 10:47:50 GMT

first select query ..............

second select query ................

append wa to it.

endselect.

bascially first iteration get write data and appned but in second iteration it complete fetch the data of second select query and appned and then after it go to first select query then fetch data from data base table and then append it show output of 4 lines but i want the output of just 2 lines

mean fetch data from first and second select query at same time and append same iteration then second iteration fetch data from both select queries then append at same time please suggest any solution for ALV

Re: select and endselect with append statment

FredericGirod — Wed, 29 Dec 2021 10:56:12 GMT

Are you trying to rebuild the INNER JOIN ?

Re: select and endselect with append statment

Sandra_Rossi — Wed, 29 Dec 2021 10:57:21 GMT

Your problem is not about ALV (the final goal), it's about how to fill the internal table from database tables.

I don't understand your question, please share the code you have tried.

Moreover please edit your question, select your code and press the button [CODE], which makes the code appear colored/indented, it will be easier for people to look at it. Thank you!

Re: select and endselect with append statment

former_member770121 — Wed, 29 Dec 2021 11:32:18 GMT

there is no field we can apply join so join is not possible

Re: select and endselect with append statment

former_member770121 — Wed, 29 Dec 2021 11:40:51 GMT

code is:::

select field from table into wa where......

select field2 from table2 into wa where......

append wa to it.

endselect.

first it complete iteration of nearest select query and then it move to second select query

output shoould be:::

1 2 3

4 5 ( 2 and 4) from first select query data and (3 and 5 )is output of second select query

but it display output is 4 lines. there we cannot apply join please suggest any solution

Re: select and endselect with append statment

ThorstenHoefer — Wed, 29 Dec 2021 11:41:13 GMT

Hi,

instead of

select ...
  append wa to lt_table
endselect

try to use

 select *
   from ..
  appending table lt_table.

Re: select and endselect with append statment

former_member770121 — Wed, 29 Dec 2021 11:49:35 GMT

it is not working

Re: select and endselect with append statment

Sandra_Rossi — Wed, 29 Dec 2021 12:06:54 GMT

Please use CODE button to format your text.

See how I do it:

select field from table into wa where......
  select field2 from table2 into wa where......
    append wa to it.
  endselect.
endselect.

Input from "table":

2
4

Input from "table2":

3
5

Actual output:

output shoould be:::

2   4
3   5

I guess you want to transpose, right?

Re: select and endselect with append statment

former_member770121 — Wed, 29 Dec 2021 12:21:03 GMT

I also put the same code as u write but this logic is not wright???

Re: select and endselect with append statment

Sandra_Rossi — Wed, 29 Dec 2021 13:23:38 GMT

You didn't understand. I have just rewritten your own code, I'm just asking you to pay attention to formatting of your question and comments. You missed the important thing of what I said. Never mind.

Re: select and endselect with append statment

former_member770121 — Thu, 30 Dec 2021 05:15:47 GMT

output of first internal table is::

1 2 3

4 5

in second internal table we also get two values like :

1 6

HOW I CAN APPEND THE VALUE OF SECOND INTERNAL TABLE IN FIRST INTERNAL TABLE WITH EXISTING DATA + WITH CURRENT LINE

MY DESIRED OUTPUT IS :::::

1 2 3 6

4 5 7

IN ALV

PLWASE SUGGEST SOLUTION NOW

How can move data from one internal table to another internal table with existing data.