topic Using SQL with @EndUserText.label in ABAP CDS views error in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/using-sql-with-endusertext-label-in-abap-cds-views-error/m-p/12194293#M1981080 <P>Hi! I gave use some annotation to get label for for selected element, but it not catch by UI. I have read other question </P> <P><A href="https://answers.sap.com/questions/10999490/concat-function-or-equivalent-for-cds-view.html" target="test_blank">https://answers.sap.com/questions/10999490/concat-function-or-equivalent-for-cds-view.html</A></P> <P>I try to go way like there, but I have no result. I create logic for site table support, but at the moment UI work incorrect.</P> <P>UPDATE: After I change ForeignKey for table it start to work fine(here result:<A href="https://1x-rate.com/"> https://1x-rate.com/</A>), but I still have problems with information that it which is not sorted in table. If anyone have idea - you welcome.</P> Wed, 24 Jun 2020 08:49:38 GMT Former Member 2020-06-24T08:49:38Z Using SQL with @EndUserText.label in ABAP CDS views error https://community.sap.com/t5/application-development-and-automation-discussions/using-sql-with-endusertext-label-in-abap-cds-views-error/m-p/12194293#M1981080 <P>Hi! I gave use some annotation to get label for for selected element, but it not catch by UI. I have read other question </P> <P><A href="https://answers.sap.com/questions/10999490/concat-function-or-equivalent-for-cds-view.html" target="test_blank">https://answers.sap.com/questions/10999490/concat-function-or-equivalent-for-cds-view.html</A></P> <P>I try to go way like there, but I have no result. I create logic for site table support, but at the moment UI work incorrect.</P> <P>UPDATE: After I change ForeignKey for table it start to work fine(here result:<A href="https://1x-rate.com/"> https://1x-rate.com/</A>), but I still have problems with information that it which is not sorted in table. If anyone have idea - you welcome.</P> Wed, 24 Jun 2020 08:49:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-sql-with-endusertext-label-in-abap-cds-views-error/m-p/12194293#M1981080 Former Member 2020-06-24T08:49:38Z