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]

Yes, I'm interested in the task

[Tharun_Kumar_M]

Hi, Task 2 completed.

Waiting for Task 3.

[VinodhBabu]

Data preview of CDS view Entity with Status Description and Total Value with currency.

Thanks

Vinodh

[RonyPhilip]

Hi,

Data Preview of the CDS View Entity with the 2 additional fields:

[mtunc]

Hi,
here is my data preview for task 2 (new columns: totalprice_curr, overall_status_text)

 

[Laco]

Hi All,

[Henning_T]

Task 2 - CDS-View Preview

[Prass]

Please find the below solution:

 

 

[Eyis]

Task 2: CDS View - Data Preview

[MinhNguyenABVN]

Im ready!!!

[angelluis_sanz]

Here is

 

[UsamaKhan]

CB9980002351

Preview:

Thanks and regards,

Usama Khan

[Bhumika_K]

Hello
Please find Data Preview of the CDS View Entity with new columns: PriceWithCurrency, StatusText

[MatLakaemper]

Here my submission,

kind Regards,
Matthias Lakämper

[Nandhini_Thanikachalam]

Hi,

Task Completed 🙂

Thanks,
Nandhini Thanikachalam.

[ganeshprasadj34]

[Rajini88]

Done.

[stickman_0x00]

[RajkumarRajagopal]

[vslakshmi]

Task 2 done, Please review 

Regards,

Lakshmi

[Momaharshi]

Hi, 

Data preview for Task 2:

[Aditya1231]

My Solution : 

[aaruljothi]

Hello,

Below screenshot of data preview with additional fields, Thank you

[PedroARomero]

Hi, this is my solution to Task 2

[jonwalnikhilesh]

Hi, Below is the solution for Task 2

CDS result with Amount in Text

CDS result with Amount in Text and Overall Status Text 

[Shilpa_Shankar]

Thanks and if you have completed the task 2, post your screenshot to get a badge.

[Shilpa_Shankar]

Thanks and if you have completed the task 2, post your screenshot to get a badge.

[Shilpa_Shankar]

Thanks and if you have completed the task 2, post your screenshot to get a badge.

[Ravindhiran75]

Hi,

Task completed.

Regards,

Ravindhiran.

[Aslam2]

Hi,

Please find the below data preview of CDS.

Data Preview:

[Shilpa_Shankar]

Kindly send the screenshot of the CDS view..

[Shilpa_Shankar]

Kindly post the screenshot of the CDS view and data preview of the CDS view that you have created. The above screenshot is from another participant.

[Naveen_srinivasan]

Data Preview of CDS View entity.

Best Regards,

Naveen 

[AdilBasha1SAP26]

[Alamas0210]

We already tried recreating the time dimensions - without success.
This is what the view looks like for us, the field "DAY_OF_W_SAP" is not available.

[Shilpa_Shankar]

Are you referring to the above mentioned task?

[Alamas0210]

Yes, I'm interested in the task

[Shilpa_Shankar]

Kindly post the screenshot of the CDS view and data preview of the CDS view that you have created. The above screenshot is from another participant 'Aslam2'.

[siva1990]

Hi Team,

Please find my results below,

Regards

[Alamas0210]

Yes, I'm interested in the task