Hi,
Need to join 3 tables EQUI,STAT,ZCS_SOLTYPE.
The required fields in the tables are
EQUI - <b>equnr,zzengn,zzrefeng,eqtyp,objnr</b>
STAT - <b>objnr</b>
ZCS_SOLTYPE - <b>zzengn,zzcrmgroup</b>
My structure table is like this
<b>BEGIN OF s_equi,
equnr TYPE equnr,
zzengn TYPE zzengn,
zzrefeng TYPE zzrefeng,
eqtyp TYPE eqtyp,
objnr TYPE J_OBJNR,
stat type stat,
zzcrmgroup type zzcrmgroup,
END OF s_equi,</b>
and the internal table is
<b>i_equi TYPE STANDARD TABLE OF s_equi,</b>
Can anyone help me out in writing the join for these these tables.
Regards,
Ram