SAP- How to Create Custom CDS View

Introduction- SAP Create Custom CDS View

SAP Create Custom CDS View can be used to generate the user’s own data access, in case they require access to data in the ERP system which is either not available in the standard apps or a report is needed to give more visibility to stakeholders or to create custom application that reads data from SAP.

Generally, the data of an application is spread across numerous database tables. SAP create custom CDS view that permits you to model the data access without altering underlying database tables. You can reorganize the table fields and define the metadata of the fields that fit into one object but then are set in different databases. Follow these steps when you are ready to create an app through the SAP create Custom CDS view.

Below is the summary of the steps we would be following 

  1. Creating CDS View
  2. Specify Join condition
Check the logs and publish the CDS view which would be ready to use. 

Create Custom CDS view

Custom CDS view to create an app. Go to Custom CDS view and click on create to add new

Table Description automatically generated with low confidence

Specify the CDS view name, Label and scenario get automatically selected

However, I prefer to create an analytical dimension

Note the scenario once selected cannot be changed later.

Table Description automatically generated

Graphical user interface, text, application, email Description automatically generated

After the CDS view is created click to add data sources 

  1. Click on Add button
  2. Type the data source in the search
  3. Select the data source

Note that it would show you the data source based on the Analytics data category so if your CDS view was a standard CDS view the Analytics data category if dimension would not show up

Graphical user interface, application Description automatically generated

This adds the primary data source. Now we add the associated data source to this

Graphical user interface, application, Teams Description automatically generated

And now add the join condition between primary and associated data sources

Specify Join condition 

  1. Select cardinality
  2. Select how both primary and associated data sources are connected as seen below

Graphical user interface, application Description automatically generated

And select the fields needed from both views by selecting the specific field.

Table Description automatically generated

So the fields show on the Elements screen now which was selected

Also remember to select the entire I_product and add as its own reference as highlighted below

Graphical user interface, text, application, email Description automatically generated

In the element Tab, you could specify the master data view. It is not mandatory but sometimes it does give errors. If it does not show the right view in the dropdown then use the previous step to add to the elements section where you could see _i_Product and then it would show up in the dropdown as below

Graphical user interface, application Description automatically generated

Check the log there should not be any error and publishing should be successful. Click on preview

Graphical user interface, application, Teams Description automatically generated

Check Preview and it opens up the next view where you would see the result of the CDS view created.

Graphical user interface, application, table Description automatically generated

Conclusion – How to Create Custom CDS View

In this article, we talked about the steps used to create an app with the help of the Custom CDS View. Which in general, are intended to be consumed by a UI, analytics, or other systems.

Follow these steps and it should be easy to create a Custom CDS view in the system. 

If you would like to know how to use this CDS view created to create a custom analytical query please refer the blog on How to create Custom Analytical Query

Get In Touch If You Have A Business Query

Related Posts

SAP Display Material Serial Number app shows Dump

The article explains a few helpful tips to overcome the apprehension of how to clear dump while using SAP Display Material Serial Number.

Read More →
SAP How to create custom CDS view

This Article talks about SAP S/4 Hana- How to create custom CDS view for an application easy for the end-user.

Read More →
SAP Fiori how to Display More rows and columns

Learn how to Increase the S/4 Hana rows and columns limit to display in the SAP Fiori element templates to support the features and settings.

Read More →