Help View

[Former Member]

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

[Former Member]

I think views are created with inner joins only.

[Former Member]

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?

[Former Member]

From the documentation of views:

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

Rob

[Former Member]

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???