Exercise: Creating Custom CDS Views

Using in-app extensibility features, create a custom CDS View.

For the execution of this exercise, you need to logon to your SAP S/4HANA Cloud tenant by means of a user with administrator rights.

In this exercise, replace ### with your user number. This number was introduced to allow multiple users to execute the same exercise in a shared system. It can be any number between 000 and 999.

1. Assign your user with the following roles:

   Business Role	Business Role ID
   Administrator	BR_ADMINISTRATOR
   Configuration Expert	BR_BPC_EXPERT
   Project Manager - Commercial Services	BR_PROJ_MANAGE_COMM
   Sales Manager	BR_SALES_MANAGER
   Internal Sales Representative	BR_INTERNAL_SALES_REP

2. Create a custom CDS view using the Quotation Period ### name (replace ### with your user number), based on the I_SalesQuotation data source, related to sales quotations. Use the following data:

   Field	Value
   Label	Quotation Period ###
   Name	YY1_QuotationPeriod###
   Scenario	Standard CDS View

3. Add the following columns to the view:

   Item
   CreationDate
   SalesOrganization
   SoldToParty

4. Add a calculated column, named QuotationPeriod, based on the following information:

   Field	Value
   Name	QuotationPeriod
   Label	Quotation Period
   Formula	concat(substring(I_SalesQuotation.BindingPeriodValidityStartDate,1,6),concat('/',substring(I_SalesQuotation.BindingPeriodValidityEndDate,1,6))) formula.txt

5. Publish and preview the view.