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

[abaprules]

Here's my solution:

[SarahCohen]

Thanks!

[AndreaUS]

Data preview CDS view entity:

data generator class: 

[ArunaShibane]

Can anyone explain why client field is not added as part of select statement while moving the data to custom table?

[mwn]

The ABAP open SQL statements are designed to handle the client number automatically. This can be overwritten by using some special syntax, but its use is discouraged because it can lead to security issues.

[tobiasz_h]

Hello,
My solution:

[babu4abap]

1. CDS view preview

2. Logic in the class to update the data and status field

[symega2021_92]

Hi ,

I completed Task 1,Please find the below screen shots.

Kind Regards,

Guru

[Tharun_Kumar_M]

Task 1 Completed!

CDS View output :

Class to update data in database table :

Waiting for Task 02.

[OanaVladescu]

Hello 😁,

Here is my submission for Task 1:

1. Data preview of the CDS View Entity
2. Logic in the ABAP class

Kind regards,                                                                                                                                                          Oana

[pankajgupta1992]

My Solution:

Data Preview:

Logic in ABAP Class:

[sarahf]

[BerkayZdmr]

👍 💪

 

[EzgiKarabay]

💪 👍

My class logic :

My CDS view:

[DineshkumarR1]

Attaching the screen shots.

[mtunc]

Done 💪

Class logic;

Data preview;

 

 

[abhijitzope]

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

[MallareddyBuchammagari]

Table

Class to generate data:

CDS view entity

Output of CDS view:

[vgirish22]

CDS view preview

ABAP Class

CLASS zcl_gv_travel_data_copy DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .

  PUBLIC SECTION.

    INTERFACES if_oo_adt_classrun .
  PROTECTED SECTION.
  PRIVATE SECTION.
ENDCLASS.

CLASS zcl_gv_travel_data_copy IMPLEMENTATION.
  METHOD if_oo_adt_classrun~main.

    DATA lt_traveldt TYPE TABLE OF ztl_travel_data.

    DELETE FROM ztl_travel_data.

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

    IF lt_traveldt IS NOT INITIAL.
      INSERT ztl_travel_data FROM TABLE lt_traveldt.
      IF sy-subrc = 0.
        out->write( 'Travel data inserted' ).
      ELSE.
        out->write( 'No data inserted' ).
      ENDIF.
    ENDIF.

  ENDMETHOD.
ENDCLASS.

[Praveengopal]

Solution: ABAP Class and Preview

[StevenNguyen]

My solution.

[ruchiraushan38]

Class

[SushmitaG]

Hi @sheenamk,

Please find below my submission of week 1

CDS View data Preview

Data preview of database table

 

Class to update the table

Regards,

Sushmita

[barisguler]

Hello all,

CDS data preview

Class

[geek]

Borrowed heavily from:

Create Database Table and Generate UI Service | SAP Tutorials

Also followed @thomas_jung idea of mapping the domain to its description. Is there a technically elegant way of doing that?

[thomas_jung]

I've already completed all four weeks of the challenge during testing.  So, my screenshot contains a few fields that will be part of future week challenges as well. The extended description field is part of next week I believe. 

[jormancacua]

Awesome!

[jormancacua]

Hello SAP abapers community!

Here is my Solution: 

CDS view entity:

Data preview CDS entity:

Data class generator:

Custom table:

Best regards.

Jorman 

[Föß]

Hi,

my solution:

[jochenlittleq]

My solution.

CDS View:

Class:

[govendan_annadurai]

Task 1 - Completed!

Class

Data Preview of CDS View

[asm_sapdev]

[NKA1]

Data Preview:

Code:

[vazhz]

Task 1 Completed,

1. Class Logic

2. Data Preview.

Done with the task 1 and waiting for the next task..... 😊

[kngupta141]

Here is my code and output

[halfknight]

This is my solution:

[arunnaik]

1. Data preview of the CDS View Entity:
   
2. Logic in the ABAP Class:
   

[Neethu_Lohi]

Data preview of the CDS View Entity

ABAP Class

[this_yash]

My Solution:

[miguelandher]

Buen día, 

Comparto mi solución:

Saludos