Thursday 27 January 2022

SAP HANA Database Explorer VSCode Extension Getting Started Tips

You might have seen that SAP just recently released the first version of SAP HANA Database Explorer as a Visual Studio Code Extension.  You can get that extension here: SAP HANA Database Explorer – Visual Studio Marketplace

SAP HANA Database, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Certification, SAP HANA Skill, SAP HANA Job, SAP HANA Learn
SAP HANA DB Explorer in VSCode Marketplace

Wednesday 26 January 2022

7 methods to retrieve the version of SAP executables

During support situations you might often be asked to upgrade the executables of your system (often called kernel) to a current release.

But which version is running in your system?

Here are several methods to determine the version of an SAP executable:

1. Using SAPMMC

2. Using sapcontrol.exe

3. Using Windows Explorer

4. Using Windows Powershell

5. Using command line parameter -version

6. Using transaction SM51

7. Using System – Status

Monday 24 January 2022

Return to External Supplier Using Advance Return Management in S/4HANA


In this blog, the steps outlined for configuring and executing ‘Supplier Advance Return Management process in S/4HANA’. This will help users to configure advance return management and execute, monitor in S/4HANA Environment. The Business user can effectively monitor the complete return process cycle end to end and take corrective measures. The system can be configured as per the business requirement.


◉ Ensure return indicator enabled in the Supplier Master (in the purchasing view) with the indicator “Ret. with shipping proc.”

◉ Create Supplier as Customer for creating a return delivery and link Customer number in the supplier master

◉ Shipping determination Configuration

Friday 21 January 2022

You used to use SE16/SE16N and SQVI, Try SE16H!

SAP S/4HANA, SAP ERP, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Certification, SAP HANA Guides

As you know, SAP HANA comes with many enhancements and features. The new transaction SE16H comes with new features which enables rapid tables check and small queries.

SAP Consultants used to use the transactions code SE16/SE16N/SQVI to check table’s value and/or extract data.

Thursday 20 January 2022

Fleet Management – Detail SAP Configuration Steps along with Rationale

Fleet management is very popular in Industry’s where lot of vehicles are used, it is used to track the vehicle usage, fuel consumption etc.

I am trying to explain the detail steps used in Fleet management configuration along with some rationale, I hope the reader can follow these detail steps to understand and configure SAP Fleet Management.

Step 1

SAP Customizing->Plant Maintenance and Customer Service->Master Data in Plant Maintenance and Customer Service -Technical Objects-General Data-Set View Profiles for Technical Objects

Wednesday 19 January 2022

SAP BTP End-to-End Demo: Integration of Qualtrics


In this blog post I will demonstrate how to load Qualtrics Survey Data via a custom SAP Data Intelligence operator into a SAP HANA Cloud table for use in SAP Data Warehouse Cloud and SAP Analytics Cloud. I will show how solutions from unified data and analytics can be used together to get insights from a Qualtrics Survey by going step by step over how to integrate Qualtrics in them creating an End-To-End-Story.

This demo is split in the following parts:

Part 1: Creating a survey in Qualtrics that you can publish to gain valuable insights into customer opinions about a topic you are interested in

Part 2: Loading the survey data into a SAP HANA Cloud Table by creating and using a custom python operator in SAP Data Intelligence

Tuesday 18 January 2022

Error during execution of HdbCmdClazz ’GET_DEFAULT_DATA_BACKUP_LOCATION’ – SAP Control validating error resolution doc during HANA Refresh via SWPM tool


SAP Control validating error resolution doc during HANA Refresh via SWPM tool. This document is not necessarily having the strategy but also config information too some extent however content can be viewed and leveraged as appropriate. It gives an overview and resolution for sapcontrol validation issue using SWPM tool



To demonstrate this configuration, the below landscape is required

Monday 17 January 2022

Helpful Techniques For Adapting Projects to Operate in a Different Environment (e.g., Move from on Premise to SAP HANA Cloud)

One benefit of using the HANA Deployment Infrastructure (HDI) is that a clear interface exists that lists the dependencies to objects outside of the respective HDI container. With this it becomes pretty simple to adapt a project that should run in a different environment, such as when moving a project that has been developed in an on premise XSA environment with SAP Web IDE for SAP HANA to SAP HANA Cloud.

Below several concepts are illustrated that help to adapt existing projects that refer to objects that are not contained in the project.

The main challenge you will face when moving your project to a different environment is that you cannot rely on resources that are not included in your project. For example, resources might only exist under a different name or schema. The new development concepts of SAP HANA, in particular the deployment with the SAP HANA Deployment Infrastructure (HDI), prepares you for this task by abstracting away dependencies to resources outside of your project. Dependencies in HDI come into your project via mainly two routes:

Wednesday 12 January 2022

Capture Deleted Records-Using SLT

Context/Background: As we all know using SLT we replicate the records from source system, so as part of the replication, SLT basically perform three actions which are insert, update and delete. So lets consider we have a below scenario, where are replicating records from S4 system to HANA database. This seems to be normal and this is what SLT suppose to do.

But actual problems arrives when you have further downstream system which read data from your HANA database directly. Also, if there is non-sap system which is reading from HANA database, it is difficult to capture deleted records on target, so it goes out of sync if it is not a trigger based solution or stores the data to the flat files.

Monday 10 January 2022

Finding the right CDS Extractor in SAP S/4HANA

SAP ABAP Core Data Services (CDS) is a core technology for data modeling in SAP S/4HANA. Due to the fact, that S/4HANA cloud edition does not provide the classic ABAP extractors (aka DataSources) for consumption, the clear requirement to set up new extraction options based on this concept has emerged in the last years. As you can see in the numbers below, this area has received tremendous innovation recently.

Number of released CDS extractors in SAP S/4HANA on premise

(Note: the cloud edition reflects the similar evolution with probably even more objects)

– release 2019: ~400 extractors

– release 2020: ~1100 extractors

– release 2021: ~1800 extractors

Friday 7 January 2022

SAP HANA Monitoring with RybaFish Charts

Standard SAP HANA monitoring tools sometimes require initial configuration or specific setup and this might be a problem when you need quickly jump into the case and check what is happening on the SAP HANA DB side. And this is exactly where RybaFish Charts will help you.

All you need to start using it – just download the tool (no installation required, it is portable) and connect to the database. Within seconds you will be able to check the resource consumption on the database:

SAP HANA Monitoring, RybaFish Charts, SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs
SAP HANA Resource Consumption

Wednesday 5 January 2022

MDG-BP: Innovations in S/4 HANA 2021

In this blog we will cover some innovations on MDG-BP which has aligned the addresses function more with the S/4HANA business partner.


Business partner in S/4HANA allows to maintain address specific communication methods in the BP address tab as well as address independent communication methods which allows users to maintain different email ID’s phones numbers apart from the one standard one assigned to the business partner.

MDG till S/4HANA 2020 didn’t have the function to maintain the address independent data, however from S/4HANA 2021 it allows this data maintenance and its under governance scope.

Monday 3 January 2022

SAP HANA Platform: Fault Tolerance Features & High Availability

Ensuring a rapidly available SAP landscape involves the eliminations of all possible points of failure within the environment. A failure in system availability is very costly and hampers the productivity of the organization. Hence monitoring measures are set in place and alerts notifications are configured to be sent out to responsible operators for any possible threats caused by but not limited to:

◉ Power Failure

◉ Hardware Failure

◉ Network Latency

◉ Data Centers

The sole purpose of Implementing a High Availability SAP HANA system is to ensure a smooth and time effective  recovery strategy from any failures. A fully automated High availability system is a combination of the following: