topic Re: select in Application Development and Automation Discussions

select

Former Member — Thu, 02 Nov 2006 09:32:36 GMT

hi to all,

help me in this issue,

i need values from two tables to pass into the rfc

can i do like this in first

select * from zsd1 into table it_zsd

where ---

2nd select statemnet

select * from zsd2 appending into table it_zsd

where-----

thanks in advance

kiran kumar.

Re: select

Former Member — Thu, 02 Nov 2006 09:34:27 GMT

i think in rfc you will be having nly one internal table to be passed, so please use join , so that values fron two tables can be obtained into one internal table.

Re: select

Former Member — Thu, 02 Nov 2006 09:34:51 GMT

You can. I presume the two tables have the sames fields in them.

Re: select

Former Member — Thu, 02 Nov 2006 09:37:19 GMT

Hi,

U can append only if the structure of ZSD1 & ZSD2 same.

Cheers.

Re: select

Former Member — Thu, 02 Nov 2006 09:39:02 GMT

hi,

both the structures r having differnt fields

thanks in advance

kiran kuamr

Re: select

gopi_narendra — Thu, 02 Nov 2006 09:40:15 GMT

Then in that case you can not use the select statement as u mentioned.

Use Join or use for all entries or move data from 2 int tables into a single int table

Regards

- Gopi

Re: select

former_member404244 — Thu, 02 Nov 2006 09:44:29 GMT

Hi Kiran,

u cannot do like what u have mentioned...

use to different intenal tables for ZSD1 and ZSD2 database tables.get the data to two internal tables and then pass the two internal tables data to the final internal table .

Regards,

nagaraj

Re: select

Former Member — Thu, 02 Nov 2006 09:52:27 GMT

You cannot do it in that way. Instead fetch the data in two different internal tabels and then append the data from one internal table to othet internal tabel. Pass that internal tabel to RFC.

select * from zsd1 into table it_zsd1.

select * from zsd2 into table it_zsd2.

Loop at it_zsd2 into wa_zsd.

append wa_zsd into it_zsd1.

endloop.

But for this you need to have structures of both tables it_zsd1 and it_zsd2 same, then only you can do in this way.

or the best option is to use join on tables zsd1 and zsd2 if they have some fields in common.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: select

Former Member — Thu, 02 Nov 2006 10:02:05 GMT

use for all entries when ever ur selecting the fields from the second table .