Skip to Content
0

Right Outer Join not working in CDS view

May 17, 2017 at 10:28 AM

101

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sean Zhang
May 26, 2017 at 05:15 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 29, 2017 at 10:47 AM
0

I found the same issue. Any solutions there?

Share
10 |10000 characters needed characters left characters exceeded