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

[sheenamk]

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:

1. 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
2. Create an ABAP class which will generate data from the table /dmo/travel  to the newly created database table.
3. 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
4. Check the Data Preview of the table. The ‘Status’ column should have the distinct values specified in  Step 3
5. Create a CDS view entity using ADT with reference to the above created table.
   1. Help Document for CDS View Entitiy
6. 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:

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

Enjoy!!!!

[stickman_0x00]

[Ihor_Haranichev]

CDS preview:

Class:

[Kaleshavalli]

Successfully Completed the Task 1 🙂 So Nice Exercise . Thank you.

Thanks & Regards,

Kalesha.

[Momaharshi]

Completed!!

[RakeshDevani]

CDS Preview:

ABAP Class:

And Status Having only values O, A, or X

[Naveen_srinivasan]

1. Data Preview of the CDS:

2. Logic in ABAP Class

Best Regards,
Naveen

[jonwalnikhilesh]

Please find below solution.

[RLi2340]

Hello,

Here are my screenshots - 

[styles]

Eager for more!!!

Class Logic:

CDS View Entity Preview:

"Programming is not about what we know, It is about what we can solve"

[RahulChowdaryMaganti]

Hi please find the attached screen shots below.

CDS view Preview

Class logic

Thanks & Regards,
Rahul.

[gabby_isidro]

[p215636]

Screen shot 1

Screen Shot 2

I was going to highlight that given the distribution of values in the base table /DMO/TRAVEL within the ABAP Cloud Trial you wouldn't see any X's was that intentional..

[ivansofronic]

CDS view preview

Class logic

CLASS zis_cl_travel_copy DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .

  PUBLIC SECTION.
    INTERFACES if_oo_adt_classrun.
  PROTECTED SECTION.
  PRIVATE SECTION.
ENDCLASS.



CLASS zis_cl_travel_copy IMPLEMENTATION.
  METHOD if_oo_adt_classrun~main.
    INSERT zis_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.

[RazCherishya]

Task1 Completed.

Class logic

Data Preview/Output.

Distinct Value.

[Srinath_Mareedu]

CDS_viewStatus_logic

[SUNDHARRAJAN]

Task 1 - Completed.

[MatLakaemper]

Here my Submission:

kind Regards,
Matthias Lakämper

[Laco]

[rohantiwari]

My Solution :

[SingireddySunil]

Submission of Task - 1:

CDS Preview: -

Class : -

[JerryW]

Here is my submission - thanks!

Data preview of the CDS View Entity

Logic in the ABAP class. 

[viveksingh]

Data Preview of CDS View Entity

ABAP Class

[ThienPHAM]

So excited.

CLASS zcl_travel IMPLEMENTATION.

  METHOD if_oo_adt_classrun~main.
    INSERT ztbtravel 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.

[maennflo]

Here we go.

A little bit more SE80 style from me.

Class implementation:

Result in CDS view:

[Harsh_Hunjan]

1. CDS Data preview

2. Logic in the ABAP class.

[J_Eck]

CDS View Data Preview

Class

[Ravindhiran75]

Hi,

My Solution:

Regards,

Ravindhiran.

[SROUT]

For task1 challenge
Here is the preview of the CDS view entity data preview

Here is the ABAP class code

[rdulek]

Please find below screenshot.

[siva1990]

Hello Team,

Plea

se find the screenshots below,

[Bhumika_K]

 Task - 1: Completed, please find my submission below

Class:

CDS Preview:

Thank You,

Bhumika

[Jay_Dalsaniya]

CDS Data Preview

ABAP Class to copy data to new table

[fahadburney]

Completed the First Task 😀

1)Data Preview of Database Table : ZDMO_TRAVEL_DB

2)Class Logic : 2 screenshots : ZCL_GENERATE_DATA_DMOTRAVEL

3)Data Preview for CDS View : ZCDS_DMO_TRAVELMFB 

[Kartheek]

Here it is!!
Data preview of the CDS Entity:

Generator class:

[TwanHunguyen01]

Hi, here is my screenshots:

If you think there could be improvement in my work, please let me know. Thank you.

[EnryIrala]

My solution.

[bruno_bonatti82]

Hello!

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 ).

CDS View Entity

[Akshay_Yelekar]

Task 1...Done...!

[Anne009]

Hi, Task 1 Completed.

Preview: With old status vs new status.

Class to update the database table.

[d_orozco]

My solution: