Skip to Content
0

Rules for conditions cond_exp in a filter condition of a path expression of a CDS view

Feb 10 at 08:15 PM

32

avatar image
Former Member

Dear Experts,

I am building a CDS which is reading a table, table has a line/item ID and several columns which are Text IDs. Corresponding texts are in a text table (linked with line/item ID and Text ID). Text table is similar to CGPL_TEXT.

AS I have more than 10 Text IDs I wouldn't like to use a condition in the CDS association

association [0..*] to YTexts as _Texts on $projection.temUUID = _Texts.itemUUID and $projection.zz_name = _Texts.TextUUID

I would like to use filters parameters like below:

_NPDTexts[ TextUUID = zz_name and Laguage = 'E' ].Text as nameText

but TextUUID = zz_name is trowing a syntax error.

As far as I can see in the documentation I can not use on the rhs of the expression a field from the projection, only fields from target data source (_Texts table). Any idea on what is the reason for this limitation?

Thanks,

San

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers