Help on Join

Hi Ram,

Please try the following join:

<b> SELECT a_{equnr x}zzengn a_{zzrefeng a}eqtyp

d_{objnr x}zzcrmgroup

INTO TABLE i_equi

FROM equi AS a

INNER JOIN stat AS d ON d_{objnr = a}objnr

INNER JOIN ZCS_SOLTYPE AS x ON x_{zzengn = a}zzengn

WHERE <cond>.</b>

Hope this helps. Please reward points if you find this useful.

Regards,

Chetan.

SELECT EQUI_{EQUNR EQUI}zzengn EQUI~zzrefeng

EQUI_{eqtyp EQUI}objnr

STAT~OBJNR

ETYP~zzengn

ETYP~zzcrmgroup

INTO table i_final

FROM ( stat

INNER JOIN equi

ON equi_{objnr = stat}objnr

INNER JOIN ZCS_SOLTYPE

ON ZCS_SOLTYPE_{zzengn = Equi}zzengn)

WHERE EQUI~EQUNR IN S-screen.

Try with this. If it works pls. don't forget to give points to me.

Murali

hi

good

i am bit confused with your query, go through this definitaion of INNER JOIN and do accordingly

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.

thanks

mrutyun^