How to create a left join view in se11??

[Former Member]

I would like to create a view which contains KNA1,KONA,KNVV,KNVH(four tables) , I want to use this view to create a search help for Tcode 'VBO3'.

but when I join table KNVH, there is no data in view, because there is no customer hierarchy, so I want to create a left join view. could you please tell me how to create a left join view? Thank you very much.

[Former Member]

hi,

You can create the views for different database table using "view "option in Data dictionary.

Give name in the view.

click create.

system will ask you four types of views types.

1. Projection view

2. Database view

3. maintance view

4.Help view

By using Help you can create view using lef join.

choose help view .

Give the tables you want to create choose output fields.

Then system will create the view with left join.

If useful allot points

[former_member283648]

Hi,

Try this and let me know if it helps u out. While creating views you can mention the join conditions in two places. One in the Table/Join conditions and other in selection conditions. In this the conditions you specify in Table/Join conditions will give u inner joins. And the conditions you specify in selection conditions will specify Outer Join. So try using the selection conditions tab.

Hope this resolves your issue.

[Former Member]

Hello,

yes, in general, maint. view and help view could be created as outer join view.

but it should obey relationship.

my fourt tables:

KONA -

---

> I want to get agreement number and type from this table

KNA1 -

---

>I want to get customer name, city, country from this table

KNVH -

---

>I want to get customer hierarchy from this table.

KNVV -

---

>I want to get customer group 1 from this table.

but in help view, I can only get relationship between KONA and KNA1.

I could not find the relationship for KNVH and KNVV.

if it's required to add a search help exit, then how to write the code in the function?

Could somebody please give me any solutions? thank you.

[Former Member]

Hi,

check the links below for creating help views , serch helps .........

http://help.sap.com/saphelp_46c/helpdata/en/cf/21ecd2446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/cf/21ee93446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/cf/21ec84446011d189700000e8322d00/frameset.htm

[seshatalpasai_madala]

HI,

If you want to create a left out join then you have to ceate Maintanance view in SE11. All maintanance views are LEFT OUTER JOIN and all DATABSE views are INNER JOIN's.

Regards,

Sesh

[Former Member]

Now I want to use a search help exit.

but I also use a view as a selection method in a search help.

I use search help exit to add two fields which are not contained in the selection method.

could somebody tell me in which CALLCONTROL-STEP I can add select sentence ???

Thank you very much.