Task 3 - Enhancing CDS View Entities with Annotations

[sheenamk]

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.

1. Add annotations to display all the fields in the Fiori app by default.
2. Add annotations to provide a search field and enable search by ‘Description’ in the filter bar.
3. Add annotations to provide a value help filter on the ‘Status text’ field based on Overall Status text.
4. Add annotations to provide a filter for the Travel ID field.
5. Create a Service Definition
6. 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 :

1. 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 select an available value from the 'Status' field.

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

[mwn]

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:

[sheenamk]

Hi @mwn 

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

[mwn]

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

[sheenamk]

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

[mwn]

Despite following the YouTube video I still can't get a useful value help! It either has just "contains" or a list which doesn't get returned to the filter field.

[Nandhini_Thanikachalam]

Hi,

My Solution:

Thanks,

Nandhini Thanikachalam.

[BH2408]

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 

[Sivaiah_Bhiragani]

1. 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'.

[Sivaiah_Bhiragani]

[abaprules]

My solution:

[sheenamk]

hi,

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

[abaprules]

I added also the status value help.

[tim_matsypura]

Done!

[Sandra_Solis]

Done 🥳🥳🥳

[sheenamk]

hi,

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

[Sandra_Solis]

Done !!

[pankajgupta1992]

Hi Team,

Let's go!!

1. 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

[sheenamk]

hi,

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

[Silvi_]

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!😊

[mwn]

Out of curiosity, what fuzziness value are people using?

[AVG]

My Solution:

[Shilpa_Shankar]

Hi @AVG ,

Thanks for the submission. For better readability you can filter out on the Status Text instead of the Status Code.

Regards,

Shilpa

[AVG]

Hi @Shilpa_Shankar 

Please find the below output:

[gabby_isidro]

[SachinArtani]

Here's mine - 

[ayyappa_koneti90]

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

Search records based on a specific value (busniess) from 'Description' field and select an available value (Accepted) from the 'Status' field.

[rajesh_munusamy]

Done!! 

1. General Preview 

2.Dispaly data based on filter 

[rajesh_munusamy]

with out *

[sheenamk]

Hii,

  Thanks for the submission. For better readability you can filter out on the Status Text instead of the Status Code.

[d_orozco]

My solution:

• All the findings:

• Search by Description & Status:

[sheenamk]

Hi,

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

[gphadnis2000]

Here is my submission.

[Shilpa_Shankar]

Hi Gaurav,

Thanks for the submission. Could you add search field and enable Description to be searched.

[gphadnis2000]

Done.

[azaharescu70]

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'.

• Open Filter

• Accepted Filter

[Aslam2]

Hi, 

All Fields are displayed in Fiori App with " Search field"  "Description" "Travel id" and "Overall status Text" fields.

Value help for Overall status field.

Kindly review and let me know if any modifications are required.

Thanks.

[LF98]

Task 3:

1. Generell Preview

2. Display Data based on filter

[Chandana_Pamarthi]

Preview of the App showing all the columns, search and filter options and value help in the CDS view entity:

Regards,
Chandana.

[Shilpa_Shankar]

Hi @Chandana_Pamarthi ,

Thanks for the submission. For better readability you can filter out on the Status Text instead of the Status Code.

Regards,

Shilpa