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.

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.

“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.

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.

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 –

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.

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:

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

Introduction

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.

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. 

SAP Hana Dynamic Tiering Installation and Configuration

Overview 

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.  

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.

SAP Data Migration Cockpit – Nutshell

Purpose

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.

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

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

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.

New Robotic Process Automation for Performance and 360 Review forms

Requirement

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).

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):

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 –

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.

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.

Architecture:

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 Cloud Document Store – Enabling JSON Document Store

Introduction

SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial

SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines

ArcGIS on the HANA Platform – putting the pieces together

This series, we looked at how the HANA platform’s capabilities reduce technical debt and complexity by eliminating the need for ETL when integrating your SAP S/4HANA and ArcGIS Enterprise systems.

SAP HANA Cloud Document Store – HANA DocStore First Steps

Introduction

In this blog post, we’re going to walk through some of the technical details around how we interact with the SAP HANA DocStore

JSON Collections

While the Column and Row Stores use Tables to store data, the Document Store uses a JSON Collection