When multiple
SAP tables are logically joined, it is always advisable to use inner
join to read the data from them. This certainly reduces the load on
the network.
Let us take
an example of 2 tables, zairln and zflight. The table zairln has the
field airln, which is the airline code and the field lnnam, which is
the name of the airline. The table zflight has the field airln, the
airline code and other fields which hold the details of the flights
that an airline operates.
Since these 2
tables a re logically joined by the airln field, it is advisable to
use the inner join.
Select a~airln a~lnnam b~fligh b~cntry into table int_airdet
From zairln as a inner join zflight as b on a~airln = b~airln.
In order to
restrict the data as per the selection criteria, a where clause can
be added to the above inner join.
===================================================================================
This
tutorial contains a number of pages, each one explaining a tip or
trick. You can either browse them one by one (click on the NEXT
button, or jump straight to a tip or trick which interests you:
