Monday 27 July 2020

Other DB to HANA Migration cycle, roles/responsibilities of basis,functional & technical resources

New thing? No! This(migration) is the ongoing journey to be embark upon, which all businesses today or tomorrow have to ride on.

As usual, whenever I complete any assignment/project, I blog it and share the insights, in and out of that on this platform in easiest way possible.

Sunday 26 July 2020

How to find-out an IDOC number when we know a specific value(Purchase order) to search.

Issue statement: When we have a very high volume of IDOCs in the system, it is difficult to find a specific IDOC number for the key value. i.e purchase order, clearing document, sales order, or any key data for which IDOC is created. This can be an inbound or outbound IDOC number.

Please follow the below steps to identify an IDOC number without spending a lot of time in analysis. I am taking an example of IDOC for the purchase order creation scenario and in the SAP S4 HANA system.

Step 1: Find a key value for which you want to find an IDOC number. In my example, I am searching for an IDOC number for the purchase order created as I know my specific purchase order number, which means when a purchase order is created an IDOC will be generated. DOC requirement depends on the business case and I am not going into the business case for this POC.

Friday 24 July 2020

SAP S/4HANA Model Company SAP BW client switch

As we are aware that SAP S/4HANA comes with an embedded BW  (SAP Business Warehouse) functionality.

The embedded BW client can be an integrated client along with your main ERP productive client or it can be a separate client depending on the use case.

Many customers are reaping the benefits of embedded  BW in SAP S/4HANA for embedded analytics,for reporting and planning.

Thursday 23 July 2020

Handling Null and Empty Values in Join Function using Auto filling Option

SAP Profitability and Performance Management (PaPM) Join Function is referred to as a processing function that is used to combine two or more inputs, either data source function such as model table or other processing functions such as allocation and calculation, to form an enriched result based on the settings configured on the function.

During data preparation or checking of results, there are two common data values which I encounter namely, Null and Initial. In SAP PaPM, both Null and Initial are represented by an empty cell for characteristic and “0” for the key figure, respectively.

Wednesday 22 July 2020

Creating an SAC Geo Map from WebIDE (HDI) based Calculation Views

In this blog post I will share how to create an SAP Analytics Cloud (SAC), Geo Map based on Calculation Views created within the WebIDE. These are Calc Views that reside within an HDI Container as Column Views.


1. HANA Cloud / HANA On-Prem with XSA

2. Live Connection from SAC to HANA

3. Dataset with Latitude and Longitude

4. WebIDE Calculation Views

Tuesday 21 July 2020

Get On-boarded with HANA XSA and Python Application using hdbcli

In this post, I will be discussing on how to connect Python application to HANA XSA using hdbcli. I will also include what are the prerequisites to get the environment set up and will demo the end to end execution steps using the screen shots.

Some previous knowledge on Python will be great but not required as I will explain everything in detail as we move further.

Monday 20 July 2020

CAP: Demystify User Authentication

Before the release of the CAP Model, I have been working on the XSJS framework both in XSA and Cloud Foundry environments. And because of that, I’ve gotten familiar with how the framework handles user authentication. Now, with the CAP Model taking over, I have to start over again and figure out how does the CDS framework handles the user authentication.

In this blog post, I will share my journey in understanding how CAP handles user authentication and what it does behind the scenes. I will show how to set up user authentication for a CAP-based service. Subsequently, I will deep dive into the inner workings of the CDS framework and unearth how user information is handled.

Sunday 19 July 2020

SAP Transportation Management documents in Sales Order document flow


Each release of SAP S/4HANA comes with lots of big and long-awaited features which are heavily advertised. And sometimes there are small things which are useful but tend to be a little less in the spotlight. Today I would like to draw your attention to one such feature, the integration of SAP Transportation Management (SAP TM) Freight Units and Freight Orders in the Sales Order document flow.

Saturday 18 July 2020

Federated SAML SSO with Azure AD and SAP HANA [docker image]


Azure AD (Active Directory) has become an increasingly popular choice as a SAML SSO identity provider with SAP applications.

Azure AD makes it a relatively simple task to set up SAML SSO with the likes of [SAP HANA], [SAP Analytics Cloud] etc. by providing easy to follow step by step guides.

Friday 17 July 2020

SAP HANA DB Migration/Restore from Multi-Node to Single-Node


As HANA DB is growing, there are many DB Migrations/Conversions coming up in the SAP world. I always had a question how to perform DB Refresh/Restore Multi Node(PRD) to single Node(QAS).  This post mainly outlines/answers the below questions

Wednesday 15 July 2020

HANA DB with extension node upgrade steps

This Blog covers the steps of upgrading HANA database having extension node.

Here, We have BW/4HANA installed with extension node. In this blog I will be showing DB Rev upgrade from HANA 2.0 SP3 Rev33 to HANA 2.0 SP3 Rev37

Prerequisite: <sid>adm user on both DB nodes should have the same password

Here i will be using below naming convention

Tuesday 14 July 2020

Tips: VS Code Extensions

In this blog post, I am sharing the top 10 extensions that I personally use on my Node.js development, as well as when developing in Cloud Application Programming (CAP) Model. I hope you would find it useful too in your backend development work.

Monday 13 July 2020

COVID-19 Tweets analysis using HANA ML Python APIs.

Since long i am seeing various post on COVID-19 data analysis and forecasting and having the same thought i decided to post my recent work mainly on text mining & text analysis on COVID-19 tweets & data.

IDEA is to connect twitter from python and insert data into SAP HANA and utilize the built-in powerful capabilities in SAP HANA for text mining & text analysis & displaying word cloud and using few text mining functions as well.

Friday 10 July 2020

Install the Four Pillars of a Quality Organization to Create Better Products

Docker Containers subject has been rolling around for quite some time now. Even it has gained much more interest with SAP R&D team for reducing the hardware cost, resource consumption, easy maintenance, etc…  There has been many blogs and research already rolling out on this subject integrating SAP with Docker containers.

Wednesday 8 July 2020

Step-by-step Financial Statement Version Reporting with Currency Type Characteristic on S/4 Hana + Embedded BW


During analysis of a business process for reporting, some of the required developments for the need and how to develop them are crystal clear. We tend to think of the required development elements on-the-fly/instinctively while analyzing the process. Almost in a visual way, but sometimes, even after working in BI environment for 10 years, I find myself asking simple how-to-do questions and searching for a relevant blog article to answer the question.

Monday 6 July 2020

Setting up END2END SAML integration between SAP Analytics Cloud and SAP HANA on Premise using ADFS Identity Provider

This blog describes How to implement END2END SAML using same Identity Provider (IdP) for SAP Analytics Cloud and SAP HANA

SAP Analytics Cloud, SAP HANA, SAP HANA Live, SAP HANA Exam Prep

With this approach / configuration, users will have the advantage to use same IdP credentials only once while logging into SAP Analytics Cloud and don’t have to enter the credentials again while creating Live Connection to SAP HANA

Saturday 4 July 2020

Material Master Views in SAP S/4 HANA

In the current SAP blog post, we will cover all the MM views with the implication of vital processes in the standard SAP system. You will see how each of the views is created, its obligatory data, optional fields, and how its creation reflects the system

S/4 HANA Material Master – Views:

As I have shown in below screenshot, we have mainly 7 following views

Friday 3 July 2020

SAP HANA Views – Back End Tables & Where Used List Details

The purpose of this blog post is to provide back end /physical tables source information  of created SAP HANA Analytic & Calculation views during data modelling. This can be helpful for the developers to get an overall picture of created views with the where used list details and  the back end logic’s behind  at the time of creating views.

There are certain standard system views, which was provided by SAP by using these views we can get this information.

Wednesday 1 July 2020

Deploying .NET code on HANA XS Advanced

SAP has implemented Cloud Foundry (CF) on its SAP Cloud Platform, as a next-generation Platform as a Service (PaaS) as a development and runtime environment. CF offers a set of tools and services to run applications developed with different programming models.

SAP HANA® in-memory database also provides an application platform called SAP HANA® extended application services (XS Advanced or XSA). XSA is available on-premise and follows development paradigm compatible with CF.

We will cover specific aspects on how to prepare your XSA execution environment for Go-Live phase and make sure your applications run safely with given constraints on memory resources.