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

[Shilpa_Shankar]

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:

1. 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_char... 
2. 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
3. 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:

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

[Shilpa_Shankar]

Kindly post your questions related to the task in this discussion: https://community.sap.com/t5/application-development-discussions/questions-re-quot-abap-core-data-se...

The screenshot that you have posted is not related to this task. 

[namshagiri_s1]

[Srimathi]

Hi Team,

Task 2 Completed.

Thanks.

[achal_mukaty]

Created CDS View Entity with added new concatenated field of total price and currency code and Overall status text field using Association.

Result :

Happy Learning! 😊

Thanks

[SUNDHARRAJAN]

Hi,

Task 2 is completed.

[Srinath_Mareedu]

[Ananth27]

Hello,
Below is the Data Preview of my CDS View Entity.

[rdulek]

Task2 done!

[tobiasz_h]

Hello,

[ThienPHAM]

Thanks for designing the exciting exercises. Here is my outcome for 2nd week

[kyo_choi2]

Week2 completed.

[rathnabalaji_rg]

Done for week2.

[Chandana_Pamarthi]

Task- 2:

CDS View Preview:

[this_yash]

Here's My Solution.

[mohit_dev]

My result:

[barisguler]

Hello,

Here is my second week submission.

[Bharath369]

Task 2:

[maennflo]

Hi.

Here is my result preview after adding the two new columns:

Regards, Florian

[Nkrish]

Hi, 

Data Preview of new created fields 

[p215636]

CDS Preview for Task 2

[maynhincaichogi]

Hi, Task 2 completed.

[Shilpa_Shankar]

Hi,

The above screenshot is from another participant. Kindly send the screenshot of your CDS view.

[RakeshDevani]

Here is my Solution:

[Kartheek]

Hello ,

Here is the data preview!!

[Ajay19]

Hi,

Below is the data preview of Week2 CDS View

Thanks

Ajay

[Akshay_Yelekar]

Task 2 Done...!

[babu4abap]

Thanks Shilpa and Sheena for this month challenge.

Task 2 is completed.

[MallareddyBuchammagari]

Result for Task 2:

[SingireddySunil]

Hi @Shilpa_Shankar,

Here is my submission of Week2 Challenge

[Shky]

Done!

I get the following warning though for the line _Status._Text.Text as StatusText: 
The association "_Text" can modify the cardinality of the result set ZENTITY_SHAL_TRAVEL (Data Definition) /TRL_EN/.adt/ddic/ddlsources/zentity_shal_travel line 17 ABAP Syntax Check Problem

[Shilpa_Shankar]

Yes, the warning comes up as there is a potential for the data to be altered like example if it has translations. To avoid this, you can filter out by specifying the language and add '1' to document the change cardinality. Check this link for more information: https://learning.sap.com/learning-journeys/acquire-core-abap-skills/using-associations-in-path-expre...

[Mohammed_Nabeel]

I initially worked on these exercises in an on-premise system but couldn’t find data in the status text table /dmo/oall_stat. Later, I switched to a cloud environment to execute both Task 1 and Task 2. For Task 2, I executed the class /dmo/cl_flight_data_generator and successfully loaded data into the same status text table, achieving the desired output

1. Only data preview for task 2 

[RichHeilman]

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

Cheers,

Rich Heilman

[Mohammed_Nabeel]

Thank you @RichHeilman , Your suggestion worked in cloud environment.

[JerryW]

Here is my submission - thanks!

[RichHeilman]

Fun stuff!!!!

Thank you!!!

[miguelandher]

Mi Solucion.

Saludos

[Joy_Ragavie]

Task2 Solution

[Joy_Ragavie]

Task2 Solution

[Jay_Dalsaniya]

Task 2