Friday 30 August 2019

Implement Security in WhatsApp Integration with SAP S/4HANA

Security is important aspect in any Enterprise conversational system when it is Hosted in Public social media like WhatsApp, Facebook etc, Because now a days everyone got smart phone. Welcome to my another blog where i am going discuss about security aspect of WhatsApp integration with SAP S/4HANA, as most of the people are interested to see how security can be taken care in this particular integration so thought to write another blog in it.

Thursday 29 August 2019

New Output Management for S/4 Hana system. Purchase_Order, Sales_Order.(Print & IDOC)

Agenda: This document gives brief insight into new output management for S/4 Hana (Using BRF+) and how to use the new OM for printing and for the purpose of IDOC generations.

Before opting for New OM, please go through the Notes mentioned below, which could help in understanding the possible implementation and also supported sources in new OM.

Wednesday 28 August 2019

SAP C/4HANA Extensibility – Triggering Lambdas with Events

This blog will detail how a Lambda function can be triggered to run when an event is published into the Kyma environment. To eliminate any barriers, we will utilize the SAP Commerce mock application to send events, but the process flow would be the same if using SAP Commerce. The setup of SAP Commerce can be found in this blog.

Tuesday 27 August 2019

What is the difference CalcView versus SQL View?

Recently I was asked what the difference between a Hana Calculation View and a SQL View is. To provide reading material, I did a quick search via google and was shocked by the answers I found. Some wrong, some missing the point, many outdated.

Thursday 22 August 2019

Diving into the HANA DataFrame: Python Integration – Part 1

>>> from math import pi
>>> π = pi
>>> area = π * r**2

>>> résumé = "knows Python"
>>> "Python" in résumé

Wednesday 21 August 2019

Sneak peek into S/4HANA 1909 Finance Innovations Part – 1

SAP has yet to release S/4HANA 1909, but I have some interesting sneak previews on what you can expect in the area of Finance. Of course, this would not cover everything, but I will focus mainly on the Finance capabilities in the S/4HANA Core. Interesting things are happening in the area of Profitability Analysis for example. Is COPA going to be replaced? Or is SAP just changing product names.

Tuesday 20 August 2019

SAP Cloud Platform Extension Factory – Connecting to SAP Commerce Cloud

One of the key components of the SAP Cloud Platform Extension Factory Kyma runtime is the Application Connector.  The Application Connector provides a mechanism to simplify the connection between external systems and Kyma in a secure manner.  Once the initial connection has been established, the registration of the external Events and APIs of the external system takes place. The Events and APIs are then available within the Kyma Service Catalog.  The events can be consumed asynchronously with services and lambdas (serverless functions) deployed within Kyma.  Additionally, the Application Connector provides monitoring and tracing capabilities to facilitate operational aspects.

Saturday 17 August 2019

SAP BW/4 2.0 – CAL for it …

We had a look to the CAL library for the latest releases of BW/4 and we found a brand new DEV Image of BW/4 2.0 including the BW/4 1.0 Content Add-On

SAP HANA Tutorials and Materials, SAP HANA Certifications, SAP HANA Learning, SAP HANA Online Exam

Friday 16 August 2019

SAP HANA XSA Email Example

For a few of the items he wanted, like bg-deploy, I was able to point to existing content that hopefully will help. But for some of the items there certainly were lacking examples.  One of them he mentioned was Email from XSA (pure node and xsjs).

This is a particular example or exercise that is often requested but I’m personally reluctant to do. It gets complicated fast because of the dependency upon an external SMTP server and the individual setup and authentication steps needed for the various different providers.

Wednesday 14 August 2019

Currency Conversion in HANA based on Fiscal Period


Whenever there is a requirement for Currency Conversion, the time reference plays a dominant role for determining exchange rates. Exchange rates vary on daily basis and which exchange rate should be applied for currency conversion is always a question.

Tuesday 13 August 2019

HOW-TO: Activate Master Data Hierarchies for SAP Analytics Cloud (SAC)


SAP Analytics Cloud enables to create dynamic visual stories based on key business areas with trusted data that is managed by IT.

There are many introductions and learning materials for creating powerful reports and dashboards for SAC. All the information shows how to visually deal with data derived from various sources. Since the BW live connection via BW queries does not have all the required features yet, we are using live connection via External SAP HANA Views. The External SAP HANA views are query-based. This is the only way it does work with the master data hierarchies right now.

Monday 12 August 2019

Develop Simple on HANA Express in AWS Cloud 9 Checkpoint – How to Catch Up/Restart

Develop Simple on HANA Express in AWS Cloud 9
Develop Simple on HANA Express in AWS Cloud 9 Part 2 – The Backend App
Develop Simple on HANA Express in AWS Cloud 9 Part 3 – The Frontend App


In the past 3 parts of this series, we’ve done a lot of Cloud 9 configuration and coding. As someone whose first job is not that of a technical writer, I know that some steps may not have been clear. I also know as someone who follows along to tutorials, sometimes I just need a ‘fast forward’ or ‘catch up’ button. This will be the point of this part of the series. Or if you happen to massively mess up your progress, this will walk you through quickly getting back up and running as-of Part 3 in the series.

Sunday 11 August 2019

How to influence degree of parallel execution when modeling HANA Calculation Views


SAP HANA uses an involved algorithm to decide about the parallelism with which queries are executed. However, in some situations you want to influence the degree of parallelization on top of the general HANA mechanism and control the parallelization of individual parts of your models based on business considerations.

Saturday 10 August 2019

Playing with HANA Parameters

The purpose of this blog was to share two end to end examples of passing parameters within HANA and using placeholders in SELECT statements.

I have created two scenarios:

1. HANA Table –> Table Function (with parameters) –> Calculation View (with parameters)
2. HANA Table –> Calculation View (with parameters) –> Procedure (with parameters)

Friday 9 August 2019

SAP HANA XSA Controller API Interaction

Since the introduction of SAP HANA extended application services, advanced model (XSA), SAP has supported many new approaches to accessing the platform APIs.  XSA is based upon Cloud Foundry which provides its core functionality via a command line client and a REST enabled web API.  XSA has this same functionality, but most of the focus on platform admin and interaction tends to focus on the CLI interface or the browser-based administrative UI which SAP deliveries. However behind that web UI are essentially calls to the controller APIs. These same APIs can be called from and used in your own applications.  In this blog I’d like to share some experiences trying to use these APIs.  There are some common challenges anyone using them will face and perhaps this blog can be helpful in that regard.

Thursday 8 August 2019

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 3

We will continue from where we left off in the previous part where we finished configuring the HANA Database and the user that will communicate with the database.

STEP 4: Deploy the Application

Let’s build the war file first. If you are using Eclipse, then perform a maven build and specify profile as cf. Otherwise, you can also build the application using maven command line tool with the following command –

Wednesday 7 August 2019

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 2

In this blog post, we continue with the Spring Boot application that we developed in PART 1. We will now look at the steps involved in binding a HANA instance with our application.

STEP 2 : Create HANA service instance.

We will create the HANA service instance in this step. HANA service provisions a HANA DB for us. This is a paid service so you’ll need to enable it using ISM tool.

For this exercise, we will use the 64standard service plan.

Friday 2 August 2019

Download and Installation of SAP HANA Studio 2.0 (SP3) with ABAP & BW Perspectives

Here are the comprehensive steps for download and installation of SAP HANA Studio with ABAP & BW perspectives which helps to initiate the development activity to Analytics Consultants.

What is SAP HANA Studio?

SAP HANA Studio is an Eclipse based, integrated development environment (IDE) for development and administration of SAP HANA Database in the form of GUI tool.