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

[Prass]

Please find the below : 

[TuncayKaraca]

Task 1 Completed! 

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

[Alpesa1990]

My submission for task 1

[azaharescu70]

CDS Data Preview:

Code of the generator class:

[kedarT]

CDS Data Preview

Data generation class;

[fredymb]

Hi,

CDS View:

Generator Class:

[Jorge_Cervantes1]

1. Data preview of the CDS View Entity (no X found)

2 Logic in the ABAP class. In specific, the field ‘Status’ should only have values ( O, A or X ).

[tukitajr-HANA73]

😎

[MinhNguyenABVN]

Interesting! Ready for next week!

1. Data preview of the CDS View Entity

• 

1. Logic in the ABAP class. In specific, the field ‘Status’ should only have values ( O, A or X ).

• 

[Steffi1]

Data preview of CDS view:

Logic in the ABAP class. In specific, the field ‘Status’ should only have values ( O, A or X )

[ayyappa_koneti90]

Data preview of the CDS View Entity:

Logic in the ABAP class:

[PrakharAlok1]

My solution:

CDS view entity data preview - 

And the Data generation Class - 

[Valentin_BVA001]

CDS Preview:

Class Logic:

[adrianng]

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

[localConstantin]

Hello there,

my submission to the challenge:

CDS View output:

My ABAP class:

[vslakshmi]

Data preview of the CDS View Entity

Logic in the ABAP class

Task 1 Completed...

[spassaro]

Hi!

Data Preview of the CDS View 

ABAP Class

CLASS zcl_spassaro_travel_generator DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .

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



CLASS zcl_spassaro_travel_generator IMPLEMENTATION.
    METHOD if_oo_adt_classrun~main.
    DELETE FROM ZSPASSARO_TRAVEL.
    INSERT ZSPASSARO_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.

[SachinSinghg]

Week 1 challenge completed....😀😀😀

Data Preview.

ABAP Class Logic for loading data.

[shotokka]

Hi,

here's my solution:

and

[Yuvaraj_S88]

Completed! 

[Saikumar_Vendoti]

Hi,

My Solution

Output,

[SebSchlegel]

My solution for the Week 1 challenge 😊

The data preview of my own Travel database table:

The transformation class logic:

[Henning_T]

My Solution for Week 1 Challenge:

Data Preview of the CDS View:

My Method:

[rathnabalaji_rg]

Interesting. Done with Task 1.

CDS entity and data preview.

 

 Class and table 

[soni_opal]

TASK 1 : Solution :

data Preview: 

ABAP Class:

[Bharath369]

Hi, please find the below screenshots.

[Latifa]

CDS View Preview: 

The code:

CLASS zcl_travel_lha DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .

  PUBLIC SECTION.
    TYPES: ty_tab_flight TYPE TABLE OF zttravels_lha.
    INTERFACES : if_oo_adt_classrun.
    METHODS: main,
      collect_flights
        EXPORTING e_flights TYPE ty_tab_flight,
      map_flights
        IMPORTING i_flights        TYPE ty_tab_flight
        EXPORTING e_flights_mapped TYPE abap_boolean,
      display_flights
      .
  PROTECTED SECTION.
  PRIVATE SECTION.
    DATA : out TYPE REF TO if_oo_adt_classrun_out.
ENDCLASS.



CLASS zcl_travel_lha IMPLEMENTATION.
  METHOD : if_oo_adt_classrun~main.
    me->out = out.
    main( ).
  ENDMETHOD.
  METHOD main.
    me->collect_flights( IMPORTING e_flights = DATA(i_flights) ).
    me->map_flights( EXPORTING i_flights = i_flights IMPORTING e_flights_mapped = DATA(flights_are_mapped) ).
    IF flights_are_mapped EQ abap_true.
      me->display_flights( ).
    ELSE.
      out->write( 'An error has occured' ).
    ENDIF.
  ENDMETHOD.
  METHOD collect_flights.
    SELECT FROM /dmo/travel
    FIELDS client, travel_id, description, total_price, currency_code, status
    INTO CORRESPONDING FIELDS OF TABLE @e_flights.
    IF Sy-subrc NE 0.
    ENDIF.
  ENDMETHOD.

  METHOD map_flights.
    IF lines( i_flights ) GT 0.
      DATA: lt_flights TYPE ty_tab_flight.
      LOOP AT i_flights INTO DATA(ls_flight).
        CASE ls_flight-status.
          WHEN 'N' OR 'P'.
            lt_flights = VALUE #( BASE lt_flights ( client = ls_flight-client
                                                    travel_id = ls_flight-travel_id
                                                    description = ls_flight-description
                                                    status = 'O'
                                                    total_price = ls_flight-total_price
                                                    currency_code = ls_flight-currency_code
                                                     ) ).
          WHEN 'B'.
            lt_flights = VALUE #( BASE lt_flights ( client = ls_flight-client
                                                    travel_id = ls_flight-travel_id
                                                    description = ls_flight-description
                                                    status = 'A'
                                                    total_price = ls_flight-total_price
                                                    currency_code = ls_flight-currency_code
                                                     ) ).
          WHEN OTHERS.
            lt_flights = VALUE #( BASE lt_flights ( client = ls_flight-client
                                                      travel_id = ls_flight-travel_id
                                                      description = ls_flight-description
                                                      status = 'X'
                                                      total_price = ls_flight-total_price
                                                      currency_code = ls_flight-currency_code
                                                       ) ).
        ENDCASE.
      ENDLOOP.
      MODIFY zttravels_lha FROM TABLE @LT_flights.
      IF sy-subrc EQ 0.
        e_flights_mapped = abap_true.
      ENDIF.
    ENDIF.
  ENDMETHOD.

  METHOD display_flights.
    SELECT FROM zttravels_lha
        FIELDS *
        INTO TABLE @DATA(lt_flights).
    IF sy-subrc EQ 0.
      out->write( lt_flights ).
    ENDIF.
  ENDMETHOD.

ENDCLASS.

Any remarks on how I make the code better are welcomed 💙 

[Eyis]

Data Preview of CDS View

Class Logic

[Vara_reddy]

1. Data Preview of my CDS Entity 

2. Logic of my ABAP Class

Task - 1 is Done

[Srimathi]

Hi,
Task 1 Completed waiting for next task.

CDS Preview:

Class Logic:

[Nandhini_Thanikachalam]

Hi,

Task 1 completed and waiting for the next task :).

CDS Preview:

ABAP Class:

Thanks,

Nandhini Thanikachalam.

[sandeep-panwar]

Task 1 Completed.

1. DATA Preview:

2. Class logic:

[dla3076]

1. Data Preview

2. Class

[KenHsu97]

Task 1 Screen shot

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

[angelluis_sanz]

Here is

[Nkrish]

Hi,

1. Data Preview - CDS Entity
   

   2. Class Code : 

[ganeshprasadj34]

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

[Rambabu_Botsa]

Task 1 - Completed!!

Data View:

Method Implementation:

DISTINCT values of status:

[RajkumarRajagopal]

[Ayush-Rawat]

Data Preview of CDS - ZAR_TRAVEL_CDS

Data Generating Class - ZCL_AR_GEN_DATA