Friday 28 August 2020

Wednesday 26 August 2020

SAP S/4HANA Reconciliation with SAP Data Services (E2E)

In this blog post I’d like to share the insights of a customer project where we added data reconciliation after the SAP S/4HANA Migration activities.

The blog post explains the following:

◉ SAP S/4HANA Migration related data objects and how to do manual recon
◉ Architecture for End-2-End (E2E) automated reconciliation using
    ◉ SAP Data Services
    ◉ SAP ECC 6.0 Source system
    ◉ SAP S/4HANA Target system
    ◉ ABAP Web Dynpro screens
◉ SAP Data Services processes required for automatic reconcilation
◉ ABAP Web Dynpro screens for results display

Monday 24 August 2020

S/4 HANA On-Premise In-App Key User Extensibility – Custom Business Objects

As there are many S/4 HANA implementations are now coming into picture the usage of the Custom Business objects CBO’s is suggested by SAP to replace standard custom SE11 tables.

The below blog will focus on the S/4 HANA On-Premise system


◉ As the name suggests Key User Extensions it is designed by SAP so that end users can create the CBO’s with out help of the developers and with a checkbox generate also the UI for the maintainance of the Fiori application

Saturday 22 August 2020

Implementing View-based SSCUI in SAP S/4HANA Cloud

In this blog post, I will share my understanding and knowledge about SSCUI development steps.

What is SSCUI?

SSCUI stands for Self-Service Configuration User Interface.

Friday 21 August 2020

SAP HANA SPS upgrade step-by-step guide


Basis Administration in the Age of SAP HANA requires new skills from SAP Basis Administrators. One of them HANA DB Maintenance & Upgrade. For example, SPS updates should be installed at regular intervals to avoid errors and to keep your Database up to date

Wednesday 19 August 2020

SAP’s Data Tiering Options and Detailed Planning

Executive Summary:

Every Organization has the biggest challenge to reduce the TCO (Total cost of ownership). One of the major contributor in that is the cost of Hardware on which ERP applications are running.

With evolution of new technology and presence of Cloud services, the availability of these Hardware has been made very easy, but still when we talk about the compute capability then each organization has to plan for the quantum of data it needs to store which will be inline with there Business needs and comes handy for future planning during data analysis.

Monday 17 August 2020

Custom Flexible Workflow steps


In this blog post, you will see how to create and configure a complex Custom Flexible Workflow for Purchase Order approval.

Below is the example scenario:

Friday 14 August 2020

Introducing the Automated Predictive Library (APL) for SAC AND HANA

Where does APL come from?

When SAP acquired KXEN in 2013, the company offered a software solution to help companies to create and manage predictive models in a semi-automated mode. This engine has evolved to meet SAP’s quality criteria and has been adapted to run in HANA. It then took the name Automated Predictive Library (APL). It is constantly evolving and improving, for example by integrating new Machine Learning algorithms, while respecting what makes it unique, i.e. being an automated Machine Learning engine.

Wednesday 12 August 2020

Access SAP HANA records from VS (Visual Studio) Code

So let us begin……

Step 1: Install VS Code extension SAP HANA Driver for SQLTools by navigating to the extensions window and search for publisher:”SAP”. We can see our required extension. Click on the install. Internally it has a dependency extension (SQLTools) which will be installed automatically.

Tuesday 11 August 2020

A new approach for replicating tables across different SAP HANA systems

Starting with SAP HANA Cloud, SAP HANA supports a new remote table replication feature for replicating tables across different SAP HANA systems natively. With this new feature, users can handily replicate remote tables as it directly sends DDL and DML logs from a source system to a target system through SAP HANA smart data access (SDA) ODBC connection.

Saturday 8 August 2020

Install Hana Express Edition on MS Azure


This blog post is created to use SAP HANA express edition using Azure. Primary purpose of this blog post is to get familiarized with SAP HANA. This post is targeted for system administrators.

Credit – Images/URLs used in this document are from Microsoft Azure portal available in public domain.

Friday 7 August 2020

HANA Machine Learning (ML) -Analysis Association Frequent Pattern(FP) Growth Algorithm using Python

Association analysis is process of finding interested relationship in large datasets. This is  been used in grocery stores like coupons we found , packaged deals, the way items are displayed on shelfs or together. Some common examples of Data Associations are:-

“People who buy bread tend to buy butter or jam as well. Because normally breakfast goes with bread and butter.”

“People who buys diapers tends to buy beer as well. Because raising kids is a stressful job”

Wednesday 5 August 2020

Live Data Connection to SAP HANA Using a Tunnel Connection with SAP Analytics Cloud


The requirement is to be able to combine the direct and live user access to internal SAP HANA systems [within corporate firewalls] and when users are not connected to the corporate network [from outside of corporate firewalls].

◉ SAP Analytics Cloud [SAC] is a SaaS tenant running on public internet.
◉ Live connectivity is required as data must not be duplicated or moved.
◉ Direct access. The internal [on premise] SAP HANA [HANA] backend systems InA endpoints cannot be accessed outside of the corporate firewall.

Sunday 2 August 2020

SAP HANA Data Anonymization: Machine Learning on privacy preserving data


For a Data Scientist in the corporate area like me, data privacy is a tremendous challenge: Data is the source of all the powerful things we can do with Analytics or Machine Learning, but since it is often personal and sensitive we cannot simply use it as of course our responsibility is to preserve the privacy of individuals. This is covered by legislation, such as GDPR in Europe, which also requires us to get a proper consent from the customer to use his/her data in these kinds of applications. In many cases, we do have some consent documented, but it doesn’t cover our specific use case as it wasn’t know at the time the consent was requested.

Saturday 1 August 2020

Understanding SAP Versions

SAP continues to update their offerings to further improve the user experience. While this is great to ensure our ERP systems have the greatest capabilities possible, it can be hard to keep track that our own systems are up to date. That’s why we put together a list of the SAP versions and how your business can learn more about which version you are operating.