Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP MDG Change Request Analytics: Configure compliance relevant reports for bank detail changes

former_member183733
Active Participant
‎04-21-2023 8:45 AM

Introduction


With SAP MDG customers can manage master data records to achieve high data quality and ensure proper governance. SAP MDG captures corresponding changes to master data attributes in various tables for tracking and change log analysis. Some of the changes attributes can have a high impact and because of that compliance departments are often interested in changes of sensitive data. Changes on bank details for Business Partners/ Suppliers are one of such examples for sensitive attributes.

Since SAP MDG on SAP S/4HANA 2020 a very powerful capability is available and its called "Change Request Analytics Using Master Data Attributes".

My colleague Kefeng wrote this blog Understanding Your Data Changes in MDG Central Governance | SAP Blogs. I recommend to read this blog because it includes also more background information for the used capabilities.

In this blog I will explain the concrete and relevant steps to configure an ALV (Analytical List View) using SAP standard components to be able to report on sensitive Bank Detail information changes. No coding is required. The result will be a KPI application as shown in the following graphic.

 


 

Basic information


Change Requests Analytics Using Master Data Attributes enables master data specialists to get real time insights into change request processes by master data attributes and organizations.

Value Position

  • Enables master data specialists and analysts to monitor open and completed governance processes by master data attributes and organizations, and identify and fix process gaps, bottlenecks, and errors

  • Process transparency for different master data dimensions

  • Analyze and compare process efficiency, answering the questions, how fast are different processes executed, and is performance improving or decreasing among different master data dimensions?

  • Flexibility to allow key users to configure analytics requirement to analytics reports

  • Integrated authorization control on master data and segmentation

  • Enabled for SAP delivered models and custom data models


The setup/configuration consist of the following basic steps

  1. Ensure proper authorization/roles

  2. Generate Analytics CDS Views by executing a standard report

  3. Configure & Generate Analytics CDS View by executing a  second standard report

  4. Configuring a KPI/ALV report to display the information in a state of the art UI5  application including drill down.


Example requirements on reporting view


The following requirements are exemplary typical requirements:

  1. Show all BP which have been changed on “Bank Details” within a certain timeframe

  2. The report should show BP attributes like BP-ID and Name1 and also the Change Request ID and the name of the approver and date of approval

  3. The report should only include BPs of processes which have been approved (no open CRs and no rejected CRs)

  4. Ability to download to MS Excel


The step by step chapter below will explain all relevant steps to meet these requirements

Step by Step guide


1. Prerequisites/ Authorizations


In addition to the usual MDG authorizations your user needs the following roles:

  • SAP_UI_FLEX_KEY_USER

  • SAP_BR_ANALYTICS_SPECIALIST


on the Gateway System.

You need to have a MDG system running at least on a SAP S/4HANA 2021 to complete this guide. SAP MDG Process Analytics have been shipped with SAP S/4HANA 2020 already.



2. Generate Analytics CDS View


Start the transaction MDGIMG and start the following spro activity:


 

Generate the CDS View Model for the BP data model:

 



BTW: The generation will take up to 5 minutes

3. Configure & Generate Analytics CDS View


Start the spro activity to define the CDS view


 

Click on New Entries and add a line like this one:


Select the line and click on the left hand tree navigation to "Attributes for Change Analysis". Enter the fields on which you interested regarding the changes (in this example bank detail attributes)


In "Additional attributes.." you need to find more attributes which will be available for filtering


Finally you need to generate the CDS view.


 

Activate service

Activate the newly created CDS view for consumption: Start the transaction /n/IWFND/MAINT_SERVICE. Click on Add Service and search for technical name "ZBP*". Also choose the System Alias if you use a dedicated gateway system. Select the service and ue "Add Selected Services" to activate the service.

4. Configuring a UI / KPI


The generated CDS view can be visualized with various tools such as SAP SAC or even 3rd Party tools. In this blog i explain a very simple, easy to use and integrated option: The usage of the SAP S/4HANA integrated KPI modeler.

Start app "Manage KPI & Reports

 


or


Click on reports and select "New ALV"


Define a tile name like "MDG-S: Bank Detail Changes"

Define a data source and select "ZBP_BANK_CHANGES".


 

Click on "Configuration" to configure the details such as

  • filters (also visual filters): in an ALV always o the top of a page

  • charts: In an ALV always in the middle section for further drill downs

  • table: details on the buttom of the page



 



Create an tile/ application & assign catalog

Click on Applications and add a new application. Assign a catalog (eg X-SAP-UI2-CATALOGPAGE:SAP_MDG_BC_BUPA_DATA )

 


 


 

Test your application

Refresh your browser and search for your new tile/app:


 

Remarks



Best Regards

Steffen
Labels in this area
Popular Blog Posts