- SAP Managed Tags:
Overview :
In this blog, we will explore the Extensibility Process and focus on developing custom CDS views using S/4HANA Embedded Analytics. The Extensibility process flow is the key approach used by analytical specialists to develop new Analytical reports and KPIs in the S/4HANA system. SAP presents many standard VDMs to meet the requirements of varying customers and industries. However, there are some specific use cases that demand customized CDS views for their business requirements.
Extensibility Process Flow Diagram:
As depicted in the above diagram, once we identify the standard VDM views from the view browser app, we can create a new custom VDM views to meet the specific requirement of the business. The new custom CDS view, will be used as a source for creating analytical queries. The analytical specialist can create Reports, KPIs and multidimensional reports using these analytical queries.
Step 1:
In S/4HANA Homepage, navigate to “Custom CDS Views App” and proceed to create a new custom CDS view.
Precondition to create Custom CDS view:
- Using SAP Released standard CDS views.
- Using Previously published custom CDS Views
In this CDS view, we have used two standard CDS views and join them using the common key fields. Primary CDS view: overdue payments CDS view and join it with the Secondary CDS view: customer dimension view. We will also create a calculated field to derive ‘high risk’ and ‘low risk’ based on the outstanding amount.
Step 2:
Select the scenario type as Analytical cube and provide the basic details of the Custom CDS view. Custom CDS view name will be prefixed with ‘YY1’*. There is other scenario type also we can select, as shown below.
The Next screen will be presented with 5 sections. We need to maintain all these sections, namely “Data sources”, “Parameters”, “Elements”, “Element Properties”, “Filters”.
As shown above , In the “Data sources” a section, we will click the “Add” button on the top right corner of the table. Select the primary data sources from the list of released views. Also select the Associate data sources and provide the join condition.
Step 3:
The Next section is “Parameters” section, In Most cases CDS views will produce empty records, if not maintained the parameter values correctly. For example, in the standard cds view (shown below), there are list of parameters maintained, that we need to assign values to fetch the desired results.
In this example we have provided the values for display currency and ExchangeRateType to provide the valid output.
Step 4:
In the “Elements” section, we will select the required attributes of the primary data source fields and associate data source fields. As pointed out below, there are elements, calculations, and parameter options.
Once you have selected the required fields from the “Elements” option, additional calculated fields can be created using the “Calculation” option.
Step 5:
As mentioned in the above step, select the calculation option, and provide a meaning full name for the calculated field. In this case we are trying to find out Credit Risk by considering the outstanding due amount. Hence “Z_CD_CreditRisk” variable uses the “CASE” function. We applied the logic - if overdue amount more than 10000 it will be termed as “High credit risk”.
Please note the Functions options provides lot of flexibility in applying logics. We can use these calculated fields in our custom cds view reports. The output of this calculated fields is clearly shown in this blog's output section.
Step 6:
In the filter section, we can restrict the output by any selected field available from the report. In this example we have we have restricted overdue amount greater than 3000 euros to be shown in the report.
Step 7:
After Providing required information in these 5 sections, procced to “Check” the report for any issues or syntax errors. This option is available in the bottom of the table section. After the confirmation message, we can procced to publish the report. This will notify us “Publishing successful” as shown below.
The Output of the newly created custom cds view will look like the one below. You can notice the calculated field “Z_CD_CreditRisk” is featuring in the report. Based on the overdue amount it updates the risk level in the report.
Conclusion:
This blog provides us with clarity on how to build and use “custom cds views” in a step-by-step manner. This demonstrates the S/4HANA Embedded Analytics capability in a simple-to-use and easy-to-implement way for our SAP customers. Hope our customers will greatly benefit from this embedded analytics capability of SAP S/4HANA for their dynamic business requirements.
Thank You for your time!!!
1 Comment
