Skip to Content
avatar image
Former Member

CDS View Error- Invalid data source:No joins or Unions Supported

Hello Everyone,

I am working on a scenario where I need to build a CDS view based on join between the standard CDS view and bsad table as shown in below code using leftouter join.

Requirement is to report this CDS view in Fiori

View activated successfully but showing below error

Invalid data source: No joins or unions supported

I tried in so many ways but I couldn't solve the issue, please help me

Thanks


error1.png (26.0 kB)
error2.png (50.1 kB)
code1.png (53.0 kB)
code2.png (51.3 kB)
code3.png (74.4 kB)
code4.png (76.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 06 at 02:53 PM

    Hello Karun,

    we had the same issue and was able to solve it:
    Delete the annotation "@Analytics.query: true" or set it to "false" should solve the issue.

    If you need this annotation, you could make a "view on view" on top of this CDS and set it there.

    Add comment
    10|10000 characters needed characters exceeded