topic Re: Concatenate two select query in Application Development and Automation Discussions

Concatenate two select query

Former Member — Tue, 18 Aug 2009 10:53:36 GMT

Hi ABAPers,

Can you please tell me how to concatenate this two select qureies.



select  ebeln knumv from ekko  INTO
TABLE  tt_knumv
where ebeln = p_ebeln.

select ebeln knumv from eslh INTO TABLE
tt_knumv  FOR ALL ENTRIES IN tt_esll
where  packno = tt_esll-sub_packno.

Regards

Abhinab Mishra

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 10:59:32 GMT

Hi,

Use this.

CONCATENATE ITAB1-FIELD1 ITAB2-FIELD2 INTO <REQUIRED FIELD>

Regards,

Shamma

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:01:09 GMT

Brother this is a select qurey. I am not talking about concatenating two fields.

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:06:52 GMT

Use the inner join for the two select statment based on the fied knumv.

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:41:43 GMT

Hi,

I dont think inner join is possible in this case since you are selecting the same fields from the two different tables into the single internal table vertically. It can be used to collect the data into the internal table horizontally but that would make no sense in this case. May be you can try something like this



data: t_temp type table of tt_knumv.

select ebeln knumv 
from eslh 
INTO TABLE tt_knumv 
 FOR ALL ENTRIES IN tt_esll
where  packno = tt_esll-sub_packno.

select  ebeln knumv 
from ekko 
 INTO TABLE  t_temp
where ebeln = p_ebeln.

loop at t_temp.
move-corresponding t_temp to tt_knumv.
append tt_knumv.
endloop.

Regards,

Vik

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:43:17 GMT

Hi,

You can use Inner join instead using two select queries on the common field.

That is:



Select all fields(from the two tables) into internal table
from table 1 as a inner join table 2 as b on
a~common field name = b~common field name.

Hope it helps

Regards

Mansi

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:55:49 GMT

Hello,

Unless I misunderstand your question, why not simply use APPENDING TABLE:


> 
> select  ebeln knumv from ekko  INTO
> TABLE  tt_knumv
> where ebeln = p_ebeln.
> 
> select ebeln knumv from eslh APPENDING TABLE
> tt_knumv  FOR ALL ENTRIES IN tt_esll
> where  packno = tt_esll-sub_packno.
> 
>

Regards,

Mark

Re: Concatenate two select query

Former Member — Tue, 18 Aug 2009 11:55:50 GMT

Hello,

Try this way:

select a_{ebeln a}knumv from ekko as a join eslh as b on a_{ebeln = b}ebeln and a_{knumv = b}knumv

INTO TABLE tt_knumv

where a~ebeln = p_ebeln

and b~packno = tt_esll-sub_packno .

You may fine tune it more for your use.

Check if this can help!

Thanks,

Augustin.

Re: Concatenate two select query

Former Member — Fri, 21 Aug 2009 06:03:24 GMT

Thank you all for your replies.