Skip to Content

Create and Expose Custom CDS Views

Create a custom CDS view from an existing data source and expose it as a Web Service.
You will learn
  • How to create a CDS view to minimize a data set exposed to customer
  • How to expose the CDS view as a web service
mervey45Merve TemelNovember 30, 2021
Created by
Lsubatin
August 3, 2017
Contributors
Lsubatin
mervey45

Prerequisites

Assign the Business Catalog SAP_CORE_BC_EXT and SAP_CORE_BC_COM to your user.

  • Step 1

    Navigate to the Extensibility category and press the Custom CDS Views tile to start the application on your Fiori Launchpad.

    start Custom CDS View App
  • Step 2

    This brings you to the data source list of the available data sources for Custom CDS Views.
    Search for a data source you want to use as a basis and select the data source (1) I_Customer.

    This is the primary data source of the new Custom CDS view.

    Select Data Source

    Now execute create (2) to create a new Custom CDS view.

  • Step 3

    On the general tab enter name YY1_New_Customer and label New Customer.

    Select Data Source
  • Step 4

    This step is used to tailor a given CDS View to the needs of a customer.
    Now switch to the Field Selection tab and select following fields (1):
    - Customer
    - CustomerName
    - CustomerFullName
    - Country
    - CityName
    - PostalCode
    - StreetName
    These fields will be available in the custom CDS view.

    Select Data Source

    Now save and publish the view.

    Result:
    This saves and activates the view.
    In case the primary data source is access protected, the new view is protected, too.

  • Step 5

    Switch back to the general tab to generate an OData Service by checkmarking it.
    Afterwards save and publish your change. Now your OData Service is generated.

    Select Data Source

    Result:
    Now new service <ViewName>_CDS got created and the service is registered for further usage in the communication scenario.

  • Step 6

    Go back to Press the Custom Communication Scenarios tile to start the application.

    Select Data Source
  • Step 7

    In Custom Communication Scenario add a new Scenario by clicking on new button.

    Select Data Source
  • Step 8

    A new window will open where you can define the Name of the New Scenario and its Description.

    Select Data Source
  • Step 9

    First you have to click the add button. Afterwards search for New Customer and add YY_NEW_CUSTOMER_CDS as a service.

    Select Data Source
  • Step 10

    After adding the service YY_NEW_CUSTOMER_CDS, the result will be shown in the following way:

    Select Data Source

    Now you can publish your Communication Scenario.

  • Step 11

    If you already have a communication system and user then use them in the following steps.
    Otherwise you can create a new communication system and user by making use of the following example.
    Therefore go to Step 2: Creating a Communication System and User in the this blog.

  • Step 12

    Navigate to the Communication Management category and press the Communication Arrangements tile to start the application.

    Select Data Source
  • Step 13

    Click on the new button to create a new Communication Arrangement.

    Select Data Source
  • Step 14

    You can choose YY1_New_Customer as Scenario and select the create button by clicking the value help.

    Select Data Source
  • Step 15

    Now select your Service, like EXTERNAL_SYSTEM as Communication System and save the Communication Arrangement.

    Select Data Source
  • Step 16

    After you have saved your Communication Arrangement, the URL will be generated.

    Select Data Source

    Result:
    The role containing the authorizations for the service(s) is assigned to a communication user. After this step, you can call the service in a web browser and logon with the communication user. You can consume this service also in tools like Excel using the comm. user logon.

    Note: the communication arrangement is a configuration object that is created in test and production system separately.

Back to top