Friday, 15 October 2021

SAP S/4HANA Cloud and SAP S/4HANA 2021 Product Release

In this blog post, I have the pleasure to share with you the key aspects that bring intelligence to our Digital Core along with some of the highlights of the release.

Foundation of the Digital Core

Before we start with my top highlights from our SAP S/4HANA Cloud and SAP S/4HANA 2021 release, let’s find out what the foundation of the Digital Core is. We consider the following four aspects:

1. An architecture that delivers a scalable foundation to transact at the highest possible automation,

2. A system of intelligence that supports and steers the business using embedded analytics, simulation, prediction, and decision support to run LIVE business,

Wednesday, 13 October 2021

How to use HANA Exit in SAP Analytics Report [Selection Screen Default value]

Purpose / Issue –

SAP Analytics reports default value for Fiscal Year and Posting Period as Current Fiscal Year and Posting Period on the selection screen.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Report Selection Screen Value

Monday, 11 October 2021

Detecting Contextual Anomalies with SAP HANA ML

Introduction

What is an Anomaly?

The goal here is to detect outlier data points, which do not follow the collective common pattern of the majority of data points, hence can be easily separated from the group.

SAP HANA ML, SAP HANA Tutorial and Materials, SAP HANA Certification, SAP HANA Guides, SAP HANA Preparation, SAP HANA Career

Some of the possible use cases here are: 

Tuesday, 5 October 2021

Tools of HANA SQL Data Warehouse

Introduction

Now with some weeks delay I want to continue and give an overview which tools are necessary or helpful to build a SAP HANA Data Warehouse with in this way.

SAP HANA SQL Data Warehousing offers a high degree of flexibility with regard to the use of different tools. The SQL approach makes it possible to use many well-known (open source) software development tools, especially in the context of the applied DevOps philosophy. But also the SAP HANA platform brings some important own tools for the development of the native SAP HANA SQL Data Warehouse.

Friday, 1 October 2021

One Stop View for Production Supervisor – Manage Process Order

In this blog, I shall introduce you to this new application ‘Manage Process Orders’, a SAP S/4HANA Fiori App which is designed, keeping the supervisor persona in mind. By the end of this blog, you will have a good understanding of the features, this application offers to equip the production supervisor to carry out the responsibility of detailed planning of the production process.

Typically a supervisor is responsible for managing process orders, editing and releasing of orders, monitoring the order execution, assessing the production issues, making sure all required materials and equipment are available for the production team and so on. Overall, he must ensure the production line is always running and active. Executing all these actions at one time, that too effortlessly and switching between various apps and performing manual transactions could be a tedious job for the supervisor.

What if there is a single application that supports maintenance of complete life cycle of a process order end-to-end?

Wednesday, 29 September 2021

Cascading Filter Prompts in SAP HANA Modelling

Cascading filters are a group of prompts where the selection of one filter regulates the list of values accessible for selection in the successive filters. The key intention for this cascading is to make sure a better user experience by providing users with valid combinations of input parameter values. This feature is liked by many customers as it allows them to have a preview of their data through prompts before essentially seeing the information.

For Instance: We have two filter prompts for our HANA calculation view Country and State filter, So if we select India as country in our first prompt so we’ll automatically get only states of India in list of values like below:

Friday, 24 September 2021

SAP IBP Order Based Integration Architecture Real Time Integration (RTI)

SAP Integrated Business Planning for Supply Chain (SAP IBP) is one of the fast growing planning tool across the various industries. IBP application offers five core modules which are tightly integrated to achieve one business model within the organization.

It eliminates the silos in the planning process. During the COVID-19 pandemic most of the organizations effects with supply chain disruptions and companies are learning from the COVID-19 impact and trying to build the best supply chain planning process across the organization to support current and future disruptions.

Now coming to importance of this blog post to provide the update on latest innovation from SAP IBP production development team with regards to integration between SAP Order Based Planning (OBP) with SAP and Non-SAP systems integration.

Thursday, 23 September 2021

Mapping Risk in a Stormwater Network using SAP HANA Spatial and Graph

In this blog post I will show how to estimate the water load in a stormwater network and calculate the risk of an overload. Sure, I’m not a water network expert, but here is the idea: a stormwater network is a directed, (in our case mostly acyclic) graph made up of a set of edges/pipes and vertices/junctions. For each vertex we can calculate the catchment area, i.e. the area from which rain water most likely will enter the network via that vertex. Each vertex then propagates the load to its downstream network. By looking at the ratio of the pipe’s load and cross-section, we can estimate the overload risk for each pipe.

SAP HANA Spatial, SAP HANA Graph, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Preparation

Wednesday, 22 September 2021

Employee Integration to Business Partner without HCM

INTRODUCTION

To use Some Fiori apps are required to have the employees ID or employee business partner integrated with the user ID to use the app such as Manage Purchasing Categories (F0337). This post shows how to create an employee business partner without integrating HCM using Fiori App Maintain Employees (F2288A). We can use Fiori app Maintain Employees (F2288A) to create employee data. With this app, we can integrate the business partner with the user ID. when we create employee data using the app Maintain Employees, the system will automatically create business partner data BUP003 role. Later on, you can modify your employee data using T-Code BP or Fiori app Maintain Employees.

Tuesday, 21 September 2021

Upcoming Workshop: Collaborative Database Development in SAP HANA Cloud

Collaboration is the key to successful database development. And as part of our Virtual Data and Analytics Forum, which began last week, we’ll be holding a special workshop session on Collaborative Database Development in SAP HANA Cloud, HANA Database.

This workshop will use hands-on sessions to guide participants through a number of important tasks, from changing data structures and automating application deployment to setting up template projects for use by your colleagues. SAP HANA Cloud’s flexible data management capabilities will be on full display.

Monday, 20 September 2021

Boost performance of SAP Analytics Cloud tables by using proper styling techniques

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Guides, SAP HANA Career, SAP HANA Tutorial and Material, SAP HANA Preparation, SAP HANA Study Materials

Does styling of my SAC table cause performance drawbacks?

In fact, every story designer can try out whether sophisticated styling is a performance driver of a table widget. Do the following to test whether performance issues of your table widget is caused by filthy formatting: Measure the performance of your table widget with styling and without styling and compare results. To remove all styling definitions of the table widget we can make use of table templates (figure 1) – switching the table template will prompt the story designer to eventually delete all styling definitions (figure 2) previously applied. In other words, styling will be reset after selecting a predefined template. Thereupon, we can use the refresh button at the toolbar to measure performance of the table widget without any applied styling. In case the table loads quicker without any formatting applied, this can be interpreted as a strong hint that previously applied styling definitions cause performance issues.

Friday, 17 September 2021

Gain first hands on experience with the new automated S/4HANA deployment in Microsoft Azure

Try out the new SAP S/4HANA 2020 FPS02 production-ready deployment in Microsoft Azure with the quick and easy approach of SAP Cloud Appliance Library ( SAP CAL). It applies to standards aligned by SAP and Microsoft and follows their best practice.

We are looking for customers and partners who want to register and share their feedback with us before end of November 2021. Our target group are SAP System administrators with access to Microsoft Azure.

The deployed system allows for integration into Landscape Management Cloud to leverage its possibilities for system operations. The deployment itself will also soon be part of a comprehensive integration with Software Logistics Toolset starting with system design in maintenance planner, running the installation and offering an integration with SAP Software Upgrade Manager and notes implementation.

Wednesday, 15 September 2021

How-to Review and Set SAP HANA Parameters Following Updated Recommendations

I have always found myself in below situations during my career as consultant for SAP HANA specifically in projects for implementation, migrations/upgrades, and even daily operation:

1. SAP HANA Parameters setup during initial installation, following SAP best practice or recommended value(s).

2. Review HANA Parameters of existing systems in case of HANA Support Pack Stacks or HANA Revision update.

It could be of company own systems, managing systems for customers, or from migration project taking over from other vendors.

Monday, 13 September 2021

Dynamic OData from “any” API through SAP BTP Kyma

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Career

Greetings! Today we will be bridging 3rd-party and SAP applications easily with the help of SAP BTP Kyma runtime. Let’s go! πŸƒ

Sunday, 12 September 2021

Editable field selection in Verify Data Flow App

In this Blog, I will provide information you the information regarding how to visible editable field in Verify Data Flow App.

Verify Data Flow

We can use this component to post documents in Financial Accounting (FI) via a correction layer and suspense postings. We transfer documents from source systems into Financial Accounting. In these documents, there can be errors in the header or in the line-item data, for example, an incorrect company code or an incorrect balance. To perform these checks and automatically correct errors before posting, you can use the functions of Error Correction and Suspense Accounting (ECS).

Saturday, 11 September 2021

Hands-On Tutorial: Script and deploy Python with the new Jupyter operator in SAP Data Intelligence

The new Jupyter operator brings interactive Python Notebooks into your SAP Data Intelligence pipelines. Script your notebook directly in the pipeline and deploy exactly the same notebook and pipeline into production. No need to script in one place and to copy / paste the code into a Python operator.

Learn how to use the operator with a Machine Learning example, that forecasts multiple time-series in SAP HANA using the embedded Automated Predictive Library.

With Python you can implement a million things, other than Machine Learning by the way. Data retrieval or data preparation or just two further uses cases.

Friday, 10 September 2021

Using Multiple Identity Providers in SAP HANA Cloud Administration Tooling

Recently, we introduced support for multiple identity providers (IdPs) in the SAP HANA Cloud administration tools (SAP HANA Cloud Central, SAP HANA cockpit, and SAP HANA database explorer). The benefit of using a custom IdP is that SAP HANA Cloud users can now be authenticated by their company’s IdP, as opposed to authentication via SAP ID Service. An identity provider creates and manages an organization’s user identity and associated identity attributes. With the user’s consent, IdPs offer authentication services to websites, applications, and other services by federating the identity and authenticating an end-user to the service provider using the identity the IdP manages, but without sharing actual login details. The basic mechanism of using custom IdP is as follows:

Thursday, 9 September 2021

Pre-built Workflow Content to Handle Credit Memo Request in SAP S/4HANA

SAP Workflow Management enables the digitalization of workflows, decision management, and visibility on end-to-end business processes (SAP & non-SAP). It empowers business experts to configure new process variations in an LCNC (low-code/no-code) approach and provides business users with SAP Fiori-based user interfaces.

With SAP Workflow Management, our customer gets access to pre-built process content templates/samples across applications. A workflow content package can include re-usable workflow models, decision logic, dashboards to monitor the process, user interfaces, and integration flows to connect with the backend system. This enables our customers to import such templates, change them as per their requirements, and run the process in a limited time.

Wednesday, 8 September 2021

NSE: Systematically Measure Memory Savings

This guide will show a methodical approach to finding data with a large memory footprint and calculating the memory storage savings after moving them to disk via Native Storage Extension. The TPC-H dataset is used in this guide.

Assumptions:

◉ Reader has access to a provisioned SAP HANA instance SPS04+

◉ Reader has familiarity with Database Explorer, SAP HANA Cockpit, and HANA System Views

Monday, 6 September 2021

Cloud Integration (SAP CPI) – API_CV_ATTACHMENT_SRV (OData API for attachments)

Introduction:

Recently I faced a use case in which a integration flow needed to add an attachment to a supplier invoice, we have standard OData/SOAP API to perform operations like create, read, rename, and deletion of attachments, In this blog I’m going to discuss adding (creating) an attachment to supplier invoice by consuming OData API.

Pre-requisite:

1. Before consuming the OData API make sure that API_CV_ATTACHMENT_SRV oData API is active ,system client ID and alias name maintained.

2. Check the entity list and make sure “AttachmentContentSet” entity set is present to create an attachment.

Saturday, 4 September 2021

Near Zero Downtime Maintenance

Maintenance windows for SAP systems can be very limited because companies cannot afford extended downtimes since some of these systems are really key to production, for example the Supply Chain Management or the Customer Relationship Management among others,

Any SAP Basis, OS and Infrastructure engineer knows how challenging it can be to finish successfully and in time a maintenance on the SAP servers of the company and besides if it is for production hosts they should be carried out outside business hours which is an added effort.

Another challenge the IT departments need to deal with quite often when it comes to the SAP estate is to get the buy from the business so that the servers can be kept up to date regularly with all the recommendations from SAP notes, security fixes, patches, etc. Many times they get push-back because the users cannot afford too regular maintenance windows and the systems risk becoming not compliant or vulnerable.

Thursday, 2 September 2021

SAP’s Data Warehouse Strategy for Healthcare Providers

In this blog post, I am going to present SAP’s latest strategic statement of direction for data warehousing and show the consequences for typical health care providing companies. The goal is to establish a common understanding of requirements and to show a way forward for healthcare companies on their way to become intelligent enterprises and data driven companies. With this, you will get clarity and confidence for future investments in the BI field.

Requirements and Challenges

Time To Value: Fast development and deployment cycles are key for healthcare companies to react to changing environments and new challenges. Self-service capabilities like modelling in non-tech business languages or a common business catalog describing the data foster the collaboration of business and IT and help to accelerate BI projects.

Sunday, 29 August 2021

Freight Collaboration with SAP Logistics Business network (LBN) and its integration with SAP Transportation Management (TM)

SAP has developed & released a cloud application called as ‘Logistics business network (LBN)’ to network and communication with partners (Shippers, Carriers, Customs authorities etc) involved in logistics (warehousing & transportation) operations. LBN has 3 components

1. Freight collaboration

2. Global track & trace (GTT)

3. Material traceability

LBN can be integrated with SAP ECC , S/4HANA, Transportation management ( TM ) and Extended warehouse management (EWM).

Friday, 27 August 2021

CAP: Access the HANA DB behind (via HANA Explorer)

When you create a CAP application with HANA as the database, it is not very intuitive to find how to explore tables/views of the application (being a developer). This method can also be used for loading initial data (via xlsx, csv files) to your tables during production cutover.

In this short blog, I will explain how to do that.

What won’t work?

If you go to your HANA Cloud instance ( in the Space ) and open the HANA explorer, this actually tries to open the explorer via the HANA Cockpit so it requires you to know the DBADMIN credentials which as a developer you will not have. Moreover sharing DBADMIN credentials is not safe as this single HANA instance can be serving Sandbox, Dev, QA landscapes and DBADMIN can edit/view tables of all applications in all of those landscapes.

Wednesday, 25 August 2021

Key Concepts in Privacy Technologies

Introduction

We live in a digital age, where our personal data is collected, processed, and disclosed at an unprecedented rate. Various Privacy Technologies and Privacy Risk Management Framework are being evolved today to address growing need to protect personal or sensitive data. Privacy being a fundamental right in many geographies and international organizations, the government around the world are in a frenzied race to enact privacy regulations and make it mandatory for organization that collect and process personal to adhere to the core principles of data protections and privacy. In particular, there has been greater emphasis on privacy enhancing technologies to protect the personal data such as technologies that are available for consent management, data minimization, data tracking, data anonymization, de-identification, pseudonymisation, encryptions, tokenization, masking, obfuscation, access control and identity, authentication and authorizations. In this blog, we will review some of the key data privacy technologies commonly deployed and how SAP HANA supports various privacy technology to provide tools for our customers as a data controller to meet the compliance. For the sake of simplicity, only high level concepts are presented in this blog.

Friday, 20 August 2021

Run XSA application(UI part) locally with visual studio code

I have been working on XSA for a while, the SAP WEB IDE FOR SAP HANA is a bit outdated(especially for ui5 development) and sometimes not that performant. Recently i managed to move the xsa application to visual studio code and run the UI part(for now) locally. This blog post will show you how I moved and the solution for the issue encountered during the setup.

Note: This blog post is about moving your xsa development (UI part at least) to visual studio code, not about using visual studio code to do xsa app development from scratch

some prerequisite:

1.visual studio code +plugin

2.node js+ git

3. a running xsa application in your xsa( to get the destination and service binding info)

Wednesday, 18 August 2021

Near real time Data Replication from Salesforce to SAP HANA using the Advantco Salesforce adapter for SDI

Introduction

Salesforce provides APIs that enable external applications to receive events in near real time mode. In this blog, we provide a detailed configuration steps for two of these options: Platform Event and Change Data Capture (CDC). Platform Event is an excellent option when data from multiple objects are required as in the case of combining data from Opportunity with details from the Account object. Change Data Capture (CDC) provides a quick and configurable option to publish data of a specific object like Account or Contact.

The solution we describe here is based on SAP Smart Data Integration (SDI) tools which provide features to support data replication from external resources to SAP HANA. The two most important components in this context are the Data Provisioning Server, which is a native SAP HANA process, and the Data Provisioning Agent, which is a container running outside the HANA environment. The Advantco Salesforce adapter is deployed on the Data Provisioning Agent host and can be configured from the HANA environment duration the creation of a remote source. The remote source is the connection from SAP HANA to the Salesforce instance.

Monday, 16 August 2021

SAP S/4HANA Cloud Fit-to-standard approach for technical areas

Introduction

There are lot´s of good SAP blog posts, which describe Fit-to-standard methodology. Many of them highlight main points for business-related topics. I would like to sum up my experience in relation to SAP S/4HANA Cloud Implementation Fit-to-standard methodology for technical topics. There are following streams in SAP S/4HANA Cloud implementation projects, which require more technical knowledge, rather than business:

  • Integration
  • Migration
  • Output Management
  • Embedded Analytics
  • Master Data Management
  • Extensibility
  • Security

Friday, 13 August 2021

Integrating SAP HANA Data Lake to Google Big Query – DL2BQ

A Simple Architecture:

SAP HANA Cloud, BW SAP HANA Data Warehousing, SAP HANA Tutorial and Materials, SAP HANA Certification, SAP HANA Guides, SAP HANA Learning

Pre-requisites: You must have your btp trial account up and running & data lake instance should also be running & have your credentials also ready for an open database connectivity

You should also have your gcp trial account ready – & make sure you have downloaded the gcp credentials in json format locally in your system.

Tuesday, 10 August 2021

Error Handling in HANA

Requirement –

This blog explains how we can Implement Error Handling in HANA Sql to maintain data reliability, durability & consistency during execution of multiple DML statements in a single code block.

Implementation Scenario –

Let’s say, we have HANA stored procedure or Sql Code block and it has 5 Insert statements inserting data in a table (HXE_SAMPLE.ERROR_TEST) which has Primary Key defined on ID Column.

Sample Table Structure –

CREATE TABLE HXE_SAMPLE.ERROR_TEST (ID INTEGER PRIMARY KEY);

Monday, 9 August 2021

Aggregate Data from Multiple SAP HANA Sources to One SAP HANA Cloud, HANA data lake IQ

With SAP HANA Cloud, hybrid landscapes (on-premise systems working with cloud systems) have become easily attainable. However, when doing aggregate data analysis, it might be easier to have the data of interest in a single source to keep data types and functionality consistent. We will see that with a HANA Cloud database and remote connections, the movement of data from multiple HANA instances to an SAP HANA Cloud data lake can be done from a single SQL console!

Today, I am going to bring data from an on-premise SAP HANA system together with an SAP HANA Cloud database in a single SAP HANA data lake. I will start from a landscape which has an SAP HANA Cloud database, SAP HANA database, and SAP HANA data lake connected.

Wednesday, 4 August 2021

Monitoring & Analysis for SAP HANA Platform

The described aims to enlighten the audience about the Real-time Monitoring capabilities exposed by the SAP HANA platform. System Administrators maintain the integrity and consistency of the SAP HANA platform by performing regular system monitoring which helps with identifying system behavioral patterns. A combination of monitoring tools and checks provides a detailed technical overall system health check and helps with identifying and forecast requirements against possible data & Hardware bottlenecks.

An adequate System monitoring exercise involves continuous monitoring of the following but not limited to these environmental components:

Monday, 2 August 2021

How To Do DTO in BW/4HANA Step by Step

This document provides the details of DTO implementation in BW4/HANA NLS-IQ 16.x

Data Tiering Optimization(DTO) helps SAP BW/4HANA customers to classify the data stored in the DataStore object (advanced) as hot, warm or cold, depending on the cost and performance requirements for the data.

Depending on this classification and how the data is used, the data is stored in different storage areas.

Friday, 30 July 2021

Output Management: adding contact person to Billing Document form in SAP S/4HANA Cloud

Introduction

One of the popular requirements in terms of adjusting output forms is to add contact person to the document header. In Billing Documents, for example, there is no such default field, therefore custom field and logic are necessary. In most cases we can use name of employee, who created the document as contact person name. Let´s have a look, how to implement this requirement in Invoice form.

Thursday, 29 July 2021

SAP Security Authorization Trace & Checks

Introduction

Authorization trace is mainly performed to identify and record the missing access against the user access. Tracing supports when the default authorization values are stored in Tcodes like SU22 and SU24 and when maintaining the same authorization data for roles. Traces are of basically of types, they can be either system-wide or limited to a specific user or instance. Tracing can be executed for trouble- shooting, especially for missing access in SAP GUI by validating the access provided to the SAP User ID. This article majorly describes how to perform tracing in R/3, ECC and S/4 systems.

Users & Access

For delivering the day-to-day business requirements in SAP, users require ID and password to login. The types of users that login to SAP are categorized as follows:

Wednesday, 28 July 2021

Introduction to Intelligent Scenario Lifecycle Management(ISLM)

Overview

Intelligent Scenario Lifecycle Management (ISLM) is a framework that allows you to perform lifecycle management operations on machine learning scenarios. You can consider ISLM as a self-service tool that allows you to handle various operation requirements of machine learning scenarios. You can train an intelligent scenario and use the trained model to get an accurate inference result.

Depending on the machine learning scenario that is associated with a business application, the scenarios can be categorized as:

◉ Embedded: In this approach, a business application, for example SAP S/4HANA runs in the same stack as its machine learning provider SAP HANA machine learning with the analytics libraries SAP HANA Automated Predictive Library (APL) or SAP HANA Predictive Analysis Library (PAL). APL exposes the data mining capabilities of an Automated Analytics engine for developing predictive modelling processes for business analysts. PAL offers advanced analytics algorithms for data scientists. This can be used to solve use cases of forecasting, trending, and so on.

Monday, 26 July 2021

SAP Central Finance & FSCM with Central Payment

SAP Central Finance, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career

In this blog we will only focus on the impact of SAP Central Payment activation on the FSCM processes running in the organization in ECC systems.

Lets assume (for the sake of keeping it simple) we just have one SAP ECC as source system and of course one SAP S/4HANA system as a target system.

Saturday, 24 July 2021

SAP S/4HANA Service overview and Service Order Processing

Overview

During ERP era Customer Service (CS) component supports all the processes related to Services which we provide to customers. We can Structure and create Technical Object, manage data for Warranties, Create Service Requests, bill the cost occurred during service processing. However, this is not part of long-term scope in SAP S/4HANA journey. CS will no longer available after 2025, hence no license and support would be provided as well. Moreover, SAP could choose to remove them at any time after 2025.

SAP is providing the solutions to cover the scope of CS within S/4HANA itself.

Until S/4HANA 1809 the new service functionality was an add-on for S/4HANA called Customer Management.

Friday, 23 July 2021

SAP 3D Visual Enterprise Manufacture Planner (SAP 3D VEMP)

Growing complexities of any industry along with its own growth provides a way to compete and try to derive best solution possible. Same happened with discrete manufacturing industry, big giants like SAP, Oracle, Salesforce, and others focused their will to deliver a best-known solution to make the complex process of discrete manufacturing easy to consume for the customer. Integration of the solution with all other modules of complete Product Lifecycle Management (PLM) process is exciting and a big challenge for everyone. More exciting is to find out the solutions they provide and how they differ and challenges the complexity of the discrete manufacturing industry problems.

Thursday, 22 July 2021

Augment your Python Analysis with Multi-Model data in SAP HANA Cloud

A lot of data science and machine learning work is done in Python. For this, the “Python machine learning client for SAP HANA” (hana-ml for short) provides easy access to SAP HANA tables in the form of Pandas compatible data-frames. However, with its multi-model capabilities (like spatial, graph, and document store), SAP HANA has more to offer. In this blog post, you will learn about the enhancements of the library to support these multi-model capabilities and how you can leverage them for your work. We will walk through an end-to-end example based on Wellington’s stormwater network. We will evaluate and visualize the graph and show how we can analyze problems that might occur in the network based on built in graph algorithms. The data and code is available on github.com. If you want to run the Jupyter Notebook yourself, you need to take care about the prerequisites.

Wednesday, 21 July 2021

Order-Related Replenishment in SAP S/4HANA Cloud Warehouse Management

In this blog post we will cover Order-Related Replenishment at Storage Type level with Rough Bin Determination.

Rough bin determination means the storage type must be written to the delivery item even if no stock exists. You specify that the storage type (without storage bin) is written to the source data of a delivery item, even if there is no stock for the product in the storage type. This enables you to use the order-related replenishment to perform replenishment for the pick storage type, since a requirement for picking occurs in this storage type as a result of this. If rough bin is not enabled, the storage type is generally not used if there is no stock for the product in that storage type.

Characteristics of Order-Related Replenishment:

◉ Like planned replenishment, it can be triggered either interactively or in the background

◉ It calculates replenishment quantities according to open warehouse request quantity

◉ It is started when stock figure is lower than the required quantity

◉ It rounds up to multiples of minimum replenishment quantity

◉ Exceeding maximum quantity is possible 

Tuesday, 20 July 2021

Connecting HANA DB using python Language

1. Overview

This document will explain you, how to connect HANA database and table operations using python language.

2.  Prerequisites for HANA connectivity from Python

◉ Python latest software installation

Monday, 19 July 2021

Mass Change of Sales Documents

In this blog, I will share with you the minimum configuration needed to activate and leave the app ready to use. Also, a tour of its functionalities, the multiple available fields you can change, and the option to include a new field by extensibility.

Let´s start with the required configurations:

Step 1 – Activate the services as indicated in the Fiori app library in the level “Implementation Information”.

Step 2 – It is necessary to configure the number of parallel processes it allows. Please check this with your technical team to avoid any negative impact on the daily operations.

Friday, 16 July 2021

HANA – Multiple(selected) tables binary data export / Import using script

HANA admin / developers frequently get tasks to export/import selective list of HANA tables data to disk for stage refresh,  backup, re-partitioning  etc.

Developed bash script code helps automate export or import activity for multiple selective tables.

Features

◉ Server level export /import execution instead from studio as client

◉ script can be run in background at HANA server and progress can be monitor

◉ easy configuration using hdbuserstore

◉ input list of tables and script will take care of export /import

Thursday, 15 July 2021

SAP HANA Fast Restart Option (tmpfs) – Reducing Downtime without Persistent Memory

The goal of fast restart option is to improve large in-memory SAP HANA database restart times. This article outlines the plan to address this important area of reducing downtime with a step by step approach, recommendation on tmpfs sizing and FAQ’s.

To understand the concept of fast restart option (FRO) with tmpfs, basic understanding of tmpfs file system functioning is required

Basics Of tmpfs filesystem: –

tmpfs (temporary file system) is a virtual filesystem created to store files in dynamic (volatile) memory also known as DRAM (RAM). Tmpfs filesystem is typically created on RAM.

Wednesday, 14 July 2021

Cost Center Commitments in SAP S/4HANA Cloud

Introduction

Commitment management in SAP S/4HANA tracks future commitments against cost objects (I.e. Cost center, Internal order etc.) This helps user to do comparison between actuals and commitments. Commitment amounts are available as information for reporting purpose. You cannot use commitments to prevent user from creating the purchase order that exceeds budget. Prevent user to post actual greater than budgeted is available in Availability Control functionality in SAP S/4HANA Cloud. Commitment management is a part of the cost monitoring process. Commitment Management line items are triggered by purchase requisitions and purchase orders that utilize cost centers. These commitments are updated in Extension Ledger 0E (pre-delivered) in the ACDOCA table. Commitments are reduced by various business transactions such as goods receipt, service entry sheet etc.

Tuesday, 13 July 2021

Perspectives on Future of Data Privacy and Challenges

Introduction

We live in an exciting era where business is transforming at an unprecedented rate that we have not fully come to grasp its impact on data privacy. Look at the statistics which are staggering. Globally, smartphone penetration is estimated to be 8 billion smartphone subscriptions worldwide. An average smart phone user has 80 application on its phone and approximately 10 application are used daily. The mobile phone application collects enormous amount of personal data such as GPS location, IP addresses, voice, video, contact lists, text messages, passwords, call history. The e-commerce and service providers use advance digital technologies such as Artificial Intelligence, Machine Learning, Software Robotics to profile and process personal data. Realizing the impact of data privacy and harm it may cause to individuals and society, many countries globally have been enacting data privacy regulations.

Monday, 12 July 2021

Closing the Experience Gap with Customers using S/4 HANA and Qualtrics

Managing Customer Experience:

While an unhappy customer might start to ring alarm bells, most of the successful companies see it as an opportunity to resolve the complaint and keep the customer loyal. In fact, 73% of customers say they stay loyal to brands because of friendly customer service agents. (HubSpot, 2021).

More Info: C_HANATEC_17 Key Points

So, it’s an opportunity to demonstrate to your customer in a much more direct and personal way that their feedback is important, and you care about the outcome.

But it’s not just about preventing unhappy customers from becoming detractors – it’s equally useful to follow up with neutral customers and turn them into promoters.

Saturday, 10 July 2021

Friday, 9 July 2021

SAP Data Intelligence: Insert JSON Data into SAP HANA or SAP Data Warehouse Cloud

Introduction

JSON is a widely spread format for exchanging and storing structured data. It enjoys great popularity in the age of microservices, e.g. for exchanging data between servers and clients via RESTful APIs. In this blog post, I’ll show you how to persist data in JSON format to an SAP HANA table or an SAP Data Warehouse Cloud table using SAP Data Intelligence.

For this purpose, the “SAP HANA Client” operator in SAP Data Intelligence is used. In addition to other options, such as executing SQL commands and inserting csv. data, it offers the possibility to persist JSON files in SAP HANA and SAP Data Warehouse Cloud. It is crucial that the file has the correct format. You can see examples of the correct implementation of the JSON file in this blog post.

Thursday, 8 July 2021

Slipups & Limitations while Exposing S/4HANA Launchpad Content via Content Federation

SAP BTP Launchpad service could be used as a central point of access to SAP, custom-build and third-party applications and extensions there by leading to higher user productivity.

The Fiori content can be exposed to BTP launchpad manually or via Content federation. To know how S/4HANA launchpad content can be federated to BTP, check out this Tutorial on developers.sap.com. This is a detailed set by step process.

While I tried this , I stumbled upon couple of issue and had spend some time to figure out what’s wrong and that is what i want to share in this blog so as to help others in case they face they same issue. We will also look at some of the content federation limitations.

Wednesday, 7 July 2021

Some Different Approach for SAP S/4 HANA Upgrade

As we all know SAP has some robust documentation and approach in upgrading from lower release of S/4 HANA to higher release. This personal insight is just based on some lessons learned and how we can proactively take control to ensure that we adhere to a timeline with less uncertainty.

While working on some of the upgrade projects,   we have come across some common issues, and as we all learn from our experience. This blog will help us to dig into the system and understand it beforehand so that there is no surprise at a later point in time.

Monday, 5 July 2021

Core Features for Palling and Their Benefits in SAP Analytics Cloud

SAP analytics cloud is the go-to tool for businesses looking to distribute funds for R&D, improve their sales, forecast their future processes, and reallocate their market spend. It offers practical and intelligent analytics to keep any business on its toes and aware of its presence in the market.

The latest addition to the SAP Analytics Cloud is developed for business plans and to consolidate operations in unison with predictive analytics in the functionalities components of any business. As a result, businesses leverage their strengths and weaknesses by improving their success scores and developing new strategies to operate better in the market.

Saturday, 3 July 2021

Know Your Dependencies – Network Tracing with SAP HANA Graph

In this blog post, I will show how to use some basic SAP HANA Graph functions to understand dependencies in a directed graph. The demo data describes python packages and their dependencies. Resolving package dependencies is required if a package manager like “Anaconda” needs to check for pre-requisites before installing a new package. However, the patterns discussed in this article are generic and apply to use cases in manufacturing, utilities, IT and many other industries. The data and code is available on github.

Friday, 2 July 2021

Cash Management – How to combine Cash Flow Analyzer and reports Cash Position and Liquidity Forecast FF7AN/FF7BN

Today I would like to talk about Cash Management in SAP S/4HANA. There is great news about this business process, no matter if the decision was to go for the basic or the advanced version of it. Today, it  is possible to work with Cash Position and Liquidity Forecast (AKA FF7AN and FF7BN) from the backend or the Launchpad, together with Cash Flow Analyzer app, to obtain better and more complete information about financial flows derived from items in Finance and Logistics.

As Cash Flow Analyzer uses a predefined structure and brings more dynamism in financial position visualization with less selection criteria, let´s move thru its different selection fields and see how we could get a similar output in Cash Management and Forecast FF7AN /FF7BN transaction.

Wednesday, 30 June 2021

Using the graph engine in SAP HANA for Master Data Substitution

What is Master Data Substitution?

Master Data Substitution is a process when requested master data entity can be substituted by another one. Master Data substitution is very generic framework which supports different master data entities and provides various features like Exclusion, Grouping, Context Objects, Validities etc.

Example: Product Substitution. In Sales order, if Customer is requesting for Product A, but this product A is not available due to out of stock or for any other reason we will not be fulfilling customer demands. But Product B is available which is having the similar specifications as product A, then Product B can be substituted and fulfill customer demands. Product B can further be substituted with Product C and Product C can be substituted with Product D.

Tuesday, 29 June 2021

S/4HANA Fashion Purchase Order and Season Determination

Introduction

The integration between the fashion industry and the season is seamless. Thus, it is far more important as the article purchasing, production or selling depends according to the demand within the respective season. Mainly, seasons such as spring, summer, fall, winter / holiday, and no season will be configured in SAP within the fashion industry. The “no season” is created to cater a particular article all throughout the year. Hence, the applicability of article is determined based on the season assigned, in which it could be assigned to a new season or carry over season (same article valid for the next upcoming season).

Read More: C_HANAIMP_16

Monday, 28 June 2021

Advanced ATP Release for Delivery in SAP S/4HANA

Introduction

This blog is for SD consultants. I used SAP S/4HANA OP2020 FPS01 version.

What is Release for Delivery

It is manual back order process.

Read More: C_TADM55a_75 Key Points

After advanced ATP BOP you can also modify the results manually just before creating delivery documents.

You have to create delivery documents through Release for delivery, if you modify confirmed quantity by using it.

Friday, 25 June 2021

The SAP HANA Cockpit Dump File Viewer

Overview:

The SAP HANA cockpit Dump File Viewer is a new application introduced in SAP HANA cockpit SP 13. It can be utilized for displaying critical state information and simplifying the analysis of database performance issues. When there is an error situation in SAP HANA and a dump file is created, the Dump File Viewer can help users to easily view, analyze, and navigate within the dump file contents to determine the cause of the problem. There are different types of dump files available to analyze:

More Info: C_HANATEC_12 Key Points

◉ RTE – A runtime environment dump that is manually created by running the “runtimedump dump” command in the hdbcons command-line tool.

◉ OOM – An out of memory dump that is created when the system runs into an out of memory situation.

◉ Crash – A crash dump that is written when SAP HANA runs into a situation that causes the operating system (OS) process to crash.

Wednesday, 23 June 2021

Access Salesforce custom objects from HANA Cloud via SDI

I’m going to explain how to connect in the following sections.

1. Install DP Agent and configure SAP HANA Cloud connection

2. Deploy and register the adapter for Salesforce

3. Add remote source to SAP HANA Cloud

Prerequisites

Prepare following environments in advance.

1. Salesforce

2. SAP HANA Cloud

3. An operating system which DP Agent will be installed (Linux / Windows)

Tuesday, 22 June 2021

Using SAP HANA Graph to map relationships between different SAP products

In this blog post I cover how you can use the power of SAP HANA Graph to map/keep track of the relationships between different SAP products.

In our jobs as developers/consultants/architects, it is expected from us to know how different SAP products relate with each other or how they integrate with 3rd party products. This can be especially challenging given the number of products/components/services that SAP provides. In my attempt to keep track of this I have notes, diagrams, links, documentation that help me understand how they relate to each other. Unfortunately, that data is not that well organized.

Monday, 21 June 2021

Product Availability Check in STO based on issuing storage location in S/4Hana Cloud

Introduction

This blog post has been written to address common customer query on PAC in STO. When an intercompany purchase order (PO) is raised by one plant to procure stock in another plant, customer need to be able to specify a supplying/issuing storage location as well as the supplying plant.

When the issuing storage location is not editable then when the outbound delivery needs to be created at the supplying plant, it is necessary to first move the stock required on the purchase order to the default supplying storage location . After this generate the outbound delivery. This is an unnecessary extra step that complicates and makes the process less efficient

Saturday, 19 June 2021

Using the SUM Prerequisite Check Extended to Prepare Your Conversion to SAP S/4HANA

There are many tools to help you prepare for a system conversion to S/4HANA. From to the Prepare Phase with the SAP Readiness Check and Maintenance Planner to the Explore Phase, using the SUM itself as a Prerequisite Check tool prior to your Sandbox cycle. This is every helpful for the technical team early in the project to discover some of the errors reported by SUM tool on the source system. Or they are waiting on the functional team to resolve the many simplification items errors, which is usually trigger a hard stop (e.g. RUN_S4H_SIF_CHECK_EXEC steps in SUM), or simply waiting on infrastructure or HANA DB procurement for those who are on a classical database.

Thursday, 17 June 2021

Use Geospatial Methods and Predicates feature in SAP HANA

Business Example:

There is a requirement from a client where the client wants to calculate the distances between their customers and their stores. Typically, locations or addresses in a database are stored in text fields, making it difficult to pinpoint the exact geographical locations.

To be able to calculate distances accurately, you have decided to store the geographical locations of the customers and stores, using the SAP HANA geospatial model and its related functions.

Wednesday, 16 June 2021

Scheduling Python code on Cloud Foundry

This blog starts with a very simple example to schedule a Python file on Cloud Foundry, just to introduce the most important steps. That concept is then extended to schedule a Python file, which applies a trained Machine Learning model in SAP HANA.

Run Python file locally

We would like to schedule a Python file, not a Jupyter Notebook. Hence use your preferred local Python IDE or editor to run this simple file, helloworld.py.

Monday, 14 June 2021

Piecewise Linear Trend with Automated Time Series Forecasting (APL)

If you are a user of APL time series, you probably have seen models fitting a linear trend or a quadratic trend to your data. With version 2113 the Automated Predictive Library introduces an additional method called Piecewise Linear that can detect breakpoints in your series. You don’t have to do anything new to take advantage of this functionality, the trend is detected automatically as shown in the example below.

For SAP Analytics Cloud users, note that Piecewise Linear Trend is coming with  the 2021.Q3 QRC (August release).

Friday, 11 June 2021

Using SDI FileAdapter to write to Azure file share

In this blog we will create an Azure file share and use it as a destination for SAP SDI FileAdapter.

Prerequisites

1. Azure Account

2. SAP HANA Data Provisioning Agent server enabled

3. SAP HANA Data Provisioning Agent installed

Let’s start by creating the Azure file share. Login to the Azure portal and create a premium storage account  as depicted in the below screenshot

Thursday, 10 June 2021

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

Wednesday, 9 June 2021

SAP on AZURE/ SAP on AWS : Cost Optimized DR Solutions for HANA : Lean/Skinny DR

Running SAP on the HANA database is not only having multiple advantages, but also few cons as well. The hardware cost to run the HANA database is one of them. Since HANA is an in-memory database, customers must provision higher-size RAM and CPU to run their SAP on HANA. Even in hyper scaler environments like AZURE/AWS, HANA VM (M-Series) cost is huge comparatively and concern for most of the customers.

Keeping this in mind, designing a disaster recovery solution for HANA is a very challenging one.&To address this design challenge, we can consider multiple cost-optimized options like

Monday, 7 June 2021

The DMEEX Trace Tool

SAP HANA Exam Prep, SAP HANA Career, SAP HANA Preparation, SAP HANA Certification, SAP HANA Prep, SAP HANA Learning

With the release of SAP S/4HANA 2020 Feature Pack 1 (onPremise), DMEEX receives one of the biggest updates in its lifetime. We implemented a tool that opens and clarifies DMEEX Engine processing. In this tool, you can see and analyze how the DMEEX tree was processed in detail, without the need to debug its code. We call this tool the DMEEX Trace Tool.

Friday, 4 June 2021

How to Setup SAP HANA Multi-Target System Replication

SAP HANA System Replication is a reliable high availability and disaster recovery solution that provides continuous synchronization of a HANA database to a secondary location either in the same data center or remote site as a disaster recovery site.

More Info: SAP HANA Certification

In this article fI have tried to keep it simple on how to setup a system replication when you want to replicate single primary to multiple target which may be in same data center or at remote site.

For better understanding let us assume below.

Thursday, 3 June 2021

Solution Order Management in SAP S/4 HANA Cloud 2105

In the 2008 release, SAP S/4 HANA Cloud introduced Solution Order Management in response to market demand for a hybrid solution in which sales and service functions merge seamlessly. Solution Order Management helps customers grow their margins by transitioning away from selling individual products and services to providing bundled business solutions consisting of products, one-time services, and recurring service subscriptions. With the 2105 SAP S/4 HANA Cloud release, we have broadened the scope of Solution Order Management, and in this blog, I’ll take you through a few of the key updates.  

Wednesday, 2 June 2021

Update on Basic Shipping for SAP S/4HANA 2020

SAP’s strategy for Transportation Solutions in SAP S/4HANA

Since the introduction of SAP S/4HANA® some of the previous modules/solutions available in SAP ECC became available through something called “Compatibility Packs”. A Compatibility Pack (CP) is a version of a standard SAP Business Suite software product that is compatible with SAP S/4HANA.

Compatibility packs:

◉ Cover functionality from SAP ERP core or line-of-business (LoB) or industry solutions

◉ Comprise the complete or partial scope of the related SAP Business Suite product

◉ Will be phased out in favor of other strategic solutions that may have similar functionality to that within the CP software and may have a separate license.

Monday, 31 May 2021

A tip of defining Synonyms at HDI using SAP Business Application Studio

Purpose

I found accessing tables in HDI container using SAP BAS is a bit of tricky and have been juggling of how to use the form editor for synonym. Here is a tip for someone who might have been in the same dilemma as I have, or for who don’t want to spend time on investigating and heading around in trying to find the reason as I did.

Environment

A  table (“city”) & the data have been generated in an external data source – Data Lake whose connection is already established on HANA Data Explore (Please refer to other blog if you need to link external data sources to HANA ). I created a schema ‘booking’ in my HANA cloud.

Wednesday, 26 May 2021

Adaptation Project: New Facet with Smart table (OData Redefinition & Translation)

Adaptation Projects or say it application variant, is a feature to extend SAP delivered/Standard fiori elements app.

In this blog post, I will show step by step:

1. How to re-define the OData service

2. Create adaptation project in web IDE with new facet

3. Deployment process

4. Translation for the variant, tile and entity in another language

5. And last configuring the tile for the FLP

Monday, 24 May 2021

Mass Update of SLT Advanced Replication Settings

Requirement: Need to add a new column DW_LOAD_DATE (containing system timestamp) for all tables replicating from S/4HANA to Enterprise HANA. This will enable us to understand the exact timestamp when a particular record was replicated to HANA.

Challenge: Currently we have more than 180 tables in active replication. Adding DW_LOAD_DATE manually to each table in the configuration is very time consuming, error prone and most of all boring.

Possible Solutions:

1. Manual Addition

2. Addition of field via Template Maintenance

3. Mass Update by editing the Exported Advanced Replication Settings Files.

Friday, 21 May 2021

Populate Dates Between Start & End Dates

Requirement

This blog is intended to show how we can fill the dates if dates are saved in two columns as StartDate or EndDate ( Refer Sample Data of Date Rang Table Screenshot).

We have one Transaction table which is having data for each day (Example: PGI_DATE).

In another table, data is entered by date range.

Monday, 17 May 2021

Intelligent Asset Accounting with SAP S/4HANA Cloud

In this blog post we will see how the traditional Asset Accounting processes which were manual, tedious, time consuming gets automated with innovations in intelligent technologies like SAP Intelligent Robotic Process Automation.

Asset Accounting processes –

1. Update Asset master

2. Asset Acquisition

3. Asset Transfer within company code

4. Asset Transfer across company code

5. Asset Retirement

6. Asset Retirement by Scrapping

Tuesday, 11 May 2021

How to install & run the ABAP on HANA Sizing Report (SAP Note 1872170) – A Step-by-Step Guide

In this blog post you will get a clear, step-by-step process of how to install and run the ABAP Sizing Report (described in SAP Note 1872170), with screenshots accompanying each step.

Steps involved

1) Check System Version

The first thing to do is to verify the version of your system that you are going to install and run the report on. This report runs on SAP_BASIS 620 and higher.

Wednesday, 5 May 2021

Develop UI5 / Fiori App Using VS code.

Step 1:

1. Install Node.js  – Node.js® is a JavaScript runtime built on Chrome’s V8 JavaScript engine.

2. Install VS Code – Visual Studio Code is a code editor redefined and optimized for building and debugging modern web and cloud applications Link.

Step 2:

Create a folder and open it in VS code.

In VS code go to Extensions(cntrl +shift+ X).

Monday, 3 May 2021

SAP HANA on Google Cloud + NetApp CVS: non-disruptive volume size and performance scaling to fit workload needs

SAP HANA on Google Cloud + NetApp Cloud Volume Service: Resizing volume size and performance to fit your workload needs in a non-disruptive manner.

If your HANA instance is running on Google Cloud, utilizing NetApp CVS, you can take advantage of its non disruptive, flexible volume scaling that fits performance needs. It provides you the flexibility to increase / decrease volume size to juggle between performance and cost in uptime.

For example, you can easily increase the volume size to boost up disk throughput to improve the duration of HANA startup, Data Loading, System Migration, S/4 Conversion, Import/Export, Backup/ Restore, eliminate system standstill/ performance issue during critical workload (month end processing, high volume of change activities, etc) that could possibly caused by long savepoint duration due to disk I/O bottlenecks and etc. Once the ad-hoc workload is completed, the volume can be scaled to a size in uptime that fits your HANA DB size and meets the HANA disk KPIs during normal operation to save some unnecessary cost.

Tuesday, 27 April 2021

Planning UAT across SAP S/4HANA and SAP IBP: 5 Lessons from the Real World

SAP implementation project delivery is heavy lifting, when you look to implement S/4HANA or SAP IBP full suite just by itself. It’s order of magnitude more complex when you need to implement S/4HANA and IBP full suite together in a greenfield environment. This is even more so, if you are looking to implement IBP Order Based Planning along with S/4HANA against complex business requirements, such as configurable products.

I would like to share lessons learned in planning User Acceptance Test UAT across S/4HANA and IBP. Learn how to plan when you have common testers across S/4 and IBP – how to mitigate the bottleneck risk, how to develop a test plan for a highly complex solution, and how to balance the conflicting needs of Business Teams vs. IT/PMO teams when it comes to substance vs. schedule.

Monday, 26 April 2021

Querying ABAP CDS views from an ArcGIS HANA tenant

More and more of our customers that run SAP ERP and ArcGIS Enterprise are knocking down silos between GIS and transactional data by referencing their transactional data from ArcGIS Enterprise. This is made possible by putting an ArcGIS geodatabase on HANA or HANA Cloud and using HANA’s Smart Data Access (SDA) to query the transactional data on the fly.

Another key component that makes this possible is a sync framework which captures the transactional asset ID and saves it as an attribute in the corresponding ArcGIS feature class. For example, the SAP Object ID for a power pole is stored in the corresponding feature in the power pole feature class (a “foreign key relationship”). The same process plays out on the SAP side where the geometry ID of a feature in an ArcGIS feature class is stored as an attribute of the asset in SAP ERP. SAP’s Geographical Enablement Framework (GEF) relies on the sync framework to make sure that assets in SAP have corresponding geometries in ArcGIS Enterprise and vice-versa. The GEF enabled Plant Maintenance module enables Plant Maintenance workers to do their work on a map. RE-FX and Project Management can be enabled with GEF as an engineered service. Remember that GEF is for the users of these ERP modules, but what about everyone else in the enterprise?

Tuesday, 20 April 2021

BAdI Implementation in ABAP on HANA for BW Extractors

Introduction:

BAdI Enhancement for BW Extractors in S/4 HANA system.

The Logic for the enhancement of BW datasource is traditionally written in ABAP Function Module Exit or ABAP BAdI. But, now with S/4 HANA, BAdI is the default place to write the logic for Enhancement (Function Module Exit is still available but might not be going forward).

With S/4 HANA we have a flexibility to write logic in HANA Optimized ABAP code using new coding techniques (New Open SQL syntax).

Friday, 16 April 2021

Enabling cold store data access using view for external access (The ‘8’ View) for aDSOs in BW reports with mixed modelling scenario

As promised in my earlier blog post, in this article I will be explaining the possibilities of using the view for external access or the external SAP HANA SQL view for aDSOs or the generated ‘8’ view of aDSOs. The main idea is to gain optimum performance avoiding unnecessary access to cold storage when only Hot data is requested. For details about the ‘8’ view please have a look into the above mentioned blog post link.

For this illustration, I will use the same aDSO used for the earlier blog post : SALESADSO, which has some sample sales data for calendar year 2019 & 2020. Executing suitable DTO rule, I have moved all the data residing in partitions covering calendar year 2019 to external cold storage (IQ). So, the view for external access for the aDSO : /BIC/ASALESADSO8, has the COLD_STORE_FLAG column populated as : ‘X’ for all data belonging to year 2019 & ‘ ‘ for all data belonging to year 2020.

Wednesday, 14 April 2021

View for external Access (The ‘8’ View) for aDSOs in BW/4HANA 2.0 Mixed modelling

In this blog post, I would focus on some of the key aspects of the generated view for external access  or the external SAP HANA SQL View for aDSOs in BW/4HANA 2.0 by a use case scenario. The view is generated with naming convention as following : /BIC (namespace)/A<technical name of the aDSO>8.

We are all well familiar with the below generated tables of aDSOs : (depending on the type of particular aDSO they are relevant)

/BIC/A<technical name of the aDSO>1 : Inbound Table for aDSO.

/BIC/A<technical name of the aDSO>2 : Active Data Table for aDSO.

/BIC/A<technical name of the aDSO>3 : Change Log Table for aDSO.

Tuesday, 13 April 2021

SAP S/4HANA Business Partner Toolset (BDT) at Business Partner

This blog is relevant for all releases working with Business Partner, meaning ECC 6.0 onwards. Main focus is SAP S/4HANAon-premise and private cloud edition, which is the most relevant working with Business Partner.

Introduction

What is the BDT?

BDT stands for “Business Data Toolset” and is a central tool for maintaining master data and simple transactional data. In this context I will focus on Business Partner transaction and Business Partner Relationship.

Monday, 12 April 2021

Hands-On Tutorial: Leverage SAP HANA Machine Learning in the Cloud through the Predictive Analysis Library

The hard truth is that many machine learning projects fail to get set into production. It takes time and real effort to move from a machine learning model to a real business application. This is due to many different reasons, for example:

1. Limited data access

2. Poor data quality

3. Small computing power

4. No version control

Friday, 9 April 2021

Partitioning Data Volumes for HANA DB performance improvement

Partitioning Data Volumes

Below is a simple question and answer format to understand the usage of data volume partitioning ,how it helps in improving over all HANA DB read and write performance and how this is different from data volume striping

1. What is data volume partitioning? How does it add performance advantage over default setup? Since when it is available?

Data volumes on the Indexserver can be partitioned so that read and write operations can run in parallel with increased data throughput. Also, the HANA startup time will benefit from this feature because the data throughput will increase massively, depending on the number and performance of the additional disks or volumes

Wednesday, 7 April 2021

How to use a REST API to post data into SAP S/4HANA Cloud using SAP RPA 2.0

Introduction

With the desktop studio application, developers are free to create custom RPA bots which simplifies days to day tasks by reducing human intervention. With RPA 2.0 and its Low-Code approach, I will show you how to leverage the SAP Intelligent RPA Cloud Studio to create the API call.

I will be using the supplier invoice creation API which can be accessed via activating the Communication Arrangement SAP_COM_0057 in the SAP S/4HANA Cloud system.

Monday, 5 April 2021

How to sizing SAP S/4HANA Conversion

This Blog was made to help customers prepare the SAP S/4HANA landscape conversion considering the sizing relevant KPI’s for the key performance indicators.

There are many perspectives that we need to consider when doing this planning. The sizing procedure helps customers to determine the correct resources required by an application within customer’s business context.

From the customer perspective, sizing is the translation of business requirements into hardware requirements, but from the development point of view, sizing refers to the creation of a sizing model for the product functionality with a reasonable number of input parameters and assumptions.

Wednesday, 31 March 2021

Using Table Functions in SAP HANA for custom calendars

It is a common case that every company have different projects and some of them needs custom calendar implementation for their project. A default approach would be to create a persistent table and populate it with the required custom calendar data. But, this will need continuous maintenance/Updates as the years pass through.  Also, it might need some type of procedure or data procurement methods to populate the data.

This one is particularly interesting as this approach eradicates the need for continuous maintenance or update of calendar tables. neither will it be based on a persistent table. I will move on in explaining the approach using an example.

Tuesday, 30 March 2021

Generation of QR code in SAP S/4 HANA

Significance of QR code in SAP industry

Nowadays QR codes are everywhere, from products to websites and their marketing. Many businesses and applications have increased the use of QR readers and scanners. Smartphones and tabs come with built-in QR readers these days. Unlike barcodes which are vertical stripes, QR codes are made up of square-shaped patterns. Barcodes are read in one direction from top to bottom hence only a small amount of information can be stored. QR codes are read in two directions which makes it two -dimensional from top to bottom and right to left. This means it can store more data. When compared to bar codes, QR codes are protected against duplication and less error-prone. Consumer-facing marketing campaigns have increased usage as smartphones and tabs with digital cameras can easily read and interpret using this technology. It is also because of the major advantage of QR code that it can be scanned from both papers and from a screen, unlike barcode which can be only scanned from paper.

Monday, 29 March 2021

Blending Models with SAP Analytics Cloud

What is Blending?

Blending models lets you join a primary data source (such as ‘travel expenses’) with secondary data sources (such as ‘employee headcount’) that contain common linked dimensions (such as ’employee’). A new model is not created when you blend models, and the original models are not modified. Links between models that are blended only occur within a story. Blending can be done within individual tables and charts.

Some common uses for blending

◉ Comparing data of actuals from a corporate SAP source with plans stored from a non-SAP source.

◉ Comparing sales results against market benchmarks, or marketing campaign results available in .csv files, or data provided by a 3rd party consulting firm.

◉ Creating custom calculations based on key performance indicators from different data models like public census data.

◉ Using Smart Predict to output predictions in a dataset, and blend these predictions with other data sources, in the context of a story.

Friday, 26 March 2021

Run Modes of SAP BW Streaming Process Chains

This blog post will focus on the streaming process chain run modes and provides URLs to additional sources in the end. I use the general term “SAP BW” which refers to both SAP BW 7.5 and SAP BW/4HANA (any release).

In general, acquiring data as fast as possible should not be regarded as first choice. Instead, SAP recommends leveraging virtualization and data federation wherever possible. In combination with SAP HANA, BW provides multiple suitable modeling options, mainly based on SAP HANA integration services (SDA, SDI), SAP HANA modeling options (Calculation Views), and Open ODS Views or CompositeProviders as virtual InfoProviders on the BW application side.

Wednesday, 24 March 2021

Connect Client systems to the “Solution Manager”: Easier, faster and better – Via Outside Discovery with saphostctrl

Introduction

Why should I configure the hostagent, secure and with Outside Discovery enabled?

Because it is easy and It only takes a little to connect correctly the satellite systems to the LMDB with all data suppliers.

And least but not last: to get better Landscape Data in your LMDB to make better Upgrades! (see further Information, at the bottom)

Tuesday, 23 March 2021

Overview of SAP HANA Operators in SAP Data Intelligence

Prerequisite

Your SAP HANA database must be connected to your DI system via the connection management of DI.

1. Standard SAP HANA Operators in DI

The following section lists standard operators for integration with SAP HANA. The list is based on the categories in which the operators are grouped in DI. The focus is on the categories “Connectivity” and “SAP HANA“, as these are probably the most relevant for newcomer scenarios.

Monday, 22 March 2021

7 Reasons to Run SAP HANA on Azure

SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career

There is a growing trend to migrate SAP HANA databases to the cloud. In particular, many users are preferring Microsoft Azure, due to its strong security and compliance features, and its tight integration with SAP solutions. Azure provides a Tailored Datacenter Integration (TDI) capable of running heavy-duty SAP workloads, and also provides a range of VM sizes certified to run SAP HANA and other SAP applications.

Saturday, 20 March 2021

Connect from SAP HANA Cloud trial to SAP HANA, express edition, in AWS via the Cloud Connector

My case

…was slightly different. I have a few instances of SAP HANA, express edition, deployed to cloud vendors. Let’s focus on the one example, where it is deployed to Amazon Web Services (AWS).

SAP HANA Cloud, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Preparation

Friday, 19 March 2021

SAP XSA: Basics and how to create synonyms

Making applications for SAP in the past, has always been rooted in proprietary tools and frameworks. However, with the onset of the “cloud” movement, SAP is providing its customers and developers, a completely new services-oriented application model, that leverages containers and the latest open source standards, for cloud-based applications.

More Info: C_HANAIMP_16 Certification

Developers have been able to provide web-based SAP applications, through the use of WebDynpro for a long time. However, that came with its own set of drawbacks. Newer alternatives now use Fiori-based UI, with an OData service from the backend, that transports data back and forth. This approach provides us with ample amount of flexibility on the UI side, but for the backend, we are still dependent on ABAP and the NetWeaver application server, to execute the business and processing logic for us and the database server to perform queries and send data to the Netweaver AS. We also know this as the SAP R3 architecture, where we divide things into the presentation layer, application layer and the database layer.

Thursday, 18 March 2021

Visualise HANA Spatial Clusters with an SAC Choropleth Map

In this blogpost I will describe how you can use the SAP Analytics Cloud choropleth layers to visualise HANA spatial clusters, such as grid, k-means or hexagons.

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career

With that in place the steps are pretty easy

1. Create database view (or table) to encapsulate spatial clustering
2. Expose database view as Dimension Calculation View
3. Update SAC Custom Regions Metadata
4. Visualise with SAP Analytics Cloud
5. Other Possibilities, Voronoi Regions

1. Create database view (or table) to encapsulate spatial clustering


The spatial clustering require spatial data with an ST_POINT datatype, this can be calculated from longitude and latitude if necessary.

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 1.1: Database Explorer data preview

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 1.2: Database view with Hexagon Clustering

VIEW "view::LAD_2019_HEX15" AS
    SELECT COUNT(*) AS LAD_COUNT, ST_ClusterID() AS ID, ST_ClusterCell() AS SHAPE_HEX 
    FROM LAD2019_ST
    GROUP CLUSTER BY ST_POINT USING HEXAGON X CELLS 15

2. Expose database view as Dimension Calculation View


SAP Analytics Cloud requires a dimensional calculation view with 4 fields exposed

◉ NAME
◉ ID
◉ SHAPE
◉ IS_LEAF

The output of the Calculation view should contain these fields.  ID and IS_LEAF are required as column names

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 2.1 Calculation View

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 2.2: Data Preview

3. Update SAC Custom Regions Metadata


You need to update the metadata to tell SAC that a new choropleth layer is available.

INSERT INTO "SAP_FPA_SPATIAL_CUSTOM_REGIONS"."sap.fpa.services.spatial::custom_hierarchy.CHOROPLETH_CUSTOM_HIERARCHY" VALUES (
'Hexagons', 5, 'CLUSTER_NAME', 'name', 13, 1, 'Hexagons 15', 'SHAPE_HEX', 'cv::ENGLAND_HEX_15', '', 'COVID', '0');

SELECT * FROM "SAP_FPA_SPATIAL_CUSTOM_REGIONS"."sap.fpa.services.spatial::custom_hierarchy.CHOROPLETH_CUSTOM_HIERARCHY";

You can check the metadata looks as expected

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 3.1: Preview SAC Custom Spatial Regions

4. Visualise with SAP Analytics Cloud


Within SAC you can create a Geo Map with a Choropleth / Drill Layer and you should see the newly exposed view as a hierarchy.

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 4.1: Create Choropleth / Drill Layer

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 4.2: Hexagon Spatial Clustering in SAP Analytics Cloud

5. Other Possibilities, Voronoi Regions


Using exactly the same techniques you can access other spatial techniques such as Voronoi regions, as suggested by a colleague James Giffin Voronoi regions/cells sound more like a beer or wine to me, makes for an interesting visual.

VIEW "view::LAD_VORONOI" AS
SELECT "objectid" AS ID, "lad19nm" AS NAME, ST_VoronoiCell(ST_POINT, -1.0) OVER () AS VORONOI_SHAPE FROM "LAD2019_ST"

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Guides, SAP HANA Career
Figure 5: Voronoi Cells / Regions

Source: sap.com

Wednesday, 17 March 2021

Real-time Replication task using SAP Business Application Studio

SAP Business Application Studio is a comprehensive browser-based IDE available on SAP Business Technology Platform for the development of complex applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models.

Designed to support developers who use SAP HANA, SAP Business Application Studio provides various tools, such as syntax-aware editors for code and SAP HANA artifacts, and calculation views, as well as inspection, testing, and debugging tools.

Monday, 15 March 2021

Saturday, 13 March 2021

BW4 + HANA (Hybrid) Modeling Optimization Steps

Basic rule of thumb on any system development of a 2 tier architecture, is that complex formula or logic be push down to the Database rather than the application layer. As Databases are designed to handle more complex formulas. In the SAP environment this was commonly practiced in ABAP programming but not in the Legacy BW (none HANA). As most BW report logics were ran in the application layer and high complex computation were processed in BW’s ETL. BW Developers didn’t have the option to run their report logics directly on the Database & was reliant on BW modeling. This caused a lot of performance issues & Data redundancy in the past.

Friday, 12 March 2021

SAP HANA Calculation View Union Node Data Pruning – Using MATDOCOIL, MATDOCOIL_INDEX Tables Example.

Introduction:

I am working for a customer and their business is mainly in the oil and gas industry. As you may be aware of SAP’s solution IS-Oil (Industry Specific – oil & gas) is tailor-made for the oil and gas industry. With the emerging of S/4HANA many-core module database tables have been re-designed or new tables are made available for simplicity, redundancy, and performance reasons. So, we are going to take an example based on two important tables which are MATDOCOIL and MATDOCOIL_INDEX.

MATDOCOIL: It is a standard SAP Transparent table in SAP IS-Oil application, which mainly contains additional converted quantities, unit of measures, and Quantity conversion parameters. Up to 60 additional quantities (ADQNTP*) and unit of measure (MSEHI*) can be stored into separate table columns.

Wednesday, 10 March 2021

SAP HANA tool for CSV exports from Oracle

Overview

Recently, one of my customer’s had an interesting data movement problem. They needed to extract 150+ tables from a traditional RDBMS, with some tables having 500M+ rows, and move those tables to an SAP HANA instance. This would seem to be a straightforward exercise, but there were some gotchas:

1. The volume of the data was large and the network bandwidth between the servers was restricted due to WAN limitations.

2. The goal was to move and import all the data into their SAP HANA instance in less than one hour.

3. The only open ports between the two servers was for SSH (port 22), and this could not be changed due to security policies.

Monday, 8 March 2021

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

Saturday, 6 March 2021

Building Workflow Analytical Report

This blog post helps you to create an analytical report based on your chosen parameters . Additionally, this blog also shows you how to generate workflow reports based on the average time taken by each approver to approve a workflow item.

Users with role: Analytics Specialist can create such analytical reports.

Following is a broad overview of the major steps involved :

1. Create Custom CDS Views (App: Custom CDS Views)

◉ CDS-Views provide the necessary data for the analytical queries

2. Create Custom Analytical Query (App: Custom Analytical Query)

◉ Analytical queries define the design of the actual application

Friday, 5 March 2021

U4A IDE Platform – An Introduction

Getting explored with U4A IDE Platform 

What is the U4A IDE Platform? 

U4A IDE Platform is UI/UX IDE toolkit which has a function as an easy -to-develop UI5 application by ABAP developer. In addition, It’s called ‘UI5 for ABAP’, in short: ‘U4A’.

The U4A IDE Platform provides a combined development environment of SAPUI5, increasing ease of use, and ABAP Technology alone enables the implementation of from Application to Web UI.

Then, what’s difference with SAPUI5, and why should i recommend to use ‘U4A IDE Platform’ instead of SAPUI5?

Thursday, 4 March 2021

Activation of Planning Bundle /ERP/SFIN_PLANNING for Cost Center – Plan/Actual App in S/4 HANA

Introduction :

To use Cost Center – Plan/Actual App we need to activate SAP BPC optimized for S/4HANA Finance and Embedded BW. In this blog we will see how to activate the planning bundle to use Cost Center – Plan/Actual app.

Problem :

The steps in solution section can be followed to activate the planning bundle.

We face many issues after activating the Cost Center – Plan/Actual app like :

◉ Could not instantiate data source “DS_1” for query “/ERP/SFIN_M01_Q2001

◉ Query /ERP/SFIN_M01_Q2001 is unknown

◉ Cannot activate BEX query /ERP/SFIN_M01_Q2001

Wednesday, 3 March 2021

Redirected restores PROD>QAS for SAP HANA tenant. Step-by-Step guide

Overview.

Consider a common problem in S/4HANA. By mistake users or functional consultants clear a portion of data in a production system. Bussines continue works in the ERP-system and a lot of new transactional data was generated (for example new sales orders, etc). So you can’t restore a production system from a backup.

This step-by-step guide can help you resolve this typical situation.

Monday, 1 March 2021

Backup and Recovery of SAP HANA Database on Azure using Azure Backup Plugin for HANA – Part III

This is in continuation of my previous blog post Backup and Recovery of SAP HANA Database on Azure using Azure Backup Plugin for HANA – Part II


5. SAP HANA RESTORE

To restore, below permission is required:

◉ Backup Operator permissions in the vault where restore needs to be done.

◉ Contributor (write) access to the source VM that’s backed up.

◉ Contributor (write) access to the target VM:

     ◉ If restoration is happening to the same VM, this is the source VM.

     ◉ If restoration is happening on an alternate location, this is the new target VM.

Friday, 26 February 2021

Backup and Recovery of SAP HANA Database on Azure using Azure Backup Plugin for HANA – Part II

This is in continuation of my previous blog post Backup and Recovery of SAP HANA Database on Azure using Azure Backup Plugin for HANA – Part I

3. CONFIGRUATIONS

3.1 Discovery of Databases

After running the pre-registration script, we need to go to the Azure portal → Recovery Service Vault → + Backup