Skip to Content
0
Former Member
Jun 03, 2009 at 04:20 AM

Issue with Help View

45 Views

Hi All,

I have implemented a Search help with HELP view. As per the documentation a HELP view implements outer join; but somehow it doesnt.

In our scenario we have 3 tables mara, t1 and t2, where mara is primary table.

mara-mandt = t1-mandt, mara-matnr = t1-matnr

mara-mandt = t2-mandt, mara-matnr = t2-matnr

The view somehow does an outjoin of mara with both tables t1 and t2. But, t1 and t2 are linked by inner join.

I want all 3 tables i.e. mara, t1 and t2 to be OUTER JOINED.

How should I achieve this ?

Regards,

Ashish