09-18-2006 1:32 PM
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?
09-18-2006 1:34 PM
09-18-2006 1:34 PM
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
09-18-2006 1:35 PM
09-18-2006 1:35 PM
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.
09-18-2006 1:35 PM
Hello,
FOR ALL ENTRIES would be the better option for you.
Regs,
Venkat Ramanan N
09-18-2006 3:45 PM
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