Skip to Content

Hi, I have an issue with a generic extractor based on views.

Currently I am using a database view on two tables. But I want to have a left outer join instead of inner join. Any solutions on this??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 21, 2018 at 09:22 AM

    One way will be to create a CDS view (where a left outer join feature is available) and build an ODP dataSource on top of it.

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2018 at 12:04 PM

    create the extractor based on the left table. retrieve the fields of the other table via an user-exit

    M.

    Add comment
    10|10000 characters needed characters exceeded