Saturday 30 October 2021

How to assign one Selection screen input field value into another field [ Not input ready] in SAP analytics report [ BW Query] using SAP HANA Exit


During the development of any SAP analytical report, we may required to access one 

selection screen variable value to be assigned to another selection screen variable.

So that the second variable will bring all the relevant information from the database.

Out of many, there is one scenario where users enter the value one selection screen field in the SAP analytics report. After input same value gets assigned into another selection screen field [ Not input ready]. See the below flow shows how the “ZVAR_WBS_HIER” value gets assigned into the “ZHE_WBS” variable.

Friday 29 October 2021

HANA Reptasks: A Technical Perspective

This blog will cover the technical setup required to create HANA reptasks in Business Application Studio. In this scenario, we will be connecting to an on-prem S/4HANA instance and replicating the data into a HANA Cloud Service instance in Cloud Foundry.


◉ DPAgent installed, connected, and configured.

    ◉ There are several guides and blogs already available for this, and the setup is straightforward. Download the latest version from the SWDC by searching “HANA DP AGENT” in the downloads bar.

◉ HANA Cloud Service instance created.

Monday 25 October 2021

Handling exception in HANA procedures

Before we start this discussion I would like to highlight the basic of exception what is an exception in terms of database procedure and how we handle this exceptions.

In the time of procedure execution if any issue occurs in specified operations like insert, update etc. with the input data then the exception occurred and we need to use some exception handler to handle this exception. This is call implicit exception.

In HANA we will use declare EXIT HANDLER to handle those exception.

There is another way you can create an exception using fulfill of certain declared condition CONDITION Using SIGNAL and RESIGNAL. This exception explicitly created.

Friday 22 October 2021

SAP ECC to SAP S/4HANA Conversion – A high-level guide for the beginners

“Every success story is a tale of constant adaption, revision and change.” – Richard Branson

In line with the very same philosophy, SAP rebuilt SAP ECC from the ground up to create SAP S/4HANA in 2015 to take advantage of SAP HANA’s performance and data analytics capabilities.

To start with a simple SAP ECC to SAP S/4HANA conversion, the foremost thing to understand is the basic difference between the two.

Wednesday 20 October 2021

Detailed Debugging Techniques for Functional consultants

'Debugging’ is a term, which is directly associated with programming. It is a general term used by all Software Professionals, irrespective of the language and platform. ‘Debugging’, as the name suggests, is used to debug the program. IN other words it is slow motion, step by step execution of the program, so that one can closely find, how the program/ software is working.

‘Debugging is typically used to fix the Bugs in the program but in SAP debugging is invariably used for understanding the flow of program itself.

‘Debugging’ has been a vital discussion and development point across the software industry for Years. Still, there are some languages, where fixing a bug is a nightmare.

In SAP, debugging had been a quite easy task. In SAP there are various ways to debug the program, additionally one can know the values of the variable withing the execution, which is a big help to the programming professionals.

Monday 18 October 2021

Optimizing BDLS For HANA Large Scale Instances (HLIs)


The purpose of this blog post is to give the audience an overview of how I handled BDLS process in the refreshes of HANA Large Scale Instances. I will try to give as much information as possible (which is already publicly available and maybe not all be in a single place) and try to depict how I used it to build a solution.

The Motivation: 

All SAP Basis consultants had to deal with BDLS process in their careers at some point or the other, but it becomes a challenge and a pain when the size of the DB is in several TBs. The process then needs many hours or even days to run.

Friday 15 October 2021

SAP S/4HANA Cloud and SAP S/4HANA 2021 Product Release

In this blog post, I have the pleasure to share with you the key aspects that bring intelligence to our Digital Core along with some of the highlights of the release.

Foundation of the Digital Core

Before we start with my top highlights from our SAP S/4HANA Cloud and SAP S/4HANA 2021 release, let’s find out what the foundation of the Digital Core is. We consider the following four aspects:

1. An architecture that delivers a scalable foundation to transact at the highest possible automation,

2. A system of intelligence that supports and steers the business using embedded analytics, simulation, prediction, and decision support to run LIVE business,

Wednesday 13 October 2021

How to use HANA Exit in SAP Analytics Report [Selection Screen Default value]

Purpose / Issue –

SAP Analytics reports default value for Fiscal Year and Posting Period as Current Fiscal Year and Posting Period on the selection screen.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Report Selection Screen Value

Monday 11 October 2021

Detecting Contextual Anomalies with SAP HANA ML


What is an Anomaly?

The goal here is to detect outlier data points, which do not follow the collective common pattern of the majority of data points, hence can be easily separated from the group.

SAP HANA ML, SAP HANA Tutorial and Materials, SAP HANA Certification, SAP HANA Guides, SAP HANA Preparation, SAP HANA Career

Some of the possible use cases here are: 

Tuesday 5 October 2021

Tools of HANA SQL Data Warehouse


Now with some weeks delay I want to continue and give an overview which tools are necessary or helpful to build a SAP HANA Data Warehouse with in this way.

SAP HANA SQL Data Warehousing offers a high degree of flexibility with regard to the use of different tools. The SQL approach makes it possible to use many well-known (open source) software development tools, especially in the context of the applied DevOps philosophy. But also the SAP HANA platform brings some important own tools for the development of the native SAP HANA SQL Data Warehouse.

Friday 1 October 2021

One Stop View for Production Supervisor – Manage Process Order

In this blog, I shall introduce you to this new application ‘Manage Process Orders’, a SAP S/4HANA Fiori App which is designed, keeping the supervisor persona in mind. By the end of this blog, you will have a good understanding of the features, this application offers to equip the production supervisor to carry out the responsibility of detailed planning of the production process.

Typically a supervisor is responsible for managing process orders, editing and releasing of orders, monitoring the order execution, assessing the production issues, making sure all required materials and equipment are available for the production team and so on. Overall, he must ensure the production line is always running and active. Executing all these actions at one time, that too effortlessly and switching between various apps and performing manual transactions could be a tedious job for the supervisor.

What if there is a single application that supports maintenance of complete life cycle of a process order end-to-end?