Consumption CDS View
The post describes about how to create a consumption view. A consumption view basically build upon a basic or composite view.
In this process will create:-
- A basic view on a DB table
- A Consumption view on the basic view
Creation of Basic View
@AbapCatalog.sqlViewName: ‘ZFLIGHTVW1’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Basic Airline View’
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION
define view Zflight_View1 as select from scarr
{
key scarr.carrid as AirlineID,
scarr.carrname as AirlineName,
@Semantics.currencyCode: true
scarr.currcode as AirlineCurrency
}
Data Preview
Creation of Consumption view on basic view- which is oData publish enabled
@AbapCatalog.sqlViewName: ‘ZFLIGHTVW2’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: ‘Consumption Flight View’
@VDM.viewType: #CONSUMPTION
@OData.publish: true
define view Zflight_View2 as select from Zflight_View1
{
key Zflight_View1.AirlineID,
Zflight_View1.AirlineName,
Zflight_View1.AirlineCurrency
}
Data Preview
SAPCODES 