Skip to Content
Technical Articles
Author's profile photo Steffen Ulmer

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

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:

 

Generate%20Model

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.