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.

Grant System Privileges Like Export Or Import Into A (Hdi) Hana Deployment Container

In order to get the system privileges someone has to give them to your HDI container. This are the steps you have to follow to get them into the container. In this a sample the IMPORT/EXPORT privileges could be given.

1. [optional] A user with DBA-ADMIN role creates a usergroup  [HELP] such as "HDI_CONTAINER_RIGHTS"

Either use the HANA Cloud Central to create a USERGROUP

Implement side-by-side extensibility with SAP Build Apps and SAP Process Automation in BTP onPremise

SAP Build is SAP’s low-code solution, aimed at enabling business users to effortlessly construct business applications. It integrates SAP Build Apps, SAP Build Process Automation and SAP Build Work Zone into a cohesive development environment, introducing fresh innovations for swift app creation, process automation, and business site generation.

SAP BW Bridge – Integrating with On-Premises ECC / BW servers

To begin with, first we need to add on-Premises server to SAP Cloud connector.

Login to SAP Cloud connector as Administrator.

Go to the path: Sub-account -> Cloud To On-Premise

How to enhance the Focused Build Post-Cutover Activities

Introduction

The Focused Build standalone extension 'Cutover Checks and Post Cutover Activities' was introduced several years ago. Besides the Cutover Checks it also provides a set of activities to ensure seamless synchronization of changes between implementation and corresponding maintenance landscapes. Users can create and import Transports of Copies (ToCs) for each system within the maintenance landscape directly from the cutover system.

ST-OST SP13 has brought improvements to these activities. Nonetheless, it can still happen that an activity does not meet your requirements fully or lacks a particular feature. In such situations, users can easily develop and integrate their own activities to enhance or replace the existing ones.

Understanding SAP HANA Systems: Revolutionizing Data Management

In today's fast-paced digital landscape, businesses require robust data management systems to handle the vast amounts of data generated every second. SAP HANA, a high-performance in-memory database developed by SAP SE, has emerged as a game-changer in this domain. This article delves into the core aspects of SAP HANA systems, highlighting their features, benefits, and the impact they have on modern enterprises.

What is SAP HANA?

SAP HANA (High-Performance Analytic Appliance) is an in-memory, column-oriented, relational database management system designed to handle both high transaction rates and complex query processing. Unlike traditional databases that rely on disk storage, SAP HANA stores data in RAM, allowing for incredibly fast data retrieval and processing. This architecture significantly accelerates analytics and transactional processing, making real-time data access a reality.

Extracting Data from S4HANA ODP to SAP Datasphere

An ODP (Operational Data Provisioning)-enabled data source is a data extraction mechanism that uses the ODP framework to allow the transfer of data between systems. It leverages the ODP infrastructure to manage the data extraction process efficiently, ensuring that data is consistently and reliably transferred from the source system to the target system.

To consume S4HANA data to SAP Datasphere via ODP, we need a datasource that is ODP enabled, either we can use some standard datasources like (e.g. 2LIS_11_VAHDR - Sales Document Header Data, 2LIS_11_VAITM - Sales Document Item Data) or we can also create a custom datasource either by using a view or table or some custom CDS view.

Integration Between SAP Datasphere and SAP Analytics Cloud

Introduction

This blog series discusses the integration between SAP Datasphere with SAP Analytics Cloud for data harmony. I aim to provide an overview of SAC, discuss the process of establishing both live and OData connections between SAC and Datasphere, explore Optimized Design Experience, delve into the current planning capabilities bridging these two products, and more.

 

In this introductory blog, I want to provide an overview of the following key aspects for integrating data between SAP Datasphere and SAP Analytics Cloud:

Unleashing the Power of Custom Widgets in SAP Analytics Cloud

In today's world where data is crucial, it's really important to have analytics solutions that fit our business needs perfectly. With SAP Analytics Cloud (SAC), we can create custom analytical applications that are just right for our needs. One cool thing we can do with SAC is develop custom widgets. These widgets help us add more functions to SAC beyond what it already offers. In this blog post, I'm excited to talk about my experience making a custom SAC widget using a JSON file.

Prerequisites:

1. Proficiency in JavaScript and JSON: Custom widgets in SAC are developed using JavaScript and defined using JSON files. Ensure that you have a good understanding of these languages and their syntax.

Syniti RDG provides a simplified design to create Multi Value Validation and Derivation Rules

Syniti RDG is an SAP-endorsed application on the Business Technology Platform (SAP BTP) to facilitate MDG implementation with intuitive UI and process automation. RDG automates many of the technical configuration steps that are required to implement SAP MDG and it offers a user-friendly interface to be more relatable to business users.

◉ A multi-value check rule is for validating multiple attribute values against a logical condition.

◉ A multi value derivation rule is to derive multiple attributes values based on a logical condition.

The below example is used to create Multi value validation to be triggered for a specific Change Request Type to validate attribute values of Entity ‘BP_CENTRL’ of data model ‘BP’.

SAP HANA Database Creation from SAP BTP

Creation of SAP HANA Database Instance in SAP BTP

1. Open SAP BTP Cockpit and click on subaccount.

SAP DataSphere – SAP HANA Database Monitoring

Login to SAP DataSphere and navigate to path System -> Configuration. Select the Menu option 'Database Access' -> Database Analysis Users.

Select the option Create for new DB user.

Import Data Connection to SAP S/4HANA in SAP Analytics Cloud: Technical Configuration

In this blog we’ll discuss complete steps for Import data connection from S/4 hana on-premise system to SAP Analytics Cloud. The Operating system we are using on which S/4 Hana system is installed is SUSE Linux SP 15.

Here, Our Data source is S/4 Hana from which the SAP Analytics Cloud is connected using the SAP Analytics Cloud Agent and SAP Cloud Connector.

Currency Translation in SAP Datasphere

Currency translation refers to the process of converting financial data from one currency to another.

This is particularly important for multinational companies that operate in multiple countries and use different currencies for their financial transactions.

Currency translation in SAP typically involves the following steps:

1. Setting up currency exchange rates: Before performing any currency translation, exchange rates need to be maintained in SAP. These rates can be manually entered or automatically updated from external sources.

SAP Datasphere's updated Pricing & Packaging: Lower Costs & More Flexibility

The power of SAP Datasphere is growing every day. Bringing together data warehousing, data integration, data catalog, and semantic modeling it perfectly fits the definition of a modern business data fabric.

Cost optimized SAP HANA DR options on Google Cloud

Abstract

Business Continuity is of utmost importance for any organization. A well defined High Availability (HA) & Disaster Recovery (DR) strategy ensures business critical SAP Applications accessibility during any planned or unplanned outage. SAP HANA database being a central component of a SAP Application is configured with relevant HA/DR setup to make the business data available at secondary node/site to ensure business continuity.

HA for HANA database is being used as fault tolerance mostly for any infra related failures where HANA database fails over to secondary hot standby node deployed in cluster mode within a single region. RPO and RTO are almost zero in this case as most of the steps are seamless and automated with cluster management. Synchronous HANA replication across zones of the same region ensures the secondary HANA node is in sync with the primary node all the time.

SAP HANA Cloud's Vector Engine vs. HANA on-premise

Introduction

Several days ago SAP released "SAP HANA Cloud's Vector Engine" which is essentially a database that stores finite dimensional vectors that represent real worlds objects. Furthermore these kind of databases have built-in functions in order to calculate certain relations between the stored vectors. The vectors are the result of a so called embedding, which means that each real worlds object is "embedded" into a finite dimensional vector space in a certain way. The embedding itself depends on the purpose of the usage of the vectors and is not uniquely determined. For example all orthogonal transformations preserve the inner structure of the embedding. (Note that this is not an embedding in the mathematical sense, which is a one to one differentiable mapping between vector spaces that is locally invertable).

Developing & Deploying the UI5 App to Cloud Foundry and Accessing from App-router End-to-End Steps

In this Blog I am going to explain the minimal steps required to setup App router, HTML5 Deployer for the UI5 application to be able to develop and deploy the application to Cloud Foundry Space. We are going to setup destination and consume the same in the UI5 application using App Router.Before Getting started Let's understand the architecture to access the application from Cloud Foundry Space -

Empowering Retail Business with a Seamless Data Migration to SAP S/4HANA

I’m happy to find time to start SAP blogging. In the dynamic realm of retail, transitioning to SAP S/4HANA is a pivotal move towards enhancing operational efficiency and competitiveness. Central to this transition is the intricate process of data migration, particularly concerning master data. With its criticality underscored, ensuring the accuracy and governance of SAP master data becomes paramount. This brief explores the fundamental importance of data management in retail's seamless migration to SAP S/4HANA, highlighting key strategies for success.

Implementing SAP ERP hinges greatly on managing data, especially master data, as SAP ERP relies heavily on it. Data migration remains the most critical aspect of this process, carrying the highest risk. If your SAP master data lacks accuracy and governance, you may encounter significant challenges.

Consuming CAPM Application's OData service into SAP Fiori Application in Business Application Studio

OBJECTIVE

Consuming OData Service of CAPM Application into SAP Fiori Application in Business Application Studio.

CAPM (Cloud Application Programming Model)

It is an open-source framework that uses tools, libraries, and languages to create applications that can be used across multiple SAP products. CAPM is a multi-target application that runs at different times, with the persistence layer running in the HANA DB run time, the server layer running in the Node.js run time, and the UI/UX layer running in the browser run time.

CAPM is one of the approaches to developing cloud applications using the BTP platform. CAPM offers a more structured and seamless framework for data modelling and enhancing integration with services.

Nested JSON to SAP HANA Tables with SAP Integration Suite

In this blog post, I will demonstrate how to send data to SAP HANA Cloud using the Integration Suite. Additionally, I will explain how to handle nested JSON data and distribute it across multiple tables utilizing parallel multicast and mapping functions.

Problem Statement:

We have exposed an API endpoint through which we push data in JSON format and in response we get the insert count in particular tables. The input data contains user details and role details in nested form. We are supposed to insert the user details in User Table whereas in the User-Role mapping table for each role associated with a user, we ensure the creation of a corresponding entry, linking the user's details with their roles. Our requirement is to process the JSON data via CPI and populate these two tables.

Workload in the SAP HANA

Options for Managing Workload

Workload management can be configured at multiple levels: at the operating system-level, by using global initialization settings, and at the session level.

There are a number of things you can do to influence how workload is handled:

• Outside the SAP HANA system on the operating system level you can set the affinity of the available cores.
• You can apply static settings using parameters to configure execution, memory management and peak load situations.
• You can influence workload dynamically at system runtime by defining workload classes.

All of these options have default settings which are applied during the HANA installation. These general-purpose settings may provide you with perfectly acceptable performance in which case the workload management features described here may not be necessary. 

Replication flows: SAP Datasphere to Google BigQuery

In this blog, we will explore one of the latest innovations from SAP Datasphere. Effectively, from version 2021.03 onwards, SAP Datasphere has introduced the concept of ‘Replication Flows’.  

Think of replication flows as your trusty sidekick in the world of data management. This feature is all about efficiency and ease. It lets you effortlessly copy multiple tables from a source to a target, without breaking a sweat. 

The beauty in this story is that it is cloud-based all the way! Say goodbye to the hassle of dealing with on-premises components like installing and maintaining data provisioning agents. Thanks to SAP Datasphere's cloud-based replication tool, those headaches are a thing of the past. Replication flows support the following source and target systems: 

Integrate C4P-Resource Management with SAP Analytics Cloud or SAP DataSphere

Summary

Embarking on the journey of leveraging SAP S/4HANA Cloud for Projects, Resource Management (C4P), this blog simplifies the process of accessing its APIs, with a focus on the Resource Request functionality. Beginning with preparations, where we gather key information like API URL and credentials, we then explore the capabilities of the Resource Request API in the Business Accelerator Hub. We break down how to find the right URL for accessing resource requests and demonstrate how to connect these APIs to tools like SAP Analytics Cloud or SAP DataSphere. By following these steps, users can seamlessly integrate data from C4P into their analytics workflow, enabling better decision-making and operational efficiency.

Job and Automation Monitoring features - SAP Cloud ALM

SAP Cloud ALM is an out-of-box, native cloud solution which serves as the central hub for managing SAP landscapes, offering guided implementation driven by content and highly automated operations. In this blog post, I aim to delve into a very crucial capability of cloud ALM: Job and Automation Monitoring.

Through Job and Automation monitoring within SAP Cloud ALM, it is possible to monitor SAP S/4 HANA Application jobs, SAP ABAP jobs, SAP BW Process Chains, SAP Build Process Automation Jobs(or SAP Intelligent RPA jobs) and SAP Business workflow and Job scheduler service jobs in customer BTP application.

SAP S/4 HANA Event Management (EM) Deployment Options – stand-alone vs S/4 HANA add-on

Summary

In this decision accelerator, you will know how to decide between S/4 HANA Event Management (EM) to be deployed as stand-alone or as an add-on on SAP S/4HANA in on-premise or private cloud.

Business Requirements

SAP Event Management on SAP S/4HANA is a business application to enable real-time end-to-end business process visibility and status monitoring. It provides a wide range of functions to monitor milestones (called “expected events”), report actual events correlating to the related expected event, and unexpected events. Alerts, notifications, and any kind of automated follow-up activities are triggered by rules evaluating the events upon receiving to automate the detection of deviation and automated reaction to events.

Sharing SAP HANA Cloud instance to multiple subaccounts and creating HDI containers

Overview

This article is telling you how to share single SAP HANA Cloud instance to multiple subaccounts and create HDI container from each subaccount. I am using SAP Cloud Application Programming Model (CAP) Node.js for this article.

Background

When I am planning SAP BTP project system architecture, I am following account model and preparing three subaccounts (development, test, production). At that time, I feel how can I reduce cost of subscription to each subaccount, especially for development environment.

Efficient Memory Storage and Data Loading of SAP HANA Column Tables

Memory storage and Computing Power are fundamental blocks of Cloud Platforms and Infrastructure. The abundance of Memory storage and cost-effective computing power has ensured a lower baseline for cloud adoption. However, anything in excess without considering its consequences can corrupt our practices. I see a similar pattern with the cloud data models.

In SAP HANA, we replicate data predominantly from SAP systems through tables and CDS. Data replicated for tables may range from 1000s or rows to millions of records per month. The queries that join multiple tables without optimal selection of columns and filter conditions can consume the working memory resources. Eventually, despite the promise of infinite data and computing capacity(CC), the reality is there is a finite amount of memory and CC.

Connect & Visualize: SAP Datasphere with Qlik Sense

In this Blog, We'll explore how to consume data from SAP Datasphere through ODBC (Open Database Connectivity) and Visualize the data in Qlik Sense which is one of the leading Data Visualization Tools.

Why SAP Datasphere over others?

SAP Datasphere allows seamless connectivity with a wide range of data sources, including on-premises and cloud-based systems. SAP Datasphere is designed to handle large volumes of data efficiently, making it suitable for organizations of all sizes, from small businesses to large enterprises. Its scalable architecture ensures optimal performance even as data volumes grow over time. Graphical low-code/no-code tools to support self-service modeling needs for business users. It has Powerful built-in SQL and data flow editors for sophisticated modeling and data transformation needs.

An overview of XSA commands for beginners

Overview:

In this article I'll try to explain the expected outcome of XSA commands when executed in Linux environment via command line (xs cli). This blog is aimed at helping understand the xs commands. At first, I also faced the similar dilemma of how XS command works and what is expected outcome. So learning by my experience, sharing most commonly used commands which you can easily use to understand and monitor xs too.

Pre-requisite:

1. OS level access via <sid>adm on HANA DB host

2. User credentials of xsa_admin

Updating an SAP HANA System Landscape - Overview

Updating an SAP HANA System Landscape - Overview

Revision Update

1. Support Packages (SPS) Update

2. Version Upgrade – SAP HANA 1.0 to SAP HANA 2.0

SAP HANA system components like,

• SAP HANA Database
• SAP HANA client
• SAP HANA studio

Additional system components like,

Effectively adopting Recurring Service process from S/4 HANA Service Management into your business

Regular maintenance aids in maintaining a customer's assets at their best performance levels while reducing the likelihood of breakdowns and the costs associated with repairs.

Our preventive maintenance solution, designed to sustain customer assets, facilitates consistent production by mitigating unexpected breakdowns. This solution creates and executes orders at specified intervals/usage, drastically improving asset production efficiency and minimizing breakdowns. Notably, this solution also reduces maintenance costs and contributes to recurring service revenues for customers. It adeptly manages both commercial aspects through service orders, as per the service contract, and technical aspects through execution orders.

There are different types of Maintenance Plans, namely: Single cycle plans based on time or performance, strategy plans, or multiple counter maintenance plans that are implemented on need basis . Once you create a maintenance plan, you can schedule the plan to generate call objects when the system is due for maintenance.

How to attach documents to a Journal Entry within SAP S/4HANA Public Cloud from ABAP

Introduction

In this blog, we describe a method to attach document files to a Journal Entry (BKPF) instance within the same SAP S/4HANA Public Cloud  using ABAP.

This requires us to expose and consume the Attachment API as described in the SAP Business Accelerator HUB - Attachments.

 

I believe this blog can be very useful since existing documentation primarily focuses on exposing the services, but we encounter conceptual problems when consuming them locally.

SAP IQ NLS-The Cold Storage Solution for SAP BW/4HANA

Introduction –

As we know B systems contain a large volume of data that is only accessed rarely. The data is either never or rarely needed in Data Warehouse processes or for analysis. The main challenge of implementing a multi-temperature memory strategy is to seamlessly integrate the warm and cold memory areas and to make these areas invisible to the outside, in order to ensure that all required functions are applied to this data. SAP offers various solutions, which help to reduce TCO SAP IQ NLS is one of them to reduce load by cold data 

Protecting Your SAP HANA Cloud and SAP HANA with Credential Rotation Best Practices

In today's cyber-threat landscape, prioritizing data security is more important than ever. Security is one of the key cornerstones of SAP BTP and SAP HANA Cloud strategies. 

SAP HANA Cloud takes a comprehensive approach to security, providing a layered defense system encompassing authentication, authorization, encryption, and auditing. 

At the heart of this security strategy lies strong credentials management practices, one of which is the credentials rotation. For example, organizations can significantly reduce the risk of unauthorized access and data breaches by enforcing regular password rotation.

Global Explanation Capabilities in SAP HANA Machine Learning

Machine learning (ML) has great potential for improving products and services across various industries. However, the explainability of ML models is crucial for their widespread adoption. First, explanation helps build trust and transparency between the users and the models. When users understand how ML model works, they are more likely to trust its results. Moreover, explainability allows for better debugging of complex models. By providing explanations for models’ decisions, researchers can gain insights into the underlying patterns, which helps identify potential biases or flaws. Furthermore, the explainability of models enables auditing, a prerequisite for its usage in regulated industries, such as finance and healthcare.

Create sales order automatic extraction -Maximize the value of SAP Business AI for SAP S/4HANA

SAP has released several prebuilt AI use cases in each of the process area. These are referred to as Basic AI providing out-of-the-box solutions. The base for this is of course SAP S/4HANA.

The graphic above provides a rough summary of what is available.

Clone SAP HANA Database Instance via Template based cloning

The cloning template essentially serves as a database backup, encompassing the schema and data of the clone while excluding its configuration details, such as the options chosen during provisioning. It's important to note that restoring a backup from a more recent SAP HANA version into an older version is not supported and results in an error.

Cloning templates are stored in a template container within HANA Data Lake Files, specifically in the Files service of the data lake. To create a cloning template, and to create an instance based on a template, your subaccount must therefore have a data lake Files service; note, however, only data lake Files is required — without the additional option of the data lake relational engine.

Cloud Integration - How to Manage Abnormally Large Files with SFTP Adapter and SAP HANA Database

This blog provides a comprehensive guide for users seeking a solution for processing large files from an SFTP source and transferring the data to a HANA Database. The solution outlined in this guide employs SAP Integration Suite. There have always been challenges associated with processing large files, which may include issues related to performance, memory usage, and overall efficiency. All of which are solved by the solution shared in this guide.

Background Information

During a recent migration project - we were challenged with designing a solution that eliminated a previously designed integration using Informatica Platform. Replacing it with SAP BTP Cloud Integration Suite, during the migration project a crucial task emerged: retrieving large files from an external SFTP and seamlessly loading the data into a HANA Database On-Premise table.

SAP Datasphere Replication Flow from S/4HANA to Azure Data Lake

Introduction

SAP Datasphere has introduced a new feature, 'Replication Flows.' This new capability (now available with Azure Data Lake) allows for the process of copying multiple tables from one source to another, offering a fast and seamless experience in data management. 

In this blog, we’ll provide a step-by-step tutorial on replicating data from SAP S/4HANA to Azure Data Lake, showcasing the practical application and efficiency of this new feature in real-world scenarios. 

Now, let's dive in. We'll walk you through each step necessary to effectively utilize 'Replication Flows' for transferring data from SAP S/4HANA to Azure Data Lake. 

SAP Datasphere – Enable SAP HANA Development Infrastructure (HDI)

Introduction

Use SAP SQL Data Warehousing to build calculation views and other SAP HANA Cloud HDI objects directly in SAP Datasphere run-time database and then exchange data between HDI containers and SAP Datasphere spaces. SAP SQL Data Warehousing can be used to bring existing HDI objects into  SAP Datasphere environment, and to allow users familiar with the HDI tools to leverage advanced SAP HANA Cloud features.

S/4HANA federated roles assignment to users in BTP via SAP Identity Provisioning Service

In this article I will explain how these federated roles from S/4HANA assigned automatically to users in BTP via SAP Identity provision service without any manual intervention.

To achieve this scenario, we should have below prerequisite: -

1. SAP BTP cockpit, where we subscribe to the Cloud Identity Services connectivity plan in the subaccount.In SAP BTP Cockpit, open the subaccount and choose Service Marketplace Integration Suite- Cloud Identity Services and then choose for what type of tenant (test or productive) to use in the subaccount.
2. The Identity Provisioning section of SAP Cloud Identity Services administration console, where we configure the S/4Hana system and SAP IAS as provisioning system.
3. Content Federation has been setup and S/4HANA role content are federated and visible as role collection in BTP.

Integrating SAP Cloud ALM and the test automation tool for SAP S/4 HANA Cloud

In this blog post I will explain how SAP Cloud ALM integrates with the test automation tool for SAP S/4 HANA Cloud.

SAP Cloud ALM provides (among other capabilities) test management, including manual testing as well as test automation integration.

This simple picture gives an overview of the SAP Cloud ALM Test Orchestration capabilities:

BTP Destinations and SAP Build Apps to integrate SAP C4C & S/4HANA

Introduction: In today's digital world, businesses are looking for ways to streamline their processes and enhance their customer experience. One way to achieve this is through the integration of different systems. In this blog post, we will explore how to integrate SAP C4C and S/4 HANA using BTP destinations and SAP Build apps.

To integrate SAP C4C and S/4 HANA, we can use BTP (Business Technology Platform) destinations and SAP Build Apps.

Optimizing HANA Cloud: A Practical Exploration of Replication, Latency, and Availability Zones

Introduction

In general crafting my blog posts, I usually avoid lengthy theoretical discussions. I find more value in exploring real-world scenarios, practical applications, and best practices. However, for this particular post, I'll make an exception. I'd like to start by briefly delving into some theoretical concepts you may already be acquainted with

—Replica, Latency, and Availability Zones in Cloud Databases. Allow me to provide a concise overview, accompanied by practical insights and optimization strategies. Together, we'll lay the groundwork for a resilient and high-performing system in HANA Cloud

Azure APIM TO S4HANA CONNECTIVITY VIA CI (Principal Propagation)

Requirement:

Establish trusted relationship/connectivity between source systems at client side to Azure APIM and from Azure APIM to S4HANA system via CI and cloud connector using short lived certificate i.e., principal propagation.

More Info: C_HANATEC_19 Key Points

Overview

Principal propagation means the ability to forward the user context of a message unchanged from the sender to the receiver. It enables authentication of a message in the receiver system with the same user that issued the message in the corresponding sender system. Thus, the receiver application is virtually part of the sender application, and the permissions and audit functions of the receiver application can be applied to the original user of the sender application.

Modeling an advanced Hierarchy with Directory in SAP Datasphere

In our previous blog, we covered the basics of creating a Hierarchy with Directory. Now, we're taking a step further in this blog by enhancing our model with an extra node type, language-dependent texts, and time-dependency, both for the hierarchies and node assignments. These advanced features are often seen in SAP S/4HANA or SAP BW hierarchies but are also applicable to non-SAP hierarchies. We continue to use a simplified data model with local data for clarity, making it easier to grasp these concepts before applying them to more complex, real-world data sources. The additions to the data model are pointed out in Figure 1, with the numbering corresponding to the section numbers in this blog post. The figure shows all views, and each view has a table with data underneath.

Modeling a basic Hierarchy with Directory in SAP Datasphere

In the previous blog, we provided an overview of the new features introduced with the Hierarchy with Directory. In this blog, we'll guide you through creating a basic Hierarchy with Directory, starting from scratch and progressing to the data preview in an Analytic Model. Our focus is on simplicity, ensuring you grasp the fundamental concepts with minimal complexity. To keep it simple, we use data from local tables, before moving on to data from SAP S/4HANA or SAP BW in future posts. However, the model is complete and comes with a few lines of transaction and master data. In our upcoming blog, we'll enhance the model by introducing advanced elements such as language-dependent texts, additional node types, and time-dependency features.

Field inventory management (FIM) in the Medical Device Industry – Create capitalized assets and fulfill demo requests orders from sales representatives

Introduction:

This blog outlines the leading medical device industry business process steps to fulfill a customer request for demo of a capitalized equipment.

A customer may request a particular product from your company to be demonstrated and evaluated before making a purchase decision. If the product is of high value, the company may treat the product as an asset when it is used for demo purposes. The below document will explain tracking, logistics support, and accountability of these products when they go out to the field from the company’s premises.

Converting Simple Date format to JSON date format with User Defined Functions (UDF)

As an SAP Integration Developer working with SAP S/4 HANA API’s with JSON Schema format, I encountered the necessity to adeptly convert simple date formats received from both SAP and non-SAP systems to JSON date format prior posting the payload to SAP S/4 HANA for required operations.

In this case, if payload posted to S/4 HANA consists of simple date format (DD/MM/YYYY), it reverts with date-related errors that arise due to unrecognized formats by the system.

To address this issue, I couldn’t find an existing guide, prompting me to share my approach with fellow Integration Consultants.

SAP S/4HANA Business Partner – Address Management at Contact Persons

Introduction

With introduction of Business Partner at SAP S/4HANA and CVI (Customer-Vendor-Integration) an additional object level in addition to old/known Customer and Contact Person concept has been implemented.

Customer Master and Contact Person is using BAS (Business Address Service) for many years by using central address tables. Business Partner is using BAS as well with own address data sets. This makes whole address management complex.

An Introduction to Hierarchy with Directory in SAP Datasphere

SAP Datasphere has rolled out a much-anticipated feature set with the Hierarchy with Directory. This feature set extends beyond directory capabilities, which we will explore in detail, to a host of other functionalities engineered to integrate smoothly with SAP S/4HANA and SAP BW hierarchies. The outcome is a more efficient experience in modeling these hierarchies within SAP Datasphere, with a richer end-user experience.

This blog post kicks off a series dedicated to unpacking the Hierarchy with Directory bit by bit. We begin with an overview of the new features. Following that, we’ll detail the functionality across two posts, starting with constructing a simple data model to represent a product, and then expanding the hierarchy with additional capabilities. This approach ensures you gain a thorough grasp of the hierarchy features, setting the stage for in-depth guides on integrating specific S/4HANA hierarchies such as GL Account, Cost Center, and Profit Center. A screenshot of the end-result of a GL Account Hierarchy is illustrated in Figure 1.

Field Inventory Management (FIM) – Fulfillment of medical devices/instruments for a Surgery event in a hospital using S4 HANA

Introduction:

This blog outlines the leading industry business process steps to deliver critical medical instruments and consumables for surgery at the hospital promptly providing tracking and visibility to all stakeholders.

When the Sales Rep is notified of surgery, a list of assets like medical Instrumentation Loaner Kits and implants/disposables needed for a particular surgery event is determined. This material then must be tracked, and delivered to the hospital or location where the surgery event takes place. After the Surgery event, the Instrumentation loaner kit is returned to the plant where the inspection is carried out. The consumed items are billed to the Customer through the invoicing process.

Set up for Auto clearing through FEBAN for Acquirer related postings aligning with Blackline

For AMEX acquirer the requirement is to update the assignment field of the accounting document with the unique payment id (Merch ID) that will be sent through in the note to payee of the EBS while processing the FEBAN. This will update the SB document type assignment field with the unique payment id.

Blackline is also expected to update the SA document type assignment field for matching transaction. This will help in auto clearing of such open items.

Following are examples of note to payee wherein the highlighted information is the “Unique” payment id received from the acquirer

HANA Prod tables access in Dev for CV nodes data preview

SAP HANA XS Advanced application developments are done using Web IDE for HANA and it is installed in Dev instance and not in QA/prod instance. It is because we don’t want any changes directly deployed in Prod. In that case, we can’t troubleshoot the CV nodes data preview in Prod.

So we can configure the process below to access Dev and Prod tables interchangeably when required.

Azure Monitor for SAP solutions One-stop-shop for SAP technical monitoring

Are you an SAP Customer/Partner/ISV seeking a seamless monitoring solution? In this blog, I introduce Microsoft’s latest Monitoring solution—Azure Monitor for SAP Solutions—a user-friendly and plug-and-play tool.

1. What is Azure Monitor for SAP Solutions?
2. What is the architecture?
3. What can you monitor?
4. What are the other key capabilities of AMS?
5. What are pricing and regions available?

S/4Hana 2023 – Key User Extensibility – Custom Logic App – Keep the Core Clean

With S/4hana 2023 SAP introduce another fiori application which can help key users to implement BADI’s that have been released by SAP. We can start implementing from the Custom Logic app or from the UI adaptation in an application that can be extended.

BADI’s Extension can be created by using the application and we will also have the flexibilities to view the latest documents, Develop extension where we can also refer sample code, Test the code and compare the code as well. This app can play a major role to keep the core clean.