Friday 29 December 2023

Reuse attachment block in Contract account page

Today we will discuss on how we can reuse attachment block (BSP Component View GS_CM/DocList) in Contract Account page in S4CRM Web UI. Before proceeding would like to throw some light on S4CRM which is different from CRM in some ways.

1) Custom extensions to standard objects which is now possible from Fiori Extensibility features replacing Application Enhancement Tool (AET).

Wednesday 27 December 2023

How to create Business Users in SAP S/4HANA

Business User is a new identity model introduced in SAP S/4HANA. A Business User is a natural person who is represented by a Business Partner which is linked to the user in the system. This Business User model is used in many applications in S/4HANA and is required for running different business processes representing roles such as purchaser, sales representative, approver, etc.

In this blog I will explain how to create business users in SAP S/4HANA. There are two scenarios one with HCM integration active and the other with HCM integration not active.

Friday 22 December 2023

Git Sequencing Strategy and Best Practices: SAP HANA XS Advanced and/or SAP HANA Cloud

As we see more and more customers adopting the cloud based development methodologies in SAP especially with customers adopting XS Advanced and SAP HANA Cloud as their data warehousing or data mart solution, there was need to lay down some best practices for source code management and version control. This blog post talks about some of the best practices to be followed while working in a parallel development environment especially while working with multiple features development.

This blog provides best practices for sequencing using git based tools and addresses the following pain points:

◉ How to build/deploy different features in different systems in the landscape and not have a deployment conflict ?
◉ What to do in case a feature is not ready, and there’s a Priority 1 bug is to be fixed ?
◉ How to select or drop a feature/commit in case of an erroneous situation ?

Wednesday 20 December 2023

A Straight-Forward Approach – “Express Document – Update was canceled issue.”

In this blog we will discuss about one issue that I faced recently during the creation of a PO with a customized document type.

I was creating a PO for a “Sub-Contracting” item with the Item Category “L”, but when I try to save the PO, the PO number is getting generated, but an error message is coming as soon as I close the “Performance Assistance” box and ultimately the PO is not getting generated and it was not appearing in the “ME2M” Purchasing Document Reports.

The Error Message was:

Monday 18 December 2023

XSA – NodeJS


In the fifth and final part of our XSA blog series, we will be looking at the exciting topic of NodeJS. What functions does NodeJS offer under XSA? How can existing models be expanded? When (and why) should NodeJS be used with native HANA models? We aim to answer these questions and more with our sample model.

In the first blog, we have already seen that HANA XSA consists of many more services than was the case with the classic XSC environment. NodeJS plays a central role in this regard.

Saturday 16 December 2023

Send email notification via XSJS application in Enterprise HANA 2.0

Send email notification via XSJS application in Enterprise HANA 2.0.

Today I will discuss how we can create an XSJS application to send an email notification if any condition or threshold exceeds. i.e. if the value of a table field value exceeds a certain value ( like 50) it will send an email notification with all the rows exceeding the threshold otherwise, it sends all table data.

1. Create a XSJS application – 

From HANA studio go to development perspective and then create an XSJS project.

Friday 15 December 2023

HANA Near Zero Downtime Maintenance Activity

In this article, I am going to explain how to perform near zero downtime HANA maintenance activities in 4 tier HANA Multi Target setup.

Now days for customers main challenge is near zero downtime and with this objective – I performed HANA Node Operating System Maintenance activity in 4-tier HANA setup near zero downtime.

There was no impact to Business Operation during this major maintenance activity.

Wednesday 13 December 2023

JAVA Application generated CSV from HANA tables and save in a place.

In this blog I am going to discuss about how using a JAVA Application we can generate CSV from HANA tables and save in a place. We can done it using two ways i.e. by creating a Dynamic web application and upload it into the HCP platform. If HCP platform is of NEO platform it is better to create a web application to deploy.

You can not schedule an java standalone program in HCP NEO platform as no scheduler is given by default and you can not install it. You need the HCP Cloud Foundry version for it.

A. First discuss about the HANA Dynamic web application which will create a CSV file a save it in project workspace in server.

Wednesday 6 December 2023

How to enable HANA JDBC trace in CF Java Application


When you faced HANA JDBC client issue in your CF Java application, you need collect JDBC trace for your application.

How to enable HANA JDBC trace in CF Java Application

You can enable JDBC trace within the container of your application with “cf ssh”. I’ll describe the steps to do that.

Monday 4 December 2023

Localization / Translation’s in Build Apps


SAP Build Apps is a no-code app builder tool which helps us to develop enterprise-grade applications for desktop, browser, and mobile at a faster pace.

In this tutorial we will build an application for text translations based on the user selection.

What do you need to do this?

A BTP trail account with SAP Build Apps subscription.

Saturday 2 December 2023

Comprehensive Guide on SAP ECC to SAP S/4HANA Migration

Comprehensive Guide on SAP ECC to SAP S/4HANA Migration

SAP is pulling the plug on ECC support by 2027, and if you’re still on it, it’s time to think about making the jump to S/4HANA.

Wednesday 22 November 2023

Consuming data from SAP Datasphere into Power BI via ODBC connector

I wanted to share my proof of concept about consuming data from SAP Datasphere into Power BI via ODBC connection (Open database connection)


Datasphere tenant.
Power BI.
Need to create a database user for the particular space in the space management.
Host name, Port number, Password, Database username.
Need to add External IPV4 Address in the IP Allowlist.
Hana ODBC client.
Need to add credentials in Power BI.

Monday 20 November 2023

Paging concept in Odata service


Paging is used for restricting data(instead of feeding ALL) from the backend to the frontend which helps to improve the performance by reducing the records in the response.

Let’s take an example, suppose there is a UI5/Fiori application in which you need to display the list of sales orders. In that case, we need to fetch the list of sales orders from the database and send it as a response in that case the data volume will be huge and it degrades the performance of the application. Hence the concept of Paging.

Friday 17 November 2023

SLT – Calculation job in sender system could not be started


The SAP Landscape Transformation (SAP LT) Replication server is one of the tool provided by SAP for data migration. This tool can be used for real-time (and non-real-time) data replication sourcing from SAP or non-SAP systems into SAP systems.

This blog explains the process to troubleshoot where Calculation job in sender SAP system could not be started. The table replication status in SLT remains in Calculation step for sometime and then the status changes to Calculation failed.

Thursday 9 November 2023

Easy way to provide schema access to a BTP HANA Cloud Standard User


While working with the CAP applications, I have came across a situation that a standard HANA cloud user used in CPI cannot perform direct CRUD operations on the tables via the JDBC driver. The CPI will throw the error: insufficient privileges.  So, I am writing the blogpost for reference purpose.


Please follow the below mentioned steps:

Monday 6 November 2023

Missing posting rules in FEB_BSPROC

This blog post describes a workaround that will be useful for those actively working with bank statement processing in SAP. This workaround deals with a known problem for which SAP issued a KBA OSS-note 2210038 – “FEB_BSPROC – Posting rules missing in F4 help”. Unfortunately, the KBA does not provide any recommendations or workarounds. That’s what I’m trying to address in this post.

Let’s start. The problem is very simple. When the user processes items in the bank statement via transaction FEB_BSPROC (i.e., newer version of the transaction FEBAN) and tries to adjust the posting rule for an item, he/she can see only a limited number of posting rules. Screenshot below shows that only 9 posting rules are available in the list:

Saturday 4 November 2023

Creation and mapping of a new pay group from SuccessFactors to the S/4 system in SAP

In this blog, I am discussing the creation and mapping of a new pay group from SuccessFactors to the SAP S/4 system. I will be explaining each step of the process, from creating a new pay group in SF to mapping to the S/4 system, followed by the data replication process.

1. Creating a new pay group in SuccessFactors

In manage data, create a new pay group with your preference. It is recommended to have two digits as an external code for your pay group. Once the pay group external code is provided, enter the description and set the status to active. Parallelly, enter the payment frequency as per your requirement. Finally, map the legal entity for which this pay group you are creating and save it. Below is the screenshot attached for your reference.

Friday 3 November 2023

Return Delivery of Goods W/O Shipping (Using 451 Movement Type)

Returns from customer: (With Out Shipping)

Using movement type 451, you post customer returns without a return’s delivery in Shipping into blocked stock returns. The quantity is transferred from blocked stock returns to unrestricted-use stock and thereby transferred to valuated stock.

Process Flow steps:

Wednesday 1 November 2023

Most common built-in SQL functions that are provided with SAP HANA.

This blog on SAP HANA SQL script functions aims to make you comfortable with some of the important built-in SQL scripting functions.

SQL script is the scripting language used in the SAP HANA database. We can perform data-intensive operations in the SAP HANA database and transfer only a small result set to the application layer. This way, we can optimize the performance of a program using SQL script because we communicate with the database in its own language.

Monday 30 October 2023

HANA SQL Statements Optimization

In this article will demonstrate complete steps “How to optimize HANA SQL statements”.

What is an expensive SQL statement?

SQL statements consuming significant resources are called expensive SQL statements.

SQL statements that are not executed efficiently can cause local and system-wide problems. The most critical are the following areas:

Saturday 28 October 2023

HANA Authorization Fundamental

1. Introduction to HANA and Authorization

SAP HANA Authorization is to protect important data from unauthorized access and ensure compliance and standards are met as adopted by an organization.

SAP HANA provides a facility of multitenant database container i.e multiple databases can be created on single SAP HANA DB System. Hence SAP HANA provides Authorization related feature for all multitenant database container.

Wednesday 25 October 2023

SAP S/4 LEAN Integration with Manufacturing Execution systems

This case study talks about Cognizant’s Achievement in Implementing SAP S/4 LEAN- MES System Integration for efficient control over Manufacturing process in Pharma & Life Sciences Industry. As first of its kind, Cognizant team recently worked on S/4 LEAN and MES Interface development. This article covers some of the challenges that we faced, case for change, transition approach we took, the relevant reasons and some of lessons learnt.

Details of Manufacturing Execution systems

Manufacturing execution systems (MES) are computerized systems used in Pharma/ LS Client manufacturing Sites to track and document the transformation of raw materials to finished goods. MES provides information that helps manufacturing decision-makers understand how current conditions on the plant floor can be optimized to improve production output. MES works in real-time to enable the control of multiple elements of the production process (e.g. inputs, personnel, machines, and support services).

Monday 23 October 2023

Email template in S/4 HANA using OOPs concept

Email template feature explained in very simple way using OOPs concept.

Very often we get a business requirement to send email with table format. Before S/4 HANA we use to design the table using HTML <table> <th> <td> tags which is tedious and then use the conventional way of calling FM to send the mail but after S/4 HANA release SAP has ease by providing email template feature which can be send by calling methods.

Friday 20 October 2023

SAP SAP HANA XSA (mainly FSPRO) applications Access via external web dispatcher


Under this blog, I have outlined how to configure an SAP Web Dispatcher (WD) so that it acts as the reverse-proxy server for an XSA instance where SSL is terminated at the XSA server. The WD will simply route requests to the XSA instance. This setup allows the XSA host to be hidden from the end user.

Mainly if you have port-based XSA installed due to application limitations.

Wednesday 18 October 2023

Enhanced Custom Code Analysis in SAP Readiness Check for SAP S/4HANA Upgrades

In SAP Readiness Check for SAP S/4HANA upgrades, the Custom Code Analysis check now provides enhanced visibility to the ABAP test cockpit findings related to the target SAP S/4HANA product version. By creating a baseline of existing findings (that is, historical findings left over from a past SAP ERP conversion or SAP S/4HANA upgrade project) and exemptions in the ABAP test cockpit before running SAP Readiness Check, you can exclude these results from the check and focus on findings that are relevant for your upgrade project.

In addition, the custom code analysis has been integrated into the data collection framework of SAP Readiness Check for SAP S/4HANA upgrades to assist in the data collection process.

Friday 13 October 2023

The culture of repair as an analogy for Application Lifecycle Management


I recently read the book “The Culture of Repair” by Wolfgang M. Heckl. The topic and the core message also apply to Application Lifecycle Management. Anyone who no longer understands the basics and relations will soon feel lost.

SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Certification, SAP HANA Tutorial and Materials
Die Kultur der Reparatur

Wednesday 11 October 2023

Implement a More Efficient GIS-ERP Integration Following a Few Simple Steps

Deploy faster, more efficiently using in-built SAP HANA platform capabilities

After spending seven years at SAP developing patterns for a more efficient way to integrate GIS and ERP systems, I’ve returned to Locana to get directly involved in implementations that use in-built HANA platform capabilities to accomplish that objective. Below, I’ve listed steps that eliminate technical debt and complexity found in typical integration patterns.

IT leaders, GIS managers, and others can use the HANA platform to simplify integrations, enhance performance, and access advanced analytical capabilities by taking these steps. Combining ArcGIS Enterprise and S/4HANA ERP on the HANA platform makes this possible.

Saturday 7 October 2023

Mastering the SAP S/4HANA Transformation: A Comprehensive Guide to Technology Options

Your company is making a big move from SAP ECC to SAP S/4HANA. The transition is no small feat, and it requires careful consideration of your technology and tooling choices, including some crucial decisions that are often overlooked.

This article discusses technology options that organizations typically use during their S4 journey to transform various areas. Throughout the process, it’s crucial to find a balance between leveraging existing tools and introducing new ones, avoiding overwhelming teams.

Friday 6 October 2023

Multiple Input parameter in Hana Calculation graphical view

Aim: To create a calculation view with multiple input parameter that should display data corresponding to the input parameter.

The entire calculation view is here,

SAP HANA Exam, SAP HANA Prep, SAP HANA Career, SAP HANA Jobs, SAP HANA Preparation, SAP HANA Certification

Wednesday 4 October 2023

Step by Step creation of Custom Database Table and Updated it with HANA Class using ABAP on HANA Development

Now I am going to explain how do we create Customized Data Dictionary Table in ABAP on HANA environment and updating the created Table 

Step1: Open the Hana studio and Go to the project explorer.

Step2: Click on the package and Right click on Dictionary.

I.e.. Dictionary –> New –> Database Table

Friday 29 September 2023

BW/4HANA Security: SAP BW/4HANA Migration (Remote Conversion)


SAP BW/4HANA is a next generation data warehouse solution developed by SAP. The underlying foundation of SAP BW/4HANA is the SAP HANA in-memory database, which means that the data is stored and processed in the main memory of the server resulting faster data retrieval, processing, and analytics compared to traditional disk-based databases.

SAP BW/4HANA simplifies data modeling, enables real-time analytics, and supports integration with advanced technologies like big data and machine learning. It helps organizations consolidate, manage, and analyze large volumes of data, providing timely insights for data-driven decision-making.

Monday 25 September 2023

Calculation View In SAP HANA


SAP HANA, or “High-Performance Analytic Appliance,” refers to a database management system and application platform that uses in-memory technology. SAP HANA is a well-liked option for businesses looking to speed up their decision-making processes because it is built to manage enormous volumes of data and perform real-time data processing and analytics.

First, let’s see what’s a view in general

A view is a kind of imaginary table that will have the results linked to the SQL statement. Note that the data from the SQL query need not come from a common database table.

Saturday 23 September 2023

Detecting Implausible User-Entered Weighing Notes using Data Science with an SAP S/4HANA (On-Premise) System

After connecting an SAP S/4HANA System with Python and Jupyter Notebook using an ODBC driver we can now work with the data we retrieved.

In the world of data science, detecting anomalies and errors is an essential task. In this blog, we will explore a data science project (from my practical phase in my dual curriculum) focusing on detecting implausible, manually-entered weighing notes where for example the weighing unit was mixed up.  These anomalies can have significant consequences in inventory, billing, or logistics.

Friday 22 September 2023

How to use Smart Data Integration Replication Task to get delta from SAP Analytics Cloud to HANA


This blog is about how to use Replication Task in Smart Data Integration to replicate data from SAC to your on premise HANA.  You can replicate SAC planning transaction data not only with delta but also only full. The full load also applies to the analytic models in SAC. We will focus on delta in this blog.

Some customers have chosen this way as an implementation and like the flexibility in HANA replication task like filters, monitor and field mapping from SAC models to HANA DB tables. The others especially in S/4 HANA have concerns or restriction in company policies not to access the HANA DB level thus using SDI directly on HANA DB is no go for them. I would like to hear your feedback what are your preferred way for this integration.

Wednesday 20 September 2023

Migration Monitor (FINS_MIG_STATUS) – How to analyze errors and information and recommend possible solutions.

As Part of the conversion process to S/4HANA, the migration monitor (FINS_MIG_STATUS) is responsible for coordinating the migration of Finance data into the new S/4HANA data model. To access details about a data migration run, click the Overview tab and see the list of activities and their respective statuses.

Incomplete steps or those with errors are displayed with a red status. The data migration process stops, preventing any subsequent tasks from being executed by the system. To continue with the migration, it is critical to fix the errors found in these tasks. The omission of this activity will delay the migration process.

Friday 8 September 2023

Deadlock issue Analysis


The problem is the Database dead lock that occurred on every week at particular day and time in the production environment. Due to this database deadlock issue, the system would halt the background process, the users would not able to login into the system and would not able to process any document creation or change in the production system. The database table lock entries are being created spontaneously without releasing lock entries. For instance, within the short span of time more than 600k entries are created. So, there is no system resources free to process the rest of the operation/process.

Wednesday 6 September 2023

[MDG-F]: New hierarchy upload modes for file upload

From a long time hierarchy restructuring process in MDG-F has been tedious and time consuming and customers have requested SAP to provide better way to handle the overall hierarchy restructuring process. With the customer connection program for MDG 2023 SAP has provided new options in file upload to restructure the hierarchies.


Customers with bigger hierarchies >75~100K nodes, restructuring has been always been challenging since the file upload application goes for timeout or memory issues. It happens as the only option currently to restructure is to use “Delete ALL” mode while using file upload and the system takes a lot of time to delete the entire hierarchy and re-create the new one. For customers where hierarchies are re-structured multiple times during a year, the file upload process creates a bottleneck in their operations.

In this blog post we will cover basic details of these upload modes.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation


The new hierarchy upload modes are released with the note 3258404, this note is applicable from S/4 HANA 1809 onwards. The 3 new modes introduced are listed below:

1. Replace nodes -> For each uploaded edge in the file, the system deletes all direct children of the edge’s parent node and creates only the children specified in the upload file. The sequence of the children from the file is considered. This mode could also be used to simply change the sequence of nodes without applying other changes.
2. Move children-> For each uploaded edge in the file, the system checks whether the child of that edge also exists under different nodes within the same hierarchy and removes it from those. Then, this child is placed under the new parent as the last object.
3. Remove Edges-> For each uploaded edge in the file, the system deletes such edge in the system if it exists. There will be a warning if it does not exist.


1. In the file upload application, the upload mode now has these 3 additional options when the type of transfer is “Hierarchies”.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

2. Let’s take an example of a sample CC hierarchy and see how each upload mode works.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

3. MOVE CHILDREN: Now we want to move CC1_YK cost centre under group PARIS, to JAPAN. Here we will use move children option since we want to just move one of the children of a node to a different node.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

4. REPLACE NODES: Lets’ say we want to reorder the CC groups, currently PARIS is first and then JAPAN. But in the new hierarchy structure we need to move JAPAN to top and then PARIS, then we will use replace node.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

5. REMOVE EDGES: Now suppose we want to remove CG121212 from the below hierarchy then we upload the file with remove edges option

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

Saturday 2 September 2023

saptune 3.1 on the Horizon

In a few weeks saptune 3.1 will reach the public repositories of SLES for SAP Applications. Time to talk about the changes and new features.

As always saptune 3.1 will be released for all Service Packs still in support, namely:

  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
  • SUSE Linux Enterprise Server for SAP Applications 15 SP1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4
  • SUSE Linux Enterprise Server for SAP Applications 15 SP5

Thursday 31 August 2023

Customer Aging and Supplier Aging Reports at the Line Item Level using Analytical Query in S/4HANA Cloud, Public Edition


Functional consultant or a business key user can effortlessly generate supplier and customer aging reports using the Custom Analytical Queries App for the scenarios outlined below.

Scenario – Accounts Payable Aging:

Your client requires a supplier aging report that displays the aging at different levels: Supplier level, Reconciliation G/L level, Supplier Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

Monday 28 August 2023

SAP HANA Overview

1. What is HANA?

SAP HANA (High Performance Analytical Appliance) is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk.

HANA is the first system to let you perform real time online applications (OLAP) analysis on an online transnational processing (OLTP data structure).

Monday 14 August 2023

XSA Data Loading


We will be addressing the data loading process in detail. How is data loaded from a source system? How is data loaded from one table to another within an HDI Container? What artifacts exists for loading? All relevant questions will be answered and considered with the help of our example project.

Data loading basics

In our first blog, we explained the fundamentals of XSA, while in our second blog we understood persistent structures and created our XSA example project. The XSA environment takes a new course when it comes to data loading as well, and uses its own services and structures.

Friday 11 August 2023

How to find the underlying Data structure of an Application Building Block ID and Node name to enhance FPM application.

This blog is relevant to a scenario wherein underlying Data structure is not provided in the component configuration.

Problem Statement Example

Create a custom field in the External Data tab of maintenance order app.

SAP S/4HANA, SAP HANA, SAP HANA Certification, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Jobs
Maintenance order app – External Data tab

Monday 7 August 2023

XSA: HDI Container, Persistence and CAP


We will be addressing persistent data storage in the modern HANA platform. How are tables created in XSA? What role do HANA Deployment Infrastructure (HDI) containers play in this respect? What are the advantages of SAP’s Cloud Application Programming Model (CAP)? We will answer these exciting and essential questions with the help of an example project which we have created in the Business Application Studio (BAS).

HDI Containers

Based on our first blog, we know that the introduction of XSA resulted in a fundamental paradigm shift in creating native HANA models. The approach of a central (database-focused) system is giving way to a cloud-focused system with separate applications and dedicated services. But how are applications separated, exactly?

Wednesday 2 August 2023

Data ingestion from SAP HANA to Databricks Cloud and visualize in Tableau

The process of gathering data from numerous sources is an essential prerequisite for organizations to carry out advanced analytics, data science, and machine learning. However, ingesting and consolidating this data to establish a trustworthy, unified data repository is an arduous and expensive task.

In this blog post, I will demonstrate the process of ingesting data from the SAP HANA Cloud database by establishing a connection with HANA DB using the Python Database API Specification. We will then explore how to seamlessly integrate this data into Databricks Delta Lake. Finally, I will guide you through visualizing the ingested data in Tableau by establishing ODBC connectivity between Databricks and the Tableau tool.

Friday 28 July 2023

Accessing Objects from Another Local Container in HANA XSA and Deploying Selected Artifacts Using PACKAGE.JSON in HANA DB: A Step-by-Step Guide

It’s recommended to use Shared local Container/Schema details within the development team while working on the same project or Dependent Data model. The procedure outlined below explains how to access objects from another local container by modifying the YAML file in HANA XSA:

1. If you are the owner of the Source local container/schema (Cont_1), you need to provide access to another developer who intends to consume the object. Use the SQL script provided below to grant access:

Monday 24 July 2023

Basic Principles of SAP HANA XSA


First, one important piece of information: XSC i.e., the native developments of SAP HANA artefacts in the HANA Studio, is obsolete. It is no longer being developed and new features will not be added. The future is XSA and that is where SAP’s entire focus will be regarding HANA.

SAP HANA XSA is a paradigm shift in developing with SAP HANA. This statement may at first seem extreme, because at first glance, compared to XSC, the application has just gotten new components such as NodeJS or HTML5.

Wednesday 5 July 2023

Migrate to SAP HANA InA in Web Intelligence


SAP BusinessObjects Web Intelligence and Semantic Layer offer multiple connection options to access and query SAP HANA views in SAP BusinessObjects BI:

◉ SAP HANA Relational connection, based on HANA ODBC and JDBC drivers, allows you to connect to HANA views via HANA SQL access, and to query them using the SQL query language. This connection option is optimized for better performances on HANA at refresh time, but it does not support HANA hierarchies.
◉ SAP HANA OLAP connection, that offers a multi-dimensional access to HANA models via HANA MDX access, allows you to query HANA views as OLAP cubes (including the support for HANA hierarchies) using the MDX query language. This connection option is not available on SAP HANA Cloud that does not support MDX queries.
◉ SAP HANA InA OLAP connection, based on HANA Information Access (InA) service, allows you to define InA queries with rich or complex semantics supporting multi-dimensional concepts (including the support for HANA hierarchies) and spatial and search features on HANA models. In this connection option, you can select HTTP or JDBC protocol to run InA queries from HTTP requests or directly from the SAP HANA JDBC driver.

Monday 3 July 2023

Database Unavailable – HDB Connectivity issue Part 1


Although the database instance was up and all HANA services were active, a database unavailability alert appeared in the “Focussed Run” or in the CCMS alert.

In this article, identify the root cause of the HDB connectivity issue and also check whether the KEY entry corresponding to the database user was present in the hdbuserstore.

Also, identify which database user was required to add the KEY entry in hdbuserstore.

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.

Wednesday 31 May 2023

How to setup the Required/Mandatory field in BP based on BP role in SAP S/4HANA

Generally, when you do changes to BP field settings as per the above note things will work fine. But, for some cases the results will not be positive! Example, you have made a field as mandatory in customization but when you check in the BP transaction still the field is optional. In this case, follow the below steps.

What to do when a vendor field is displaying as optional though the field has been set to mandatory?

Reproducing the Issue

There could be multiple ways of reproducing the error which might be based on different fields, but I am taking a specific example here:

Monday 29 May 2023

How to compare an APL model to a non-APL model ─ Part 2

After completing the first part of the blog you should have a hold-out dataset in HANA dedicated to test, for both the Census case, and the California Housing case. In this second part we will build an APL model and a non-APL model on the same training data. Predictions will be made against the hold-out dataset to ensure a fair comparison between the two models. We will use standard metrics to measure the accuracy of our classification models and our regression models.

Regression Use Case

We define the HANA dataframes for training and for test using the tables prepared during part 1:

Friday 26 May 2023

How to compare an APL model to a non-APL model ─ Part 1

You need to compare an APL classification or regression model to a non-APL model, and you want to make sure the evaluation process is not flawed. This blog should help you run this comparison in a fair manner; it includes code snippets you can copy and paste in your own Python notebook.

The importance of using a Hold-out dataset

To compare the accuracy obtained by an APL model and the accuracy obtained by a non-APL model, the use of the same input dataset for model training and model testing, as shown in the following diagram, can be tempting because it is quick and easy to do:

Wednesday 24 May 2023

Creating Reports using SAP Analysis for office: Basics

First we will discuss about why analysis for office is useful for Business intelligence reporting and what are the advantages and the steps to create a report, scheduling it to specific users.

SAP Analysis for Office is a plugin from Microsoft which can be used with excel and power point.

When Excel plugin with SAP Analysis for office we can use the OLAP connection from different data sources (like SAP HANA, SAP BW etc.) and build different kind of dashboard and Dynamic reports. In Finance and COPA arear SAP Analysis for office widely used –

Monday 22 May 2023


This blog would give basic idea on different concepts which are  used in the  S4HANA CDS view.

It will be helpful for new beginners on basic concepts which we can use while creating a CDS views

@AbapCatalog.sqlViewName:It is mandatory annotation and which is created in  SE11 (16 Characters length) after activating and it will not be same as  view name/entity name.

@AbapCatalog.compiler.compareFilter: It defines the evaluation of filter  condition in path expression. 

True: If they match, the associated join expression is evaluated only once.
False: A separate join expression is created and evaluated for each filter condition.

Friday 19 May 2023

Add additional Fields in BMBC – New User Group in S/4HANA

Image/data in this Blog is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Batch information Cockpit:  T-code: BMBC

SPRO -> Batch Management -> Batch Information Cockpit -> Define User-Group-Specific Selection

We can see all the standard SAP templates

Wednesday 17 May 2023

SAP Datasphere: Seamless extraction of business insights in multi-cloud environments with HANA Machine Learning and FedML

This blog post describes how SAP Datasphere can be used to provide a seamless data science experience by facilitating the training of machine learning (ML) models on different platforms (e.g. using hana_ml in SAP HANA and using FedML on hypercaler landscapes). Furthermore, it shows how those ML models can work hand-in-hand to provide data-driven insights to business users without the need of expensive data replication and fully preserving the business context of the data. To illustrate the point, a real-life use case is reviewed and the selection of an ML runtime is discussed in the context of data gravity, availability of the required ML tools on the platform and business criticality of the data. The objective of this blog post is to provide a high level concept and consideration guidelines for data scientists and architects when working on similar multi-cloud cases.

Monday 15 May 2023

SAP Commissions – Data Anonymization @ Database side

Data Anonymization in SAP HANA

Anonymization methods available in the SAP HANA database allow you to gain statistically valid insights from your data while protecting the privacy of individuals.

Why Anonymize?

In a data-driven world, a growing amount of business data contains personal or sensitive information. If this data is to be used by applications for statistical analysis, it must be protected to ensure privacy. Trivial modifications to the data like replacing information that directly identifies an individual such as name or social security number (pseudonymization) or simply removing the information is not enough. Re-identification is still possible, for example if additional information is obtained (referred to as a linkage attack).

Friday 12 May 2023

RISE Migration with Tenant Copy Strategy

The most particular case about migration is the downtime, estimate the windows that customers need to achieve and perform a good project, but this not always happen and with the native HANA methodology of HANA System replication (HSR) we can mitigate some risk about Downtime, but as you well know to execute HSR is necessary to have the same SID in both HANA Nodes (and others prerequisites – – General prerequisites for HANA System replication),  when the customer already have the same SID of HEC/RISE is good because we review the others prerequisites and we can move forward but when the it cannot be completed we will face issues and the downtime is impacted.

One of this common scenarios is when a customer has already on HEC all infrastructure and wants to move on RISE Contract, if the SID of BD HANA for example is D01 On premise and RISE is D10 and 10TB of size in HANA DB and the Business windows is just 24hrs, in this scenario we cannot move with HSR and is when enter Tenant Replication (Copy / Move) , with this new feature in HANA DB we can move or copy a tenant in few hours (Depend of the bandwidth), for this case mentioned above is possible with good VPN of 100MB/s transfer the tenant to RISE in just 4 hours and later perform the finalize replica and startup the HANA DB in the new target (RISE), then we will proceed with the next steps in app server, post migration and deliver to RISE for post activities migration, we can explain in more details but first we need to fill the prerequisites:

Wednesday 10 May 2023

S/4HANA 2022 What’s New – Target PSA in EWM with Automatic WT creation


The target production supply area (PSA) defines the production supply area of the next production step. It is used if a semifinished product remains in production and is needed for a subsequent production step.

SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Learning, SAP HANA Tutorial and Materials

Dependencies --> If the storage location, where the semifinished product is placed upon order confirmation or goods receipt, is not managed by the warehouse, the field is only for information character.

Monday 8 May 2023

ssl connection from hana studio to sap hana DB

After activating the sslenforce parameter in the hanadatabase, our attempts to connect to the hana database via hana studio were unsuccessful due to an “only secured connections are allowed” error. Here is one of the methods we employed to establish a secure connection with the hana database.

Here are the steps we followed to establish a connection from SAP Hana Studio to the HANA DB.

1. Export the Hana server certificate using sapgenpse as per note 2475246.

Friday 5 May 2023

Advanced Foreign Currency Valuation in S/4HANA Cloud (Cloud ERP)

Advanced Foreign Currency Valuation

Advanced Foreign Currency Valuation is part of Advanced Valuation in Financial Accounting. Advanced Valuations support you in following accounting standards, for example, IFRS9. The following processes are part of advanced valuation and are realized as job templates in the Schedule General Ledger Jobs app.

1. Post Discounting of Long-Term Assets and Liabilities
2. Advanced Foreign Currency Valuation
3. Post Credit-Risk Based Impairment
4. Post B/S Reclassification

Wednesday 3 May 2023

Event Based Revenue Recognition – Sell from Stock (1K2)

The concept of this scope item is to help speeding the revenue recognition process in SAP S/4HANA Public Cloud.

The classic problem is that the revenue is not always recognised at the same time as COGS as the COGS is posted during Goods Issue to customer and then the revenue will be posted during the billing.

With this new feature of Event Based Revenue Recognition – Sell from Stock, system automatically posted the revenue adjustment at the time of Goods Issue (depends on the EBRR Key that you have selected but in this example, I will focus on the Revenue Recognition Key – SFS.

Monday 1 May 2023

Field Status Variant in SAP

The purpose of this blogs to explain about the field status variant in SAP.

What is Field Status Variant?

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Materials

Friday 28 April 2023

Streamlining Process with SAP’s Mass Maintenance Order Confirmation: A Guide to Efficient Order Confirmation


In a manufacturing environment, maintenance orders are crucial to ensure the smooth operation of equipment and machinery. Tracking the progress of maintenance orders and confirming their completion is essential to maintain efficient operations. SAP Fiori provides a user-friendly interface that allows users to perform tasks quickly and easily, including the Mass Maintenance Orders and Operations tool. In this blog, we will discuss the steps involved in using this tool in SAP Fiori.


The first step is to access the Create Maintenance Order app in SAP Fiori. You can do this by logging in to SAP Fiori Launchpad and searching for the app in the App Finder. Once you have found the app, click on it to open it.

Wednesday 26 April 2023

Connect SAP Web Intelligence to HANA Cloud with just two steps

Yes, it is so easy to connect SAP Web Intelligence to an SAP HANA Cloud tenant into just two steps.

In this blog post, I want to share how we can work with SAP HANA Cloud and SAP Web Intelligence to create BI reports on HANA calculation views with a Step-by-Step approach.

I will split this blog post into two sections:

◉ Creating a OLAP connection to SAP HANA Cloud
◉ Consuming HANA Calculation Views from SAP HANA Cloud

Monday 24 April 2023

How to handle thousands of orders per day from different origins in one route plan


Without doubt, it is planning and dispatching that makes the economic difference for a service organization. Given economically solid contracts and under the assumption that all subsequent execution and billing / collection activities are performed well this statement is very true. The specific challenge for efficient logistical operations is that each order may consist of numerous tasks which – in the end – will have to result in a plan combining the tasks in optimally arranged routes fully serving each customer across service orders. 

Given that fact, PROLOGA decided to build the new Industry Solutions by PROLOGA – Planning and Dispatching as the first solution component in a next generation product portfolio.

Friday 21 April 2023

SAP Datasphere – SAP Data Provisioning Agent Upgrade


This blog is about updating the SAP Data Provisioning agent which is also known as “DP Agent” (On windows). The Data Provisioning Agent provides secure connectivity between the SAP HANA database and you’re on premise, adapter-based sources. The DP Agent control all SAP HANA smart data integration (SDI) Adapters and connections to HANA database. It acts as the communication interface between HANA and the Adapter.

SAP Datasphere allows you to use SAP HANA smart data integration (SDI) and its Data Provisioning Agent to enable on-premise connections. To do this, you first have to download and install the SDI Data Provisioning agent to a network location from which it can establish HTTPS connections to SAP HANA on Cloud.

Wednesday 19 April 2023

OData annotations in SEGW with example and consume it in visual studio to create a fiori application


In this blog you will understand how to create Odata annotations in SEGW with example and consume the service in visual studio and display the output in fiori launchpad.

When ever you are adding annotations to odata service in segw we are suppose to write the coding in MPC_EXT class inside DEFINE METHOD( you have to redefine this method).

Usually we write annotations in CDS view and then consume it in odata service but in this blog you will see an example of creating annotations in segw.

Monday 17 April 2023

Shelf-Life Planning within SAP IBP Response & Supply Planning


◉ Shelf-Life Planning is a feature introduced as part of SAP IBP 2211 release within the Response & Supply Planning module (Order-based planning). In order to use this feature, the IBP Planning Area must be based on the SAP7F model entity and use RTI for data integration between IBP and S/4 (or ECC) systems.
◉ It’s a critical feature for companies that manage the shelf life of their products, therefore it is addressing industries that deal with perishable goods such as Pharmaceuticals, Food and Beverages, and Chemicals.

Friday 14 April 2023

Run SAP on VMware in IBM Cloud

VMware as a leader in the virtualization industry is obviously the first choice when it comes to running SAP on an elastic, agile, complete (top to bottom) and certified virtualized platform.

Most likely when we look at a running SAP workload on VMware, we will intuitively think of running workload on-premise or private data center … Well, it makes sense, but it is not the only option for VMware.

Thanks to the strong partnership between VMware, IBM and SAP, customers can operate their SAP workload in IBM Cloud on VMware in a fully certified environment !! which is a unique offer in the cloud industry.

Wednesday 12 April 2023

Summary about Table Function and Analytical Privilege in SAP HANA

SAP HANA, SAP HANA Exam, SAP HANA Guides, SAP HANA Learning, SAP HANA Prep, SAP HANA Preparation, SAP HANA Table

1. Table function: Table function is a piece of code written is SQL script in HANA which used to return data as a tabular format after calculating a business scenario logic. Complex logic can be can be combined with Application Function Library – AFL giving even more functions for complex analysis. Is is acting as a read only procedure.

Saturday 8 April 2023

Compute intersection size with HANA spatial data

Imagine you were given a map divided into blocks, with a lake marked on it. And now you’re supposed to decide to which block this lake belongs.

SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Tutorial and Materials, SAP HANA Learning, SAP HANA Guides
Map with blocks and lake

Friday 7 April 2023

Achieve full Traceability in your SAP projects by using Focused Build tool.

Want traceability in your sap projects?

Consider implementing Focused Build because traceability is built in. Focused Build tool makes all processes, activities, and outputs traceable in an SAP implementation.

Often overlooked as tedious and costly, yet traceability is important for Value tracking and Targeting value. Traceability is the ability to trace Backlog from its inception to delivery and through all stages of development, testing and deployment.

The capability to trace backlog depends largely on the tools in place. Maintaining traceability reports without tools could be very expensive and often becomes unreliable because of the need for constant manual updates.

Wednesday 5 April 2023

Calculation View Features of SAP HANA 2.0 SPS07

With the release of SAP Web IDE SPS07 and HANA 2.0 SPS07, new features in the area of calculation view modeling will become available that had only been released in SAP HANA Cloud before.

Below is a short description of newly released features. For examples of the individual features have a look at the respective project “SPS07_Selected_Calculation_View_Modeling_Features” that can be found here.

Comments in Expressions

Use comments in expressions to better document the intention behind expressions. This will help during later refactoring and improve collaborative working.

Monday 3 April 2023

Basic of AMDP script and implement a SAP BW transformation logic using AMDP script

Today, I am going to discuss the basic of AMDP script and implement a SAP BW transformation logic using AMDP script.

First question is what is AMDP script and why we will use AMDP instead of normal AMAP script for different types of routine like Start End and expert routine.

AMDP is ABAP managed Database Procedure which used to run in HANA runtime. All the database logic push to the database level for execution. In the other hand the ABAP procedure execute the logic in the ABAP layer inside ABAP runtime environment.

Friday 31 March 2023

Model Compression without Compromising Predictive Accuracy in SAP HANA PAL

The recent success of applying state-of-the-art AI algorithms on tasks with modern big data has raised concerns on their efficiency. For instance, ensemble methods like random forest usually require lots of sub-learners to achieve favorable predictive performance, which result in an increasing demand for model storage space with an increasing dataset size.

Such tree-based models may go to GB level, making them difficult to deploy on resource-constrained devices or costly in the cloud. Moreover, a larger model usually causes a higher inference time and energy consumption which are not usable in many real-world applications.

Wednesday 29 March 2023

Generic Data Extraction using ABAP CDS view from S/4HANA to BW4HANA

Today, I am going to discuss about the generic data extraction using ABAP CDS view from S/4HANA to BW4HANA. Before That, let go though details of ABAP CDS view like what does it mean by ABAP CDS view , how it overcome some limitation of ABAP classic view ,commonly syntax, how it differs from HANA CDS view,what are the object that generated when you activated a CDS view , basic CDS view based extraction architecture , some important things to remember about ABAP CDS view.

Finally we will take a scenario where cross plant material description we will populate with material number in abap CDS and extract it in our BW/4HANA landscape. Let’s go through one by one.

Wednesday 22 March 2023

SAP HANA Monitoring with RybaFish: custom KPIs

Today I want to draw your attention to the visual aspect of information presentation.

The human brain is incredibly good at getting and interpreting visual information. We spent years in our high schools and universities analyzing graphs of functions and getting common with this form of information. A huge part of those charts has time on the X-axis, in this case, we have the value dependency on time. One extreme example of this approach is the so-called “black box” or flight recorder read-outs used in aircraft accident investigation.

Wednesday 15 March 2023

“Selection of Production Version” at the time of converting planned order to Production order

Intro: – Hi folks, I am writing this blog on “Selection of Production Version” at the time of converting  Planned order to Production order.

Let’s assume for one Finish goods there are lot of productions versions, when we create planned order and convert it into Production order specific production version is selected automatically, based on how we set the master data in MRP 4 view (production version).

With the help of this Blog, we understand how to select production version manually, when we convert planned order into production order.

Monday 13 March 2023

Implement a Node.js module (without xsjs support) to populate with HANA DB artifacts in HANA XSA

In this blog I am going to discuss about the pure node js module (without xsjs support) to populate with HANA DB artifacts in HANA XSA.  Here we will populate a table from HANA HDI container.

Pre steps:

1. Create a Cloud DB instance:

A. Log into the trial account and go inside dev space and create DB instance in cloud.

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Guides, SAP HANA Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Career

Friday 10 March 2023

Create a CAPM Application using SAP Business application studio for file-based persistence.

In this session we will discuss about the file base persistence of a local file using a simple CAPM application developed in SAP Business Application Studio.

SAP CAPM (Cloud Application Programming Model) is a framework on Cloud Foundry environment provided for boiling service and application which can use to solve different business scenario for enterprise corporation. The Core Data & Services (CDS) to build data models and service definitions  consuming the data from the underlying SQL database like HANA  and exposed as a service to different platform. The are two types of runtime environments in CAPM i.e. Java and Node.JS. The Structure looks like below –

Monday 6 March 2023

Old Snapshot deletion to reduce doubled/Larged /hana/data volume size

Recently I came across the situation where the HANA Data Volume Used Size is Doubled or Much Larger than Before and even HANA reclaim could not free up data volume used size.

This was for non-production HANA system where we had recently done the system refresh from production system which has HA (HIGH Availability) Setup. Usually this problem happens post system refresh as replication snapshots from production gets copied.

Friday 3 March 2023

SAP HANA Cloud Migration: Setup your on-premise HANA system for the Self-Service Migration tool

In the last blog, you learned how to migrate instances from the SAP HANA Service for BTP on Cloud Foundry to SAP HANA Cloud by using Self-Service Migration tool. Now, I’m happy to announce that this tool is available for on-premise HANA database landscape as well.

Currently, the tool runs only the compatibility check. It doesn’t support catalog or data migration yet, but the support for this is planned for later this quarter.

Here, you will learn how to set up your on-premise SAP HANA migration project and to check your database for compatibility with SAP HANA Cloud. The example landscapes presented below are:

Wednesday 1 March 2023

Blue Field Implementation with Selective Data Transition for SAP S/4HANA Migration: Benefits, Challenges & Best Practices


As businesses continue to evolve, they must adopt new technologies and systems to stay competitive. For many organizations, migrating to the SAP S/4HANA platform is a critical step in their digital transformation journey. The SAP S/4HANA platform provides businesses with real-time data and insights, improved productivity, and streamlined processes. However, migrating to the SAP S/4HANA platform can be a complex process that requires careful planning and execution.

One approach to migrating to the SAP S/4HANA platform is the Blue Field Implementation with Selective Data Transition approach. This approach enables organizations to adopt the SAP S/4HANA platform while minimizing business disruption and data loss. In this article, we will explore the Blue Field Implementation with Selective Data Transition approach in detail, including the benefits and challenges of this approach, best practices, and the role of a trusted partner.

Monday 27 February 2023

Migrate your SAP HANA Services for BTP (on Cloud Foundry) to SAP HANA Cloud using Self-Service Migration Tool

1. Benefits of migration to SAP HANA Cloud

SAP HANA Cloud is a cloud-native database-as-a-service (DBaaS) for modern applications and analytics across all enterprise data. SAP HANA Cloud provides exciting new innovations and features that were not offered by SAP HANA Service on Cloud Foundry (CF) such as pay-per-usage billing, multi-tier storage, including a petabyte scale built-in data lake allowing you to scale computing and storage resources separately and elastically. SAP HANA Cloud also offers automated near-zero downtime upgrades, HA/DR (up to 99.99% SLA), and availability in a large variety of regions via four different cloud service providers, including Microsoft Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS) and Alibaba Cloud. Last but not least, you can also achieve Total Cost Ownership (TCO) benefits, as it is cheaper to run comparable workloads on SAP HANA Cloud versus HANA Services on CF. You can always use Capacity Unit Estimator to anticipate the cost benefits you will have depending on your SAP HANA Cloud configuration. 

Friday 24 February 2023

SAP Hana Dynamic Tiering Installation and Configuration


What is Dynamic Tiering? 

SAP HANA dynamic tiering is a native big data solution for SAP HANA. Dynamic tiering adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability.  

SAP HANA dynamic tiering adds the SAP HANA dynamic tiering service (esserver) to your SAP HANA system. You use this service to create the extended store and extended tables. Extended tables behave like all other SAP HANA tables, but their data resides in the disk-based extended store.  

Wednesday 22 February 2023

SAP HANA Cloud Intelligent Enterprise vision

In many companies the business application system landscapes over time have become very large and extremely complex. This scale and complexity slows down innovation, because even a small change can have a huge impact on the whole system landscape. The impact could be business process related, so extensive testing in all affected systems is required. The change could also impact system landscape infrastructure, which might result in ordering additional hardware or upgrading the affected database or operating system. All these steps are time consuming, cost money and involve different experts in specific knowledge areas. This is the opposite of what the business expects. A move to the cloud would improve this situation in many business areas.

In this article you will learn how about SAP HANA Cloud, it’s position in the SAP Business Technology Platform (BTP) and how the SAP BTP and SAP HANA Cloud fit into the SAP Intelligent Enterprise vision.

Monday 20 February 2023

SAP Data Migration Cockpit – Nutshell


With introduction of S4 HANA, SAP has introduced us to many new tools built in the system. Today we will talk about one such tool used for data migration in S4 HANA, SAP Migration Cockpit.

I will try to cover the details which I have got over the period by working on this tool.

What’s in it for you?

The blog will explain the different pieces of migration cockpit which will give you the very good start and understanding of tool.

Friday 17 February 2023

SAP Mobile Platform 3.1 Installation, Migration and HA

SAP Mobile Platform (formerly Sybase Unwired Platform) is a mobile enterprise application platform designed to simplify the task of creating applications that connect business data to mobile devices for workflow management and back-office integration.

Scenarios: Below scenarios where SAP Mobile platform can be used

◉ No Back-end
◉ OData service in SAP Cloud platform
◉ SAP Gateway OData Service on-premise
◉ 3rd Party Back-end System on-premise

Wednesday 15 February 2023

Technical Setup guide for the Co-PIN Integration between SAP S/4HANA Cloud and SAP Cloud for projects, project collaboration service

Business Purpose and Flow

The integration allows you to integrate the SAP S/4 HANA Cloud with the application SAP Project Intelligence Network. With this integration, you connect with project owners, engineering service providers, contractors, subcontractors, and building material suppliers on a single BIM collaboration platform to eliminate waste and rework and increase productivity with the SAP Project Intelligence Network application.

◉ Cloud deployment
◉ Single repository of construction information
◉ Shared digital twin that supports open BIM standards
◉ Source of reusable operations information

Monday 13 February 2023

Native Base64 decode function in SAP HANA

Recently I had to work around some limitations in SAP Business One’s Service Layer. As a result, I had to decode some BASE64 string that was stored in our customer’s database, modify the (unencoded) string and then save it back, all from within a native SAP HANA Stored Procedure.

To my surprise, there is no native function to achieve this, at least not that I could find in my couple of hours of investigation.

So I set out to build my own function to allow for decoding Base64 strings on the database level.

I am posting this function here, so that others can save themselves a few hours if they are ever presented with the same problem.

Saturday 11 February 2023

New Robotic Process Automation for Performance and 360 Review forms


The manager, second level manager, and their coworkers’ ratings should all be taken into account when calculating the overall rating in PM form.

Customer pain point

Whenever the overall scores or final ratings are been given to employees the ratings to be considered by the manager, second level manager, Human resource head and only 20 % of total ratings to be considered from ratings provided by the peers of employee and in the ratio of 80:20 the ratings to be calculated and added to the overall scores of pm form and the ratings should not be revealed to any of the team members (including partners team).

Friday 3 February 2023

Autostop HANA database when reboot a linux system (with systemd integration)

As a technical sap consultant working for large companies we are facing several challenges concerning big SAP- and HANA-landscapes. There are a lot of automated processes for administrating of these landscapes and this leads to problems in connection with HANA databases. One of these challenges I wan’t to share in the following blog post.

Initial situation

Because of security reason there is a monthly linux patching timeframe which is during night and there is no one that can stop the HANA databases before patching and rebooting the linux servers. Currently the reboot is triggered although HANA is running, so the database has always to recover after restart because there is no ordinary shutdown of the HANA database. When analyzing the traces we always see entries like the following in the startup process after a reboot (without shutdown HANA database before):

Friday 20 January 2023

Summary about HANA Query execution and optimization - Good to know about SAP HANA

Today I am going to discuss how when a query executed in SAP HANA, How it is processed and Optimized and generated a plan and push to a engine. This concept is will help you to optimize HANA Query in latter stage.

The summary architectural diagram is given below which is provided by SAP in the below URL –

SAP HANA, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA, SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Certification

Wednesday 18 January 2023

Automating SAP HANA Scale out System with Non-shared Storage

This document demonstrates the steps required to automate the installation of an SAP HANA scale out system with non-shared storage. Participating hosts have the mandatory file systems (XFS) mounted locally, such as /usr/sap, /hana/data/, and /hana/log.

For this demonstration, two nodes have been considered, but the design can be scaled up as needed. The only file system that is shared between the hosts is /hana/shared.

The generated template can be extended with other automation scripts (refer section: Extension) for provisioning the systems automatically using Terraform in AWS.

Friday 13 January 2023

Create a XSJS application consume calculation view and sent it to Https in HANA XSA

In this section I will discuss about the create a XSJS application consume calculation view and sent it to Http response to SAPUI5 in SAP HANA XSA using WEB IDE.


SAP HANA XSA, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Tutorial and Materials, SAP HANA Calculation

Wednesday 11 January 2023

Expose Calculation view as a service via OData in HANA XSA using Web IDE

In this blog I am going to discuss how we can  expose Calculation view as a service via OData in HANA XSA using Web IDE. Then  either you can consume it in SAPUI5 or other front end interface applications.

Before that we need to understand the architecture of HANA XSA  which is given below –

SAP HANA Exam, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Skills, SAP HANA Job, SAP HANA OData