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!

[AVG]

Here is my CDS output:

Thanks.

[Alpesa1990]

My submission for task 2

[tim_matsypura]

done

[Anne009]

Task 2:

[gabby_isidro]

[Steffi1]

Hi

[EnryIrala]

Hello all, 

[styles]

Vanakam, Developer Advocates!

Here is the preview of the Task-2.

Warm Regards
styles
"Programming is not about what we know, it is about what we can solve!"

[YasinKoseoglu]

Done. 

CDS View:

[YogSSohanee]

Hello,

My submission for task 2.

[BerkayZdmr]

👍

[Vara_reddy]

Team,

I do not have the data for /DMO/I_Overall_Status_VH in my OP 2023 System So I have created the data using the Utility class which we built in task1. Here's the code. I'm not fan of INSERT statement so used the Modify statement to avoid runtime errors of key duplicacy. So even in my task-1 also I used the Modify statement though we can use INSERT.

Task 2: 

Thank you.

[Erol_CAGLAR]

[Ziynatullo]

TASK 2. Here we GOOO!!!

[EzgiKarabay]

👍💪

CDS View:

[darseidel]

Here's my solution:

[DineshkumarR1]

Hi @Shilpa_Shankar 

posting my solution here.

[Dani_]

CDS entity data preview

[symega2021_92]

Hi All,

CDS Output :

Kind Regards,

Guru

[sandeep-panwar]

Kindly find below the screenshot of Data Preview of the CDS View Entity.

Thanks.

[kunalchanda]

Answer:

Thank you 🙂

[Jorge_Cervantes]

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

[mz86]

Hello,

Datapreview 

[soni_opal]

Soution to Task2 :CDS view with concatenated pric and currency fields and overall status text

[Ayush-Rawat]

Data Preview of Associated and Concatenated values.

[jormancacua]

Hello abapers!

Here is my solution for Task 2:

Have a great day!

Jorman 

[tukitajr-HANA73]

T@sk 2 😎

[Ihor_Haranichev]

Hello All.

My solution is:

[kirankumar_angar]

Hello  Team,

Here is the Validation 
1) Price with Currency
2) Overall Status Text

[ajay_110125]

Task - 2

[ManojKumarVarma]

Hi, I have completed the week-2 challenge. Please check the attached screenshot.

Regards,
Manoj Kumar Potharaju.

[RahulChowdaryMaganti]

Hi, I have completed the week 2 challenge please check the attached screen shot.
1. Concatenate the total price and currency code.
2. Overall Status Description.

Thanks & Regards,
Rahul.

[vazhz]

Hello All,
Here is the validation result of task 2 with two new fields one is concatenated field with price & currency, the other is status text which is associated with the view /DMO/I_Overall_Status_VH.

Waiting for the next task.. 😊

[localConstantin]

Hello,

here is my submission:

[RafkeMagic]

[vgirish22]

Hi,

Completed the task 2 with concatenated value of Total_Price and Currency_Code and Overall Status Text.

[diveshkalra]

Task2:

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

[jakub_plocki]

Hi,
please find data preview for my Week 2 CDS view (new columns: PriceWithCurrency, StatusText)

[SROUT]

Hi @Shilpa_Shankar ,
Please find below screenshot

Data Preview of the CDS View Entity which contains,

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

[SRIVIDYA_AVADHANI_16]

Hello !