Skip to Content
0

CDS View - Left Excluding Join

Jun 30, 2017 at 09:30 PM

91

avatar image

Hello CDS experts,

I have the following requirement:

  1. I have the sales table VBAK with sales docs
  2. I have the billing table VBRP with billing docs and the link to sales docs (AUBEL/AUPOS);
  3. I need to select Sales Docs from VBAK that do NOT exist in VBRP using CDS views:

In the example above, I only need to select Sales Docs 4 and 5 from VBAK, since 1-3 exist in VBRP.

This would be a LEFT EXCLUDING, (or a LEFT OUTER - INNER join) but I'm not sure this syntax is available:

Any ideas on how to do this through CDS Views?

Much appreciated!

Marcelo

1.png (5.3 kB)
1.png (10.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tushar Sharma Aug 11, 2017 at 11:57 AM
0

Hi,

The CDS views allows different joins:

  1. Inner Join (JOIN).
  2. Left Outer Join.
  3. Right Outer Join.

Refer this for more detailed example.

You can have a try, otherwise let me know your queries.

Thanks & Regards,

Tushar Sharma

Share
10 |10000 characters needed characters left characters exceeded