topic Re: Task 2 - CDS View Entity Associations ( August Developer Challenge ) in Application Development and Automation Discussions

Task 2 - CDS View Entity Associations ( August Developer Challenge )

Shilpa_Shankar — Fri, 23 Aug 2024 16:14:18 GMT

Thanks for the enormous response and showing great enthusiasm in Task 1. Let’s continue the ABAP Developer Challenge by enhancing the CDS view entity.

Task 2 - In this task, we will explore some basic SQL function, CDS Associations and use it to enhance the CDS View entity that is created in Task 1.

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.

Here you go:

Create a new field in the CDS view entity created in task 1 and use String function to concatenate Total_Price and Currency_Code.
1. https://help.sap.com/doc/abapdocu_cp_index_htm/CLOUD/en-US/index.htm?file=abencds_sql_functions_character_v2.htm
Since we have Status field in the CDS view entity, let us create an association with /DMO/I_Overall_Status_VH to fetch the corresponding Text field.
1. https://help.sap.com/docs/abap-cloud/abap-data-models/cds-associations?locale=en-US&version=s4_hana
Expose the Text field from the association and give a name to the newly created field. This should return the text value of the Status (Overall Status Text)

Note: For those who do not have data in the status text table, try running the data generator class /dmo/cl_flight_data_generator. This should load that table with initial data.

Validation: Share a screenshot of the following items as a reply to this thread to gain credits:

Data Preview of the CDS View Entity which contains,
1. 1 new field with concatenated value of Total_Price and Currency_Code.
2. 1 new field with Overall Status Text

Note: Do not post the screenshot of the CDS view entity. Just Data preview is sufficient.

Enjoy until we are back with the next task!

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

BH2408 — Wed, 14 Aug 2024 09:02:07 GMT

Hi Team,

Here we go.

We can use the localized here since it is not project to get the login lang.

Please review and let me know.

Thanks and Regards,

Bharani

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

PrakharAlok1 — Wed, 14 Aug 2024 09:19:18 GMT

Considering login language as default, enhanced CDS view may look like -

And the Data preview -

Thank you.

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

gaurav33 — Wed, 14 Aug 2024 10:13:37 GMT

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

geek61 — Wed, 14 Aug 2024 10:24:39 GMT

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

Saikumar_Vendoti — Wed, 14 Aug 2024 10:31:20 GMT

Hi Everyone,

Here My solution,

Output,

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

ShivamChadha — Wed, 14 Aug 2024 10:34:34 GMT

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

SachinSinghg — Wed, 14 Aug 2024 10:43:22 GMT

Hello Everyone, as part of progress I completed week 2 challenge...😃😀😀

Data Preview:

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

rajesh_munusamy — Wed, 14 Aug 2024 10:43:55 GMT

Done!! please find the below solution

Data preview

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

Rambabu_Botsa — Wed, 14 Aug 2024 10:53:28 GMT

Thank you for this initiative!

Task 2 - Completed!

New fields added:

CDS View with association:

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

Sarath_Kumar — Wed, 14 Aug 2024 11:05:27 GMT

Hi @Shilpa_Shankar ,

Task 2 Completed.

Screenshot:

1) Data Preview of the CDS View Entity which contains,

a) 1 new field with concatenated value of Total_Price and Currency_Code and new field with Overall Status Text.

b) CDS View Entity.

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

J_Eck — Wed, 14 Aug 2024 11:23:01 GMT

Done.

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

SebSchlegel — Wed, 14 Aug 2024 11:28:23 GMT

Hi,

here is my solution for week 2 🙂

Greetings

Sebastian

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

Kaleshavalli — Wed, 14 Aug 2024 11:37:07 GMT

Thank you for the Task 2 . Very sweet and short task that covers SQL functions and CDS Annotations.

Here is the screen shot of completed Task 😊. Thank you so much.

Thanks & Regards,
Kalesha.

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

SachinArtani — Wed, 14 Aug 2024 11:37:29 GMT

Heya! Here is the data preview screenshot -

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

adrianng — Wed, 14 Aug 2024 11:51:14 GMT

Hi!, here is the data preview ss.
Thanks for for the Task 2.
Best regards

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

SushmitaG98 — Wed, 14 Aug 2024 11:59:33 GMT

Please find below the submission of week 2

Regards,

Sushmita

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

gphadnis2000 — Wed, 14 Aug 2024 12:30:13 GMT

My Submission.

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

Silvi_ — Wed, 14 Aug 2024 12:41:03 GMT

Hello,

My results for Task 2 of August developer challenge:

Thank you!

Re: Task 2 - CDS View Entity Associations ( August Developer Challenge )

pankajgupta1992 — Wed, 14 Aug 2024 12:53:57 GMT

Hi Team ,

Let's go!!

Here is the data preview with new fields:

Thanks & regards,

Pankaj Gupta