Skip to Content
avatar image
Former Member

Right Outer Join not working in CDS view

Hi Expert,

I am creating one CDS view by using right outer join, but I am not getting expected result, instead I am getting output for inner join. I tried the same select query in SQL Console as well as normal ABAP report and it is working but not for CDS view.

If any one of you have worked on same issue please tell me the solution for the same.

Below is the source code for DDL source(CDS view definition):

@AbapCatalog.sqlViewName: 'ZCDS_RIGHT_JOIN'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Demo CDS view with right outer Join'
define view ZDDl_RIGHT_OUTERJOIN as
select
c.cust_id,
c.cust_name,
s.zcust_id,
s.zproduct,
s.ztot_unit from
zct_customer as c right outer join zct_sales_order as s
on c.cust_name = s.zcust_name

Also ,please find the attachment for output screenshot for Console and CDS View.

cds-view-output.pngsql-console-output.png

Thanks& Regards,

Bhupesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 26, 2017 at 05:15 AM

    this should be incorrect behavoir.

    Please try to double check the SQL definition statement in ABAP in Eclipse by right click the CDS-> Show SQL create Statement.

    if the Right join is used there, then it's a DB issue.

    if there is no right join, then it's CDS ddic issue. please double check the NW version and create incident accordingly.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2017 at 10:47 AM

    I found the same issue. Any solutions there?

    Add comment
    10|10000 characters needed characters exceeded