Is it possible to create a database view using outer join?

[Former Member]

Dear Experts,

I am working on creating a database view for a generic extraction.

It turns out that the database view created through an inner join is not enough to cover the requirement.

Is it possible that I can create a database view using outer join?

Is there any althernative way to resolve this problem?

Thanks and appreciated.

Arthur

[Former Member]

Dear Arthur,

Do You want to connect a NON SAP System ?

If You wan't to Connect a NON SAP System You create a View with an Outer Join

in the Sourcesystem in the native SQL of the source system and than You access

this view with DB Connect.

Best Martin

[Former Member]

Hi Arthur,

Outer joins are not possible with DB views. Alternate is to create a FM datasource. In the FM, you can write the select statement with an outer join. Hope this makes sense.

Thanks and Regards

Subray Hegde

[Former Member]

Hi Subray,

Thanks for your reply.

Is it possible that you could provide me an brief explaination about FM datasource and an example of the select

statement with an outer join for FM datasource.

Very appreciated.

Arthur

[Former Member]

Hi Subray,

Thanks for your reply.

The information is very helpful.

Appreciated.

Arthur