Friday 30 June 2023

SAP Datasphere: HANA System Memory and CPU – Overall Consumption and Breakdown


This blog post series describes a concept on how to monitor your HANA system and consumption of SAP Datasphere. Starting from an analysis of the HANA system resource situation it will enable you to break down the resource consumption into types like reporting via Ina/MDS, Task Handling, Open SQL and more.

The target audience is the central SAP Datasphere Administrator (global perspective) or a key user of an implementation project, who likes to monitor his resource consumption (project perspective).

Monday 26 June 2023

MDG DQM: Enriching product master data with derivation rules in S/4 HANA

Today in this blog we move our focus to performing derivations using MDG DQM.


MDG DQM from S/4 HANA 2021 can be used to derive attributes of product data and business partner data in both mass processing and consolidation. From S/4 HANA 2022 MDG DQM also provides the capability of derive product and business partner attributes in central governance as well.

With the strong push of moving processes to cloud with SAP BTP, MDG also is moving towards cloud with SAP MDG cloud edition. Come S/4 HANA 2023 for MDG will also see significant transition to cloud as a result use of DQM for rules and derivations becomes cruical, as we need to re discover the traditional way of doing development in MDG.

Saturday 24 June 2023

SHAP Interaction values with Automated Predictive (APL)

We already covered SHAP-explained models for classification and regression scenarios in a previous APL blog post, and at the time we talked briefly about the main effect of a predictor and its interaction effect with the other predictors of the model. Now with HANA ML 2.17, you have the ability to visualize the interaction between variables in a heatmap. This new visualization adds to the bar chart Variable Importance in providing a global explanation of the classification/regression model. To get that new feature you need APL 2311 or a later version.

This blog will walk you through an example using the Census dataset that comes with APL.

Friday 23 June 2023

Quality inspection process for customer return stock

As we all know quality management plays an important role in SAP PP, MM and SD modules. So, In this blog I have tried to share information related to quality inspection process for customer return stock which rejected by customer or denied by customer. Generally, this process more use in retails industries.

For this scenario we use inspection type 05 (other goods receipt).

Prerequisites: –

1. Inspection type 05 (Other Goods receipt) should be assigned to the material in quality management view of material master.

2. Maintain combination of Movement type 655 (Goods receipt to quality inspection) in DN (Return) scheduling line. As shown in picture 1.1.

Wednesday 21 June 2023

SAP S/4HANA Cloud, public edition, ABAP environment case introduction

Since the introduction of a 3-system landscape (3SL) in September 2022 for the SAP S/4HANA Cloud, public edition, SAP added a new pillar to the Extensibility landscape: Developer Extensibility, also known as SAP S/4HANA Cloud, ABAP environment. But what can Developer Extensibility do? Can we do classical ABAP programming in SAP S/4HANA Cloud? Can we debug the code? Will Key User Extensibility (in-app extensibility) be of no use anymore? … Lots of questions come to our mind. Today, I would like to present some differentiation scenarios we implemented using Developer Extensibility for SAP S/4HANA Cloud, public edition, hoping it can give you some concrete ideas on the capabilities of Developer Extensibility and the typical business scenarios we can solve using Developer Extensibility.

Monday 19 June 2023

SAP BW Bridge: Just a SAP BW/4HANA in SAP Datasphere?

In 2021, SAP has published the SAP BW Birdge. Is it a SAP BW/4 HANA in the Business Technology Platform? Does this give the SAP BW a cloud SaaS perspective?

What is the BW Bridge?

There are already many blogposts and information material on the subject, so I’ll treat the topic only briefly here.

Friday 16 June 2023

Unlocking Advanced Analytics: Bringing SAP Datasphere Views to Databricks with SAP HANA Cloud JDBC


SAP Datasphere is a powerful platform that allows organizations to create and manage data models, views, and integrations. On the other hand, Databricks is a widely used data analytics and machine learning platform. In this blog post, we will explore how to bring SAP Datasphere views to Databricks using SAP HANA Cloud JDBC.

Prerequisites: Before we begin, make sure you have the following prerequisites in place:

Wednesday 14 June 2023

How to authorize Direct Debit Payments outside SEPA in Contract Accounting

Did you ever face the issue when SEPA mandates can’t be used for the authorization of direct debit transactions in non-euro currency? Do you wonder how to collect money with direct debit transactions outside SEPA? If so, this blog post is dedicated to you to answer such questions.

Introduction to Direct Debit Mandate (DDM)

Figure 1: Direct Debit Mandate process

Monday 12 June 2023

Service Now connectivity using SOAP query through HANA SDA


In this article, the method of connecting Service Now with HANA SDA connection is explained along with the set up for the delta connection is described. The scenario described here will explain the connectivity with Service Now and the data extraction techniques.

Connectivity with Service Now

Connectivity with Service Now from HANA is possible through SOAP adapter. Once the adapter is set up, a connection needs to be created in HANA IDE. This is possible through the SDA option. Please note that the data is always accessed virtually and there is no need of replicating the data for the connection.

Friday 9 June 2023

MRP Live by S/4 HANA

SAP S/4 HANA business suite is based on HANA in-memory platform. It brings several improvements over the conventional ECC business suite. SAP S/4 HANA is power packed with a new Fiori based user interface, updated data model, embedded analytics and capability of machine learning. SAP S/4 HANA brought a simplified approach to various business processes. The details of the simplifications are addressed in the Simplifications list. Simplification lists are release specific and published along with the release of S/4 HANA versions.

Wednesday 7 June 2023

Hana Cloud Modeling Series: Adding HANA Cloud entitlement

Introduction : SAP BTP provides many services, SAP HANA Cloud Database is one of them.

As each service provides one or more service plans, which could be thought of as a variant, similarly SAP HANA Cloud is offered in different configurations and sizes.

The plan one chooses is known as entitlement and quotas represent how much of a service plan one is entitled to use. Entitlements and Quotas are purchased at the global account level and then distributed to the subaccounts where we use them.

Monday 5 June 2023

Rolling Average or Moving Average in SAP HANA

In this blog post, we will learn about the rolling average, it’s also called a moving average, a running average, a moving mean, or a rolling mean. You’ll very often see rolling averages used in time series data to analyze trends, they are calculated as the mean of the current and a specified number of immediately preceding or following values for each point in time.

This blog post is designed using SAP HANA XS Advanced (SAP Web IDE). (SAP HANA on premise and SAP HANA, express edition).

Use case: – A rolling average helps us to find trends of a certain measure for a particular time window.