ABAP CDS on HANA-1

cds

 Basic CDS View Creation

 

 

Open HANA Studio. Goto ABAP perspective. Open the project, Navigate to the package. Right click on the package & select New->Other ABAP Repository Object.

1

Expand Code Data Services & select DDL Source and finally select NEXT button.

2

Provide CDS view name & description. Select FINISH button.

3

The view editor opens up. Here we have to provide the details.

4


Provide SQL VIEW NAME, provide a meaningful end user text label, provide view type as BASIC.  

On the define view statement, provide the select form as “SFLIGHT”, mention the field names marking key fields. Activate and execute the view.

5


@AbapCatalog.sqlViewName: ‘ZSFLIGHTVIEW’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Flight Information’
@VDM.viewType: #BASIC
define view Zflight_View as select from sflight{
                     key sflight.carrid as AirlineCode,
                     key sflight.connid as ConnectionNumber,
                     key sflight.fldate as FlightDate,
                            sflight.price as Airfare,
                            sflight.currency as FareCurrency,
                            sflight.planetype as PlaneCategory,
                            sflight.seatsmax as MaxAvailableSeats,
                            sflight.seatsocc as OccupiedSeats
}


Here is the CDS view output.

6

Once the DATA Definition is activated,  ddl sql view is created.

7

8


Next Post– CDS view with Parameter


 

Advertisements

2 thoughts on “ABAP CDS on HANA-1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s