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

Task 1 - Create CDS View Entity ( August Developer Challenge )

sheenamk — Thu, 08 Aug 2024 16:16:11 GMT

First of all, thanks for the overwhelming response to the ABAP Developer Challenge. Kudos to everyone who took time out of their busy schedule and finished the pre-requisite – Task 0 last week.

Now let us dive right into the challenge.

Task 1 - In this challenge, we will create a custom table and explore the creation of CDS view entity from it. This also includes writing a simple logic to generate data into this table and to replace the existing values in a specific field.

Follow the instructions carefully and share with us the screenshots of the items mentioned in the ‘Validation’ section of this discussion.

Note: As suggested in Task 0 , please ensure that you give a unique ID ( something that can relate to your SAP Community ID ) to all your development objects.

Please use this separate thread to ask your questions and discuss issues.

So, let’s get started:

Create a database table with the following fields:
1. Client as Key
2. Travel Id as Key
3. Description
4. Total Price
5. Currency Code
6. Status
Create an ABAP class which will generate data from the table /dmo/travel to the newly created database table.
Write a logic in the ABAP class to map the below values to replace the existing value in the ‘Status’ column.
1. N --> O
2. P --> O
3. B --> A
4. For all other values update --> X
Check the Data Preview of the table. The ‘Status’ column should have the distinct values specified in Step 3
Create a CDS view entity using ADT with reference to the above created table.
1. Help Document for CDS View Entitiy
Once the CDS View entity is created, check the fields created. Add the 'Currency Code’ annotation for ‘Total Price’ field. Save, Activate and check the Data Preview.

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

Data preview of the CDS View Entity
Logic in the ABAP class. In specific, the field ‘Status’ should only have values ( O, A or X ).

Enjoy!!!!

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

thomas_jung — Wed, 07 Aug 2024 12:26:18 GMT

My Solution:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

mwn — Wed, 07 Aug 2024 14:30:44 GMT

CDS view preview:

Class file to copy data after using the code cleaner:

CLASS zcl_mwn_travel_copy IMPLEMENTATION. METHOD if_oo_adt_classrun~main. insert zmwn_travel from ( select travel_id, description, total_price, currency_code, case when status = 'N' then 'O' when status = 'P' then 'O' when status = 'B' then 'A' else 'X' end from /dmo/travel ). ENDMETHOD. ENDCLASS.

Distinct values for status (looks like there are no unexpected statuses)

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

RichHeilman — Wed, 07 Aug 2024 14:37:46 GMT

Fun!!!

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

szubair — Wed, 07 Aug 2024 15:30:57 GMT

Hi,

Please find the screenshots below:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

mwn — Wed, 07 Aug 2024 15:09:12 GMT

I don't think you want to just copy the top 100 rows to your new table

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

gphadnis2000 — Wed, 07 Aug 2024 15:10:51 GMT

Hi,

Please find below screenshot.

Thanks and Regards,

Gaurav Phadnis

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

Silvi_ — Wed, 07 Aug 2024 15:15:53 GMT

CDS Data Preview:

Class logic (still needs improvement 🙃)

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

rajesh_munusamy — Wed, 07 Aug 2024 15:42:45 GMT

CDS view entity

ABAP CLASS

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

YogSSohanee — Wed, 07 Aug 2024 16:29:55 GMT

Hello,

Interesting way to start the challenge, had fun!

Logic in the ABAP class:

Data preview of the CDS view entity : ZYSS_I_TRAVEL

Looking forward to the next challenge.

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

BH2408 — Wed, 07 Aug 2024 16:37:45 GMT

Hi Team,

Here is the Data Preview of CDS Entity:

ABAP Class:

Thank you!!!

Best Regards,

Bharani

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

SachinArtani — Wed, 07 Aug 2024 17:10:19 GMT

My Solution -
Data Preview -

There is no other value in travel table, hence in the custom table, there is no entry for status = 'X'.

Logic:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

UsamaKhan — Wed, 07 Aug 2024 18:58:02 GMT

CB9980002351

CDS View Preview:

Class Logic:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

M-K — Wed, 07 Aug 2024 19:16:21 GMT

My submission for this task.

ABAP Class:

CDS-View Preview:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

thomasks — Wed, 07 Aug 2024 19:41:13 GMT

Data Preview:

Logic to fill db table:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

Anu_Nair — Wed, 07 Aug 2024 20:11:18 GMT

CDS data preview

Class-method

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

Sivaiah_Bhiragani — Wed, 07 Aug 2024 20:40:11 GMT

CDS view Data Preview :

Data Generating Class:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

aaruljothi — Wed, 07 Aug 2024 20:40:23 GMT

Hello,

Thank you for the week 1 challenge. Below are my screenshots:

Data Preview of CDS view entity

Class Logic:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

AVG — Wed, 07 Aug 2024 20:54:42 GMT

My Solution:

Re: Task 1 - Create CDS View Entity ( August Developer Challenge )

kasch-code — Wed, 07 Aug 2024 20:56:53 GMT

Hi all,

Here is my solution for the task!

Data Preview of the CDS View Entity:

Code of the generator class:

CLASS zcl_p350812_generate_data DEFINITION PUBLIC FINAL CREATE PUBLIC. PUBLIC SECTION. INTERFACES if_oo_adt_classrun. PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. CLASS zcl_p350812_generate_data IMPLEMENTATION. METHOD if_oo_adt_classrun~main. DATA travels TYPE STANDARD TABLE OF zp350812_travel. " Delete existing data in travel table DELETE FROM zp350812_travel. " Select data from demo table and apply mapping for status SELECT travel_id, description, total_price, currency_code, CASE status WHEN 'N' THEN 'O' WHEN 'P' THEN 'O' WHEN 'B' THEN 'A' ELSE 'X' END AS status FROM /dmo/travel INTO CORRESPONDING FIELDS OF TABLE @travels. " Insert modified data into travel table INSERT zp350812_travel FROM TABLE @travels. out->write( |{ sy-dbcnt } records inserted into travel table.| ). ENDMETHOD. ENDCLASS.