Skip to Content
0
Former Member
Oct 18, 2006 at 03:39 AM

Help on Join

23 Views

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