topic Re: Help View in Application Development and Automation Discussions

Help View

Former Member — Fri, 21 Nov 2008 20:29:34 GMT

Hello,

Do you know how to define an OUTER JOIN as a part of a Help View?

I am not sure if the OUTER JOIN is defined in the Help View or in the Table's foreign key field cardinality.

I have this defined in a Search Help, so when I do a drop down search I only find records when an entry always exists in the Check Table. I need it to find records even when the entry does not exist in the check table.

Best Regards

Re: Help View

Former Member — Fri, 21 Nov 2008 20:37:19 GMT

I think views are created with inner joins only.

Re: Help View

Former Member — Fri, 21 Nov 2008 20:43:28 GMT

From the documentation of views:

http://help.sap.com/saphelp_47x200/helpdata/EN/cf/21ea0b446011d189700000e8322d00/frameset.htm

Rob

Re: Help View

Former Member — Fri, 21 Nov 2008 20:43:37 GMT

Thanks for the reply.

Actually SAP says 'Database views implement an inner join, the other view types implement an outer join (Projection views, Help views, and Maintenance views)'.

Anyone know how to implement a Help View with an Outer join?

Re: Help View

Former Member — Fri, 21 Nov 2008 21:03:38 GMT

Hi Rob,

I am confused, it says to add a foreign key within my Primary table. So I added check table LTAP (fields LGNUM, TANUM) with Foreign Key Field Type 'key fields/candidates radiobutton' and Cardinality has to be either (N:1 or N:C). I tried but still no record returned whenever the entry in LTAP doesn't exist. Doesn't N:1/N:C force me to always have a record in the LTAP?

http://help.sap.com/saphelp_47x200/helpdata/EN/cf/21ecd2446011d189700000e8322d00/frameset.htm

I defined a Help View.

I placed the Help View in a Search Help.

I added the Search Help to a field in my primary table.

I added a Foreign Key/Check table LTAP with (N:C) to a field in my primary table.

No luck.

Any ideas???