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

[thomas_jung]

My Solution:

[mwn]

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)

[PedroARomero]

Task 1 Completed!

The class

[RichHeilman]

Fun!!!

[szubair]

Hi, 

Please find the screenshots below:

[mwn]

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

[Ananth27]

Hello!
Below is my Solution 
Data Preview:

Source Code:

Thanks!!

[gphadnis2000]

Hi,

Please find below screenshot.

Thanks and Regards,

Gaurav Phadnis

[sheenamk]

Please attach the screenshot of the new value mapping logic.

[gphadnis2000]

here is the mapping.

[Silvi_]

CDS Data Preview:

Class logic (still needs improvement 🙃)

[rajesh_munusamy]

CDS view entity

ABAP CLASS

[YogSSohanee]

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.

[BH2408]

Hi Team,

Here is the Data Preview of CDS Entity:

ABAP Class:

Thank you!!!

Best Regards,

Bharani

[SachinArtani]

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:

[UsamaKhan]

CB9980002351

CDS View Preview:

 Class Logic:

[M-K]

My submission for this task.

ABAP Class:

CDS-View Preview:

[thomasks]

Data Preview:

Logic to fill db table:

[Anu_Nair]

CDS data preview

Class-method

[Sivaiah_Bhiragani]

CDS view Data Preview :

Data Generating Class:

[aaruljothi]

Hello,

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

Data Preview of CDS view entity

Class Logic:

[AVG]

My Solution:

[kasch-code]

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.

[Ruthiel]

Here is my submission:

CDS Preview:

ABAP Logic:

[Sandra_Solis]

done !! 🥳🥳🥳

[tim_matsypura]

Done 🙂

[ajos]

[gaurav33]

[FreddieOliva]

Done:

[ajay_110125]

CDS View

And It's data

Copy Class

And Table

[Sarath_Kumar]

Hi @sheenamk , 

Task 1 is completed.

Screenshot:

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

[ShivamChadha]

Data preview of the CDS view entity: 

Logic in the ABAP class:

[Aslam2]

Hi,

CDS View Entity:

Data preview of CDS View

Table 

Class and logic 

Distinct entries logic

[manishagb]

[AAncos]

Task 1, OK.

[YasinKoseoglu]

Ok 🙂

CDS View;

Class Logic;

[mtunc]

Looking good !! 

[YasinKoseoglu]

thanks you 🙂

[Ojeswini_Sanaka]

Hi @sheenamk ,

I completed this week's task.
Screenshots:

1.Data preview of the CDS View Entity

2.Logic in the ABAP class. The field ‘Status’ allows only ( O, A and X ).