Skip to Content

CDS View - Left Excluding Join

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 11, 2017 at 11:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded