Comparative Analysis of Data Selection Techniques in SAP

In SAP systems, selecting the right data extraction method plays a pivotal role in ensuring system efficiency and performance. With vast amounts of data stored in SAP databases, it's essential to choose the right method for data retrieval, especially to keep operations responsive and well-optimized.

In this article, we will explore various SAP data selection techniques such as the Open Cursor, Core Data Services (CDS) views, Database views, and some other advanced strategies. Each has its strengths and weaknesses and understanding them will help you determine the best fit for your specific use case.

HANA Calculation View - Division by Zero Error

A short post on the fix for the Division by Zero error due to expressions in HANA calculation views

In SQL, a division by zero error occurs when an expression attempts to divide a number by zero, leading to execution failures. In HANA, this can disrupt calculations within your views, especially when working with dynamic datasets where divisor values may be unpredictable.

The Calculated column is a feature in the calculation view that helps modelers insert information based on the other columns from the data sources.

How to Connect S4HANA Public Cloud With SAP Datasphere

Introduction:

After reading this article you will be able to establish a connection between SAP S4HANA Public Cloud with SAP Datasphere Public Cloud

Benefits:

You will be able to replicate data from S4HANA Public Cloud to SAP Datasphere Public Cloud

Importing Entities with Semantic of CDS views from S/4HANA On-Premise in SAP Datasphere

Introduction

This blog will explain the details of accessing the CDS views from S/4HANA On-Premise in SAP Datasphere with semantics. This feature helps accessing the data from ERP system with business context and logic intact through CDS views. 

Prerequisite

SAP S/4 HANA version should be 2021, or newer with SAP_BASIS Release 756 or newer. The below note has all the prerequisites in detail

What is SAP Approuter and its importance?

Introduction

SAP Approuter is a lightweight service, which acts as a single point of entry for various back-end services and applications in SAP ecosystem. In many SAP cloud foundry enterprise applications, Approuter plays an essential role in tying together different pieces of the application landscape and ensuring smooth user experience. In this blog, I am going to share my learning on Approuter and its usage.

What is SAP Approuter

SAP Approuter is a Node.js library used as a single point-of-entry to an enterprise application. The Approuter is used to serve static content, authenticate users, rewrite URLs, and forward or proxy requests to other micro services while propagating user information.

Embedded Analytics Architecture and Integration

SAP S/4HANA Embedded Analytics Architecture and Integration

 

SAP S/4 HANA Embedded Analytics architecture comprises of 4 layers, namely

1. Persistency layer
2. Modeling layer
3. Access layer
4. Visualization layer

In this blog I will be emphasizing more on persistency and modeling layer.

Configuring Standard API in S/4 HANA Cloud

Generating OData of standard API:

First we have to login to SAP business accelerator hub account and go to SAP S/4 HANA Cloud Public edition.

SAC Content Transport (Migration) Using CTMS

Different ways to transport SAC Content

SAC Provides three ways to transport your content from one tenant to another,

File System mode - In this method, using the menu option Transport > Export > File System, you create a package of your SAC content & its dependencies and download it to your local system in a .tgz file format, and import this .tgz file in your destination environment using the menu option Transport > Import > File System. This option is as simple as downloading from one location and uploading to another location.

Coupa Adapter for SAP Integration Suite

We are happy to announce that Cloud Integration introduced a Coupa adapter this month. For those customers using Coupa, the Coupa adapter for SAP Integration Suite is the ideal solution to enable a fast and robust adoption of Coupa in your business.

You can now seamlessly integrate data from diverse sources into the Coupa spend management platform and elevate your organization’s efficiency by reducing efforts to create a listed set of integration workflows with the Coupa adapter.

RISE with SAP: Multi-layer Defense in Depth Architecture of SAP S/4HANA Cloud, Private Edition

Introduction: The SAP S/4HANA Cloud, Private Edition is at the core of “RISE with SAP” offering which holds customer’s mission critical data and business processes. SAP Enterprise Cloud Services (ECS) provides a managed private environment with multi-layer defense in depth architecture handling infrastructure and technical managed services. This includes end-to-end SLA for the full solution stacks and a proven security architecture, minimizing risk for our customers. Multi-layer security requires security to be handled at people, process and technology levels. In this blog, we will discuss high level multi-layer "defense in depth" architecture offered to customers. For the sake of simplicity, only high level and abstracted approach is presented.

Approach to Multi-Layer Defense in Depth Architecture:

SAP S/4HANA Cloud, Private Edition is a “single tenanted” managed private environment for customers where SAP creates a separate account (AWS) or subscription (Azure) or project (GCP) for each customer. The applications and database virtual instances are solely dedicated to a single customer. Security by Design and Security by Default are deeply embedded into the multi-layer architecture.

What Is SAP HANA Streaming Analytics?

SAP HANA streaming analytics enables you to analyze high-volume, high-velocity data event streams to extract data. This post will introduce you to SAP HANA streaming analytics fundamentals.

Let’s get started with some basic information. Events are messages that are sent when something happens, for example, a stock price went up or a plane landed (too early, too late, or on time). Internet of Things (IoT) devices constantly send out messages, often in different formats, making processing these messages and generating alerts for exceptions difficult. Especially for the most interesting events (exceptions), the goal is to store this information in the database for further analysis to identify patterns, detect problems, and predict trends.

Testing SAP S/4HANA Cloud Implementations

To accelerate testing activities, SAP S/4HANA Cloud comes with a test automation tool, detailed test scripts, and prepackaged standard automated tests (called test automates) for most business processes.

The test automation tool and test automates are ready to run as part of SAP S/4HANA Cloud and can be used without prior automation tool experience. The tool offers a simplified way to develop custom test automates to achieve automated testing for specific customizations of business processes. Considering the delivery pace of SAP S/4HANA Cloud, SAP extends support for automated testing by triggering tests in SAP S/4HANA Cloud customer quality tenants with each upgrade using the tool called the post upgrade test. Furthermore, while the test automation tool is native to SAP S/4HANA Cloud, you can also use this tool with SAP Cloud ALM.

Calculation View Features of 2024 QRC2

Within the time frame of 2024 Q2, several new calculation view features have been released in SAP Business Application Studio when connected to SAP HANA Cloud database QRC2. Some of these features are highlighted below.

Duplicate Window Function Definition

To create multiple window functions that differ only in small details the functionality "Duplicate" can be applied to a window function:

SAP BW/4HANA Data Model for SAP S/4HANA Group Reporting

We in the CoE EMEA Team for Data Warehousing & Data Management have developed a Group Reporting data model for SAP BW/4HANA. This model is now out of the pilot phase and is already being used successfully by several customers.

In the following, we would like to give you a brief overview of the model's target audience, its structure and functionality, as well as information on how to get access to the model if you are interested. So stay tuned, it's worth reading :

Target Group for the SAP BW/4HANA Group Reporting Model

A data model for SAP BW/4HANA has been requested by several customers who have one or more of the following requirements:

SAP S/4HANA Cloud integration with SAP Integration Suite, Advanced Event Mesh

In this blog post you will learn the current best practice to directly connect with SAP Integration Suite, Advanced Event Mesh (AEM) for exchanging business events relevant to SAP S/4HANA Cloud release 2402. Hint: Screenshots in this blog post are taken from an SAP S/4HANA Cloud 2402 developer test system.

Please note that the use of SAP Integration Suite, Advanced Event Mesh (AEM) is not supported on the trial offering of SAP BTP. It is based on a productive (paid) account on SAP BTP.

For those who are already familiar with SAP S/4HANA Cloud’s Enterprise Event Enablement, integration with the SAP Advanced Event Mesh is now additionally available through the two new Communication Scenarios SAP_COM_0492 and SAP_COM_0493.

Exploring ML Explainability in SAP HANA PAL – Classification and Regression

1. Introduction

In this blog post, we will delve into the concept of Machine Learning (ML) Explainability in SAP HANA Predictive Analysis Library (PAL) and showcase how HANA PAL has seamlessly integrated this feature into various classification and regression algorithms, providing an effective tool for understanding predictive modeling. ML explainability are integral to achieving SAP's ethical AI goals, ensuring fairness, transparency, and trustworthiness in AI systems.

Upon completing this article, your key takeaways will be:

• An understanding of the concept of ML Explainability.
• How to utilize HANA PAL for ML Explainability in classification and regression tasks.
• Hands-on experience with Python Machine Learning Client for SAP HANA (hana-ml) through an example.

SAP Cloud Integration Manage Artifacts Of Design Time

Introduction:

In cloud integration, the processes of creating, deleting, or modifying a flow are done manually by entering the package. I will show how to perform these processes through the CPI link. The aim of this blog is to highlight the flexible structure of CPI.

Required:

◉ SAP BTP and Integration Suite 

Cloud Integration Steps:

To demonstrate how all the processes work, I have covered them all in a single flow. This includes flow deletion, updating, creation, and the information we can retrieve related to the flow.

Integrating SAP S/4HANA with Kafka via SAP Advanced Event Mesh: Part1 – Outbound connection

Introduction

In today's fast-paced business world, the ability to seamlessly communicate and exchange data between different systems is crucial. SAP Advanced Event Mesh (AEM) offers a robust solution for real-time event-driven communication across various SAP systems and external services. In this blog post, we'll explore how to integrate S/4HANA with Kafka using SAP AEM for data streaming and event-driven architecture.

Step-by-Step Guide

Let's break down the connection process between S/4 HANA and Kafka using SAP AEM into 6 sections, each explaining a key part of the connection setup to help you easily understand and implement the process.

New Features in SAP S/4 HANA Sales, PAC and Advanced BOP in S4 hana

New features introduced in S4 HANA SD Vs SAP ECC SD

◉ Customer Master, Vendor Master have been converted to BP (Business Partner) and the BP role will differentiate whether it’s a Vendor or customer or Contact person….Etc

◉ Status tables VBUK and VBUP have been eliminated and Status fields have been moved to the corresponding header and item tables: VBAK and VBAP for sales documents, LIKP and LIPS for deliveries, and VBRK for billing documents.

◉ Pricing table KONV eliminated and replaced with table PRCD_ELEMENTS

◉ User defined condition tables numbers almost doubled, before it was from 501 – 999 but now we can use letters as well 9AA – 9YY for example.

Remote Monitoring of HANA Database from Solman

As I find many SAP HANA databases wrongly configured in Solman for efficient, I felt there's a need to publish the steps I follow for the benefit of many.

#Note All the screenshots are taken by me from my internal system 

1. Install DBSL Libraries for remote monitoring of HANA DB

If Solman and the target database are on different databases, install HANA DBSL libraries on solman host for data collection.