@AbapCatalog.sqlViewName: 'zjerrySQL0309'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'test 20160309'
@ObjectModel: {
   createEnabled,
   deleteEnabled,
   updateEnabled
}
define view Zjerrytest20160309
as select from spfli association [0..1] to scarr as _scarr
on _scarr.carrid = spfli.carrid {
       key spfli.carrid,
       key _scarr.carrname,
       key spfli.connid,
       spfli.cityfrom,
       spfli.cityto
}
@AbapCatalog.sqlViewName: 'z20160316'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'test odata publish '
@OData.publish: true
@ObjectModel: {
   type: #CONSUMPTION,
   compositionRoot,
   semanticKey: ['Actor'],
   createEnabled,
   deleteEnabled,
   updateEnabled
}
define view Zjerrytest20160316 as select from Zjerrytest20160309 {
    @UI.lineItem : [{position:10}]
    key Zjerrytest20160309.carrid as Jerryid,
    @UI.lineItem : [{position:20}]
    key Zjerrytest20160309.carrname as name,
    @UI.lineItem : [{position:30}]
    key Zjerrytest20160309.cityfrom as startLocation,
    @UI.lineItem : [{position:40}]
    key Zjerrytest20160309.cityto as target,
    @UI.lineItem : [{position:50}]
    key Zjerrytest20160309.connid
}