Join

[Former Member]

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

[Former Member]

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*************&

[Former Member]

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.

[Former Member]

Hi Savita,

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

Regards,

Sai