ABAP CDS ON HANA-(4)ヘッダー行編集

Explicit Name List use in CDS

We create a simple CDS View like below.

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

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

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

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

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