Skip to Content
avatar image
Former Member

CDS View Error Association Cannot Be Used Locally

Hello Friends

While using CDS view

I am getting error

Association cannot be used locally within the view

Please find attached image of my CDS view and help me resolve the error.

Any ides how to resolve the error.

Regards,
Sunil

cds-error.jpg (319.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 27, 2017 at 10:04 AM

    Hi Sunil,

    Association can't be used where it's defined, it's not the association purpose.

    you have two options:

    1, you have a higher level CDS for the current one, then you could use the association freely.

    or 2, you switch the association to leftouter join.

    Best Regards,

    Sean

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2017 at 12:39 PM

    Hello Sunil,

    Looks like the issue is because of the usage of $projection.For details, please see Horst Keller's comment from April 19,2017 in response to the comment by Ceyhun Alp here

    Best,

    Aashrith.

    Add comment
    10|10000 characters needed characters exceeded