Detecting Implausible User-Entered Weighing Notes using Data Science with an SAP S/4HANA (On-Premise) System

After connecting an SAP S/4HANA System with Python and Jupyter Notebook using an ODBC driver we can now work with the data we retrieved.

In the world of data science, detecting anomalies and errors is an essential task. In this blog, we will explore a data science project (from my practical phase in my dual curriculum) focusing on detecting implausible, manually-entered weighing notes where for example the weighing unit was mixed up.  These anomalies can have significant consequences in inventory, billing, or logistics.

Migration Monitor (FINS_MIG_STATUS) – How to analyze errors and information and recommend possible solutions.

As Part of the conversion process to S/4HANA, the migration monitor (FINS_MIG_STATUS) is responsible for coordinating the migration of Finance data into the new S/4HANA data model. To access details about a data migration run, click the Overview tab and see the list of activities and their respective statuses.

Incomplete steps or those with errors are displayed with a red status. The data migration process stops, preventing any subsequent tasks from being executed by the system. To continue with the migration, it is critical to fix the errors found in these tasks. The omission of this activity will delay the migration process.

XSA: HDI Container, Persistence and CAP

Introduction

We will be addressing persistent data storage in the modern HANA platform. How are tables created in XSA? What role do HANA Deployment Infrastructure (HDI) containers play in this respect? What are the advantages of SAP’s Cloud Application Programming Model (CAP)? We will answer these exciting and essential questions with the help of an example project which we have created in the Business Application Studio (BAS).

HDI Containers

Based on our first blog, we know that the introduction of XSA resulted in a fundamental paradigm shift in creating native HANA models. The approach of a central (database-focused) system is giving way to a cloud-focused system with separate applications and dedicated services. But how are applications separated, exactly?

Basic Principles of SAP HANA XSA

What is SAP HANA XSA?

First, one important piece of information: XSC i.e., the native developments of SAP HANA artefacts in the HANA Studio, is obsolete. It is no longer being developed and new features will not be added. The future is XSA and that is where SAP’s entire focus will be regarding HANA.

SAP HANA XSA is a paradigm shift in developing with SAP HANA. This statement may at first seem extreme, because at first glance, compared to XSC, the application has just gotten new components such as NodeJS or HTML5.

Service Now connectivity using SOAP query through HANA SDA

Overview

In this article, the method of connecting Service Now with HANA SDA connection is explained along with the set up for the delta connection is described. The scenario described here will explain the connectivity with Service Now and the data extraction techniques.

Connectivity with Service Now

Connectivity with Service Now from HANA is possible through SOAP adapter. Once the adapter is set up, a connection needs to be created in HANA IDE. This is possible through the SDA option. Please note that the data is always accessed virtually and there is no need of replicating the data for the connection.

App Extensibility for Create Sales Orders – Automatic Extraction: Custom Proposal for Sales Order Request Fields (Using BAdI)

In the Create Sales Orders – Automatic Extraction app, the system starts data extraction and data proposal for sales order requests immediately after your purchase order files are uploaded. If SAP pre-delivered proposal rules do not satisfy your business needs, key users can create custom logic to implement your own proposal rules.

Here is an example procedure. In your custom logic, you want the system to set the sales area to 0001/01/01 if the company code is 0001, and set the request delivery date to the current date plus seven days if this date is initial. In case ML can not extract the date from file or date is not exist in the file.

SAP BW4HANA DS connation (MS SQL DB) Source system via SDA

Introduction:

As you are all aware now, you cannot connect DS directly to the SAP BW4HANA system, Hance needs to connect DS DB with the HANA database via SDA and create a source system.

Based on customer requirements set up HANA DB connection with MS SQL DB and set up source system.

DISCLAIMER

The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental, or consequential damages resulting from or related to the use of this document.

How to Find Which Structure is Included in Which Structure?

Introduction

In Every Projects you go there will be requirement to enhance the Standard Screen to add some new Custom Fields. The general approach you do use Append Structure and add your Custom Fields. Sometime while analysing it may happen that you have the Append Structure name but you cannot find the Actual Structure it is attached to. You must be thinking Where-used list should help you find out but No it does not.

Solution:

Let us first analyze the issue. Suppose the below structure I am looking to find where is attached.

SAP HANA XS Advanced Administration, Deployment and Operations

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:

◉ xscontroller: Central management component of XSA. It has a view on all deployed and/or running applications, and persists configuration and status information in the database

SAP S/4 HANA Cloud Essentials MBC Bank Payments Automation

BACKGROUND

The scope of the blog is to describe the high-level architecture and the configuration steps required to integrate SAP S/4 HANA Cloud Essentials with the banks using SAP Multi-Bank Connector deployed on Business Technology Platform.

WHAT IS A MULTI BANK CONNECTOR?

MBC is a combination of SAP Managed CPI version deployed on SAP Business Technology Platform that is compliant with the banking security standards and SPRO Configuration that will be activated on SAP S/4 HANA Cloud Essentials backend when you purchase 16R Scope Item on SAP S/4 HANA Cloud Essentials (SPRO won’t be available for users on S/4HANA Cloud Essentials).