Is it possible to join a view to a table

12 Views

Hi all,

I need to create a datasource in R3, the basis of the datasource lies in sql statement. In the statement there are lots of "and" and "(+). Within the "and" statement there is also a filter.

For example (the sql coding):

where rs.docnumber = r.invoicenumber

and ct.caracteristic = 'unspsc_number'

and ekk.costcenter = cs.costcenter ➕

The first 2 lines can be solved with SE11, in here you can set your filter. But in SE11 you can not have an outer join in place.

So, I tried SQ02, creating infosets but the problem with the infoset is that you are not able to set a filter.

My question to you is:

1. is there a solution to solve my problem (sql statement)

2. can an outer join be set in SE11

3. can a selection/filter set in SQ02

4. is it possible in SQ02 to join a view (created in SE11) and join this to another table?

mcteam