topic Re: Join in Application Development and Automation Discussions

Join

Former Member — Mon, 23 Jun 2008 05:22:36 GMT

Hi experts,

i m using outer join on 4 tables. while debugging i m getting 39 entries when using joins on 3 tables, but when i use 4 th table entries increases to 42. It should not b increaseas i want entry from fourth table for corresponding fields of 3 tables.

Plz correct me where i m wrong

select a_{banfn a}ekgrp a_{afnam a}txz01 a_{matnr a}werks a_{lgort a}bednr

a_{menge a}meins a_{badat a}frgdt a_{ebeln a}ebelp

b_{belnr b}bwart b~budat

c~preis

d~udate

from ( eban as a left outer join ekbe

as b on

a_{werks eq b}werks and

a_{ebeln eq b}ebeln and

a_{ebelp eq b}ebelp

left join eipa as c on

c_{ebeln = a}ebeln and

c_{ebelp = a}ebelp and

c_{werks = a}werks

left join cdhdr as d on

d_{objectid = a}ebeln and

d~tcode ='ME29N' )

into corresponding fields of

table eban_ekbe

where a~ekgrp in s_ekgrp and

a~afnam in s_afnam and

a~matnr in s_matnr and

a~werks eq p_werks and

a~lgort in s_lgort and

a~badat in s_badat .

Savita

Re: Join

Former Member — Mon, 23 Jun 2008 05:49:19 GMT

Hi Savita,

Instead of doing the Outer join Why dont you use FOR ALL ENTRIES IN <TAB>.

This will defiantly resolve your problem

&***********Reward Point if helpful*************&

Re: Join

Former Member — Mon, 23 Jun 2008 05:50:22 GMT

Hi ,

You have not used the proper join conditions.Try to use keay fileds to join table if possible in your case. Other wise split your join to get the required data so that you will get the appropriate data.

Re: Join

Former Member — Mon, 23 Jun 2008 05:59:21 GMT

Hi Savita,

Try Using FOR ALL ENTRIES and use all of your key fields to get the data. This must help you.

Regards,

Sai