ABAP CDS on HANA-4

cds

Explicit Name List use in CDS

 

 

We create a simple  CDS View like below.

3.jpg

 


@AbapCatalog.sqlViewName: ‘ZSFLIGHT_EXP’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Flight Information’
@VDM.viewType: #BASIC

define view Zflight_Exp_View
as select from sflight{
           key sflight.carrid ,
           key sflight.connid ,
           key sflight.fldate ,
           sflight.price ,
          sflight.currency ,
           sflight.planetype ,
          sflight.seatsmax ,
          sflight.seatsocc
}


Run the View/Data Preview- The column heading appears same as the column names.

4


 We can explicitly define the Column Name list as below(list  name numbers should be equal to the selection column numbers)

1


@AbapCatalog.sqlViewName: ‘ZSFLIGHT_EXP’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Flight Information’
@VDM.viewType: #BASIC

define view Zflight_Exp_View
// Expicit Name List
(Code, AirName, FDate, Fare,Curr, Cat, Max_seat, Ava_seat)
as select from sflight{
     key sflight.carrid,
     key sflight.connid,
     key sflight.fldate,
      sflight.price,
      sflight.currency,
      sflight.planetype,
      sflight.seatsmax,
      sflight.seatsocc
}


The output list column names same as what is mentioned in the explicit name list.

2



Even we have another way of explicitly defining column names  by using ‘as   expcolumnname, in the selection list.

5


@AbapCatalog.sqlViewName: ‘ZSFLIGHT_EXP’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Flight Information’
@VDM.viewType: #BASIC

define view Zflight_Exp_View
// Expicit Name List
// (Code, AirName, FDate, Fare,Curr, Cat, Max_seat, Ava_seat)
as select from sflight{
      key sflight.carrid as Code,
      key sflight.connid as AirName,
      key sflight.fldate as FDate,
       sflight.price as Fare,
       sflight.currency as Curr,
       sflight.planetype as Cat,
       sflight.seatsmax as MaxSeat,
       sflight.seatsocc as AvaSeat
}


The output list column names appear same as what is mentioned in the selection list.

6


 

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s