topic Re: Inner and outer Join statement in Application Development and Automation Discussions

Inner and outer Join statement

former_member764673 — Tue, 06 Feb 2007 21:54:47 GMT

I have three tables..

ZGMARD

EQUI

EQBS

ZGMARD tables has

MATNR

WERKS

LGORT

EQUI table has

EQUNR

MATNR

SERGE

EQBS table has

EQUNR

WERKS

PLANT

Now my requirement is I need a join statement where

dependeding on MATNR,WERKS and LGORT from ZGMARD I should be able to get the SERGE.(depending on tables EQUI and EQBS)

Any help would be appreciated.

Thanks,

Raj

Re: Inner and outer Join statement

Former Member — Tue, 06 Feb 2007 22:39:05 GMT

Hi,

Select matnr werks lgort into table i_zgmard from zgmard

where matnr in s_matnr

and werks in s_werks

and lgort in s_lgort.

select a_{equnr a}matnr a_{serge b}B_WERK

into table i_equi from equi as a inner join eqbs as b

for all entries in i_zgmard

where a~matnr = i_zgmard-matnr

and b~b_werk = i_zgmard-werks.

Assuming matnr, werks and lgort to be select-options. In eqbx table plant is B_WERK.

Regards

Subramanian

Re: Inner and outer Join statement

Former Member — Tue, 06 Feb 2007 22:48:38 GMT

hi raj,

Try the following stmt. In the below stmt I used both joins as inner joins. you can also use outer joins in their place. Here itab is an internal table with only one field serge. If you want additional fields also along with serge, define them in the internal table and specify them in the select statement from which table u want which field as i done it for serge.

select equi_{serge from equi inner join zgmard on equi}matnr = zgmard_{matnr inner join eqbs on zgmard}werks = eqbs~werks into table itab.

regards,

rajasekhar.k