Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Former Member

‎02-10-2018 8:15 PM

0 Kudos

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

0 REPLIES 0