topic Re: Task 3 - Enhancing CDS View Entities with Annotations in Application Development and Automation Discussions

Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Fri, 23 Aug 2024 16:42:45 GMT

Another Wednesday and we are back with Task 3 of the August Developer Challenge on ABAP Core Data Services. We are thrilled to see the amazing response to Task 1 and Task 2. Whoever missed it can find all the information in our blogpost August Developer Challenge.

Today for Task 3 we decided to take you all through one of the interesting and widely used feature of ABAP Core Data Services – Annotations.

Annotations allow you to add domain-specific metadata and text labels to CDS objects that goes beyond the syntax features of ABAP SQL. This means that it enhances the technical properties of CDS view entities such as adding search , capabilities or controlling access to your data. To know more about Annotations watch the SAP TechByte on Annotations or go through the CDS Annotation Help Documentation

Task 3 – In this task we will add annotations to the CDS View Entity created in Task1 and then create a Fiori app to view the results.

Add annotations to display all the fields in the Fiori app by default.
Add annotations to provide a search field and enable search by ‘Description’ in the filter bar.
Add annotations to provide a value help filter on the ‘Status text’ field based on Overall Status text.
Add annotations to provide a filter for the Travel ID field.
Create a Service Definition
Create a Service Binding to preview the Fiori app.

Follow the instructions carefully and share with us the screenshots of the items mentioned in the ‘Validation’ section of this discussion.

Please use this separate thread to ask your questions and discuss issues.

Validation :-

Note:- Please do not search with '*'

Please share screenshots after performing the following :

Preview the App showing all the columns, search and filter options in the CDS view entity.
Search records based on a specific value from 'Description' field and select an available value from the 'Status' field.

We are eagerly waiting to see your submissions. Enjoy!!

Re: Task 3 - Enhancing CDS View Entities with Annotations

mwn — Wed, 21 Aug 2024 14:30:33 GMT

The wizard did most of the work, as all good wizards should!

I removed some of the generated filters, and added the search for description, and here's the result:

Re: Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Wed, 21 Aug 2024 14:19:50 GMT

Hi @mwn

Thanks for the response. Could you please search without a (*), may be with a specific value?

Re: Task 3 - Enhancing CDS View Entities with Annotations

BH2408 — Wed, 21 Aug 2024 14:24:51 GMT

Hi Team,

Greetings!!!!

Here is the screen shot for today's challenge.

1. Create the MDE for all annotations

2. Added the Search and Fuzzy Search value in MDE for Description

Please review.

Thanks and Regards,

Bharani

Re: Task 3 - Enhancing CDS View Entities with Annotations

mwn — Wed, 21 Aug 2024 14:35:23 GMT

Whoops, I forgot the fuzziness annotation!
The latest screen shot should have fixed that.

Re: Task 3 - Enhancing CDS View Entities with Annotations

Sivaiah_Bhiragani — Wed, 21 Aug 2024 16:28:08 GMT

Preview the App showing all the columns, search and filter options in the CDS view entity.
Search records based on a specific value from 'Description' field, and apply a filter on 'Status'.

Re: Task 3 - Enhancing CDS View Entities with Annotations

abaprules — Wed, 21 Aug 2024 16:35:20 GMT

My solution:

Re: Task 3 - Enhancing CDS View Entities with Annotations

Sivaiah_Bhiragani — Wed, 21 Aug 2024 16:36:03 GMT

Re: Task 3 - Enhancing CDS View Entities with Annotations

tim_matsypura — Wed, 21 Aug 2024 17:14:27 GMT

Done!

Re: Task 3 - Enhancing CDS View Entities with Annotations

Sandra_Solis — Sat, 24 Aug 2024 06:12:28 GMT

Done 🥳🥳🥳

Re: Task 3 - Enhancing CDS View Entities with Annotations

pankajgupta1992 — Wed, 21 Aug 2024 18:42:06 GMT

Hi Team,

Let's go!!

Preview the App showing all the columns, search and filter options in the CDS view entity.

2. Search records based on a specific value from 'Description' field, and apply a filter on 'Status'.

Thanks & regards,

Pankaj Gupta

Re: Task 3 - Enhancing CDS View Entities with Annotations

Silvi_ — Wed, 21 Aug 2024 19:57:36 GMT

Hello,

My solution to task 3:
1. General preview

2. Preview based on the search field

3. Preview from filtering 'StatusText' field based on OverallStatus text.

Thank you!😊

Re: Task 3 - Enhancing CDS View Entities with Annotations

mwn — Wed, 21 Aug 2024 20:19:11 GMT

Out of curiosity, what fuzziness value are people using?

Re: Task 3 - Enhancing CDS View Entities with Annotations

AVG — Thu, 22 Aug 2024 01:58:34 GMT

My Solution:

Re: Task 3 - Enhancing CDS View Entities with Annotations

gabby_isidro — Thu, 22 Aug 2024 02:47:06 GMT

Re: Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Thu, 22 Aug 2024 04:37:31 GMT

Thanks...please also show the value of 'Status' field search in screenshot

Re: Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Thu, 22 Aug 2024 04:46:15 GMT

hi,

Thanks for the response. Please provide a screenshot after adding a value help for Status field and also by searching without a '*' .

Re: Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Thu, 22 Aug 2024 04:52:43 GMT

hi,

Thanks for the response. Please provide a screenshot after adding a value help for Status field and also by searching without a '*' .

Re: Task 3 - Enhancing CDS View Entities with Annotations

sheenamk — Thu, 22 Aug 2024 05:08:12 GMT

hi,

Thanks for the response. Please search without a '*' .

Re: Task 3 - Enhancing CDS View Entities with Annotations

SachinArtani — Thu, 22 Aug 2024 08:41:21 GMT

Here's mine -