Wednesday 30 March 2022

SAP’s Banking Product – SAP Financial Services Data Management and Platform(FSDM/FSDP), SAP Financial Planning Subledger(SAP FPSL) Part 1

SAP’s Banking Product – SAP Financial Services Data Management, Platform(FSDM/FSDP), SAP Financial Planning Subledger(SAP FPSL)

Writing this series of blog post on SAP’s Banking products formerly known as SAP Bank Analyser now known as SAP Financial Planning SubLedger or SAP FPSL. SAP was eagerly working straight after SAP S/4 HANA release to provide banking solutions on it’s flagship product Database i.,e SAP HANA and SAP Application suite ABAP stack on top it.

The main reason of writing this blog post is to showcase the power of SAP’s HANA database and there are less information available except on the SAP’s FSDP official website/Video.

Friday 25 March 2022

How to Set Up SAP HANA on Azure

SAP HANA deployment on Azure enables companies to evaluate and then run development, test, sandbox, and training environments for different SAP products. Deploying SAP HANA in the cloud enables customers to avoid the traditional path of procuring hardware and then installing SAP. Azure offers benefits like scalability, availability, and cost savings.

Hosting SAP HANA on Azure

SAP HANA is an in-memory Relational Database Management System (RDBMS). SAP HANA uses a solid-state Random Access Memory (RAM) to store data. This functionality improves database performance compared to traditional databases that use persistent storage.

You can run SAP HANA on-premises on your own dedicated hardware, or in a public or private cloud. Launching a SAP HANA certified Virtual Machine (VM) or a bare metal server enables you to run SAP workloads in Azure while optimizing costs

Wednesday 23 March 2022

S/4HANA Cloud Applications Monitoring with Cloud Integration


As my first blog on the SAP Community, I would like to tell you a little story. A few months ago I joined an AMS project and some of my daily tasks involved a twice-a-day monitoring on some SAP Cloud Integration iFlows and a few SAP S/4HANA applications like Message Monitoring, Manage Output Items, etc.

In the beginning I took my time in analyzing the payloads and error sources because there were many scenarios and I could not evaluate them as fast as I can now, but because I got better at doing my job I ran into the need of fetching all the messages with their details in a more efficient way.

Monday 21 March 2022

Why Do I Prefer Shell Conversion for BW4HANA Migration?


This Blogpost discusses the various migration strategies in fundamental Business and Technical sense.


In this blog post, the points that I brought are my own experience and thought process. It may vary from place to place. However, this blog post will give some thought processes to the reader before taking a call on the migration strategy.

Friday 18 March 2022

HDI: returning multiple deployment errors


Working with SAP HANA Cloud and HDI the tooling stopped at the first error and you had to fix them in the sequence the errors where thrown. All this one by one. This can lead to a lot of cycles that are time consuming and do not support the workflow one had in mind.


With SAP HANA Cloud March 2022 the HDI can now return the first error it can detect per each “dependency branch”.

Wednesday 16 March 2022

SAP HANA XS Advanced Administration, Deployment and Operations

Many SAP Customers started using XS Advanced and there were several questions on how to deploy or where to deploy and what are the consideration for choosing any of those approached. Based on my experience with various customers I tried to address some key topics in this blog to consolidate information from various sources of documentations

1. Deployment Options

There are various ways of deploying the XS Advanced runtime. Before deploying the XSA many scenarios need to considered that will have impact on your landscape maintenance activity. For example the system refresh scenarios where you will need to refresh only a certain tenants instead of complete system this deployment plays a key role. I will go through the limitations in detail in backup restore section. In general, The following additional services run where XSA is deployed:

Sunday 13 March 2022

The fastest way to load data from HANA Cloud, HANA into HANA Cloud, HANA Data Lake


Recently as customers are moving larger and larger tables from HANA into HANA Data Lake, I am being asked what the fastest way is to move data from HANA to HANA Data Lake.  Or more precisely I am asked if there is a faster way then doing a simple HANA INSERT into a HANA Data Lake virtual table.

You may be asking why customers are moving large tables from HANA to HANA Data Lake (HDL) and the most popular use case for this is an initial materialization of a large datasets or archiving older data to HDL.  Most of these customers are using HANA Smart Data Integration (SDI) to do this materialization and often using the same interface for change data capture using SDI Flowgraphs or SDI real-time replication to keep these tables up to date.

Monday 7 March 2022

Preserve and Identify Source Deleted Records in HANA via SLT


Need to preserve S/4HANA table hard-deleted records in Enterprise HANA.

Identify these records in Enterprise HANA by setting IS_DELETED = ‘Y’.

Challenge: SLT Replication by default will ensure that both source and target data records match all the time. This means that even deletion (of record) in the Source will be passed on to the Target system and cause a deletion in Target – to ensure data record count matches exactly between Source and Target tables.

Friday 4 March 2022

SAP Tech Bytes: SAP HANA / CAP Access Tables from a Different Schema


I read on social media about a New Year’s resolution idea: instead of answering questions sent in direct communication, write the response as a blog post and send the requester a link to the post. It sounds like a great idea to better utilize time and share knowledge so I decided to give it a try. Fourteen days into the new year and so far I’ve failed spectacularly. I find when I go to write a blog post I want to provide more background and detail. All this takes more time than you can usually squeeze into the day. This blog post represents my attempt to take at least one question I’ve received and answer via blog post, although admittedly after already responding to the original request.

Wednesday 2 March 2022

HANA NSE (Native Storage Extension) Data Tiering Options for Utilities

Purpose – An attempt to explain HANA NSE (Native Storage Extension) concepts in simple words for anyone looking to understand this topic. I have also tried to simplify steps used in implementing HANA NSE.

Topics covered –

– Reasons or case to implement HANA NSE.

– Basic concepts of HANA NSE.

– How to find tables/objects which can be candidates for implementing NSE?

– How to use DVM, DBA cockpit, and NSE advisor.

– Examples and links to the documentation provided by SAP.