Skip to Content

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

Jan 08 at 08:02 PM


avatar image
Former Member

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


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

How can you activate a view with errors?

Former Member
Horst Keller

Hi Horst Keller

Activitade successfully also I can see the data but I am getting the error

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tobias Maurer 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.

10 |10000 characters needed characters left characters exceeded