Sathish

• Aug 29th, 2006

 

I dont think we can use a join on internal tables

sravanthi

• Sep 13th, 2006

 

if suppose we have

begin of i_kna1 occurs 0,

kunnr like kna1-kunnr,

name1 like kna1-name1,

vbeln like vbak-vbeln,

erdat like vbak-erdat,

end of i_kna1.

select kna1~kunnr kna1~name1 vbak~vbeln vbak~erdat into table i_kna1 from kna1 join vbak on kna1~kunnr = vbak~kunnr.

praveen

• Sep 29th, 2006

 

use for all entries

gnanam

• Oct 5th, 2006

 

using inner join .

Viplove

• Oct 24th, 2006

 

In HR ABAP, We can read data from two internal tables usingPROVIDE f1 f2 f3 from it1 f4 f5 f6 from it2 between pnp-begda and pnp-endda where .ENDPROVIDE.-Viplove

LAKSHMAN RAO

• Nov 30th, 2006

 

better use select for all enrys

if u use this performance will be bettor

sreekanth reddy

• Nov 1st, 2011

 

select a~carrid a~connid a~fldate b~carrid b~customid into itab from ( sflight as a inner join to sbook as b on
a~carrid = b~carrid ) where a~carrid in s_carrid. (select-options : s_carrid).

kumar

• Mar 14th, 2012

 

You can create a range or select options out of one internal table and use the select query ...

"for all entries in "...

.. in .

srinivasaraju.vysyaraju

• Jun 6th, 2012

 

There are so many ways.
1. Inner join
2. Outer join
3. Left outer join
4. For all entries
I suggest that if you join two internal table you use inner join concept more than two table you use for all entries .
if you do so your program will perform better.