topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Mon, 18 Sep 2006 12:32:50 GMT

Hi,

i want to have two fields from bseg table and two fields from t001 table into a single table. since bseg is a cluster table so inner join is not possible. Any other method to acheive the purpose?

Re: inner join

Former Member — Mon, 18 Sep 2006 12:34:44 GMT

Hi,

use "for all entries" ...

Njoy SAP

Re: inner join

Former Member — Mon, 18 Sep 2006 12:34:50 GMT

Hi Viswanath,

1)Use FOR ALL ENTRIES option instead of INNER JOINs.

2)SELECT 2 fields from BSEG into an internal table.

3)If the internal table is not initial, then SELECT 2 fields from T001 using FOR ALL ENTRIES option.

Thanks,

Vinay

Re: inner join

Former Member — Mon, 18 Sep 2006 12:35:09 GMT

Hello!

Check your previous topic.

Regards

Tamá

Re: inner join

Former Member — Mon, 18 Sep 2006 12:35:16 GMT

Get the data from BSEG table into an internal table ibseg..and use the SELECT statement from T001 using FOR ALL ENTRIES in ibseg to achieve the goal.

It can be worth even to do the other way round i.e. get information from T001 and using for all get data from BSEG.

Re: inner join

Former Member — Mon, 18 Sep 2006 12:35:52 GMT

Hello,

FOR ALL ENTRIES would be the better option for you.

Regs,

Venkat Ramanan N

Re: inner join

Former Member — Mon, 18 Sep 2006 14:45:20 GMT

T001 is a small table. So the best thing to do would be to read it all into a single table before selecting from BSEG:


SELECT * FROM T001 INTO TABLE itab.

Then instead of selecting it each time, you can read it using a binary search. This will be much faster.

Rob

Message was edited by: Rob Burbank