Saturday, 28 May 2022

Extending business processes with product footprints using the Key User Extensibility in SAP S/4HANA

With SAP Product Footprint Management, SAP provides a solution, giving customers transparency on their product footprints, as well as visibility into the end-to-end business processes and supply chains. 

SAP S/4HANA comes with the Key User Extensibility concept, which is available both in the cloud and on-premise versions.

Key User Extensibility, together with product footprints calculated in SAP Product Footprint Management, enables customers to enrich end-to-end business processes with sustainability information, helping to implement the “green line” in the sustainable enterprise. With Key User Extensibility, this can be achieved immediately, as the extension of the business processes can be introduced right away, by customers and partners, during an implementation project.

Friday, 27 May 2022

Configuration of Fiori User/Web Assistant with/without Web Dispatcher for S/4 HANA On-Premise System

Overview –

The Web Assistant provides context-sensitive in-app help and is an essential part of the user experience in SAP cloud applications. It displays as an overlay on top of the current application.

You can use the Web Assistant to provide two forms of in-app help in SAP Fiori apps:

◉ Context help: Context-sensitive help for specific UI elements.

◉ Guided tours: Step-by-step assistance to lead users through a process.

Wednesday, 25 May 2022

Migration Cockpit App Step by Step

Migration Cockpit is a S/4HANA app that replaces LTMC from version 2020 (OP).

This is a powerful data migration tool included in the S/4HANA license and it delivers preconfigured content with automated mapping between source and target, this means that if your need matches the migration objects available, you do not have to build a tool from the scratch, it is all ready to use, reducing the effort of your data load team.

Migration Cockpit App, SAP HANA, SAP HANA Exam Prep, SAP HANA Exam, SAP HANA Preparation, SAP HANA Certification, SAP HANA Career, SAP HANA Jobs, SAP HANA News, SAP HANA Prep
Migration Cockpit Illustration by SAP

Monday, 23 May 2022

LO Data source enhancement using SAPI

In this blog we will discuss about LO Data source enhancement using SAPI. The scenario is same.

For a Particular Order we need to have material Status and other fields in our data flow for which Material Number is available in our datasource 2LIS_04_P_MATNR.

But before going to the implementation I want to discuss about the enhancement framework architecture which given below –

BW (SAP Business Warehouse), SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs

It is better and good practice to enhance i.e. append to communication structure instead of directly appending extract structure. It will increase the scope for reusability.

Sunday, 22 May 2022

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.

Friday, 20 May 2022

Data driven engineering change process drives Industry 4.0

We are “Bandleaders for the Process.” Our mission is to orchestrate plant operation, with leadership across the manufacturing value chain. This reminds me of my job in the plant 20 years ago.

One important mission was to manage engineering change; it required a lot of time and attention to plan, direct, control and track all the activities across the team with multiple files and paper documents:

◉ What is the impact of change?

◉ When will the new parts come from the suppliers? How many old parts do we have in stock?

◉ Which production order should be changed? What is the status of production orders?

◉ Are new tools ready? Have all of build package documents been revised?

Wednesday, 18 May 2022

Rise with SAP: Tenancy Models with SAP Cloud Services

Introduction

Transitioning to Rise with SAP cloud services, SAP customers have a choice of opting for either single tenanted or multi-tenanted landscape. The choice of tenancy model largely depends on the evaluation of risk, type of industry, classification of data, security, sectorial and data privacy regulations. Other considerations include performance, reliability, shared security governance, migration, cost, and connectivity. While customer data is always isolated and segregated between tenants, the level of isolation is a paramount consideration in choosing a Tenancy Model.

In this blog, we will cover tenancy models available under Rise with SAP cloud services and explore nuanced differences and some of the consideration for choosing each of the tenancy models.

Monday, 16 May 2022

SAP HANA, express edition and SFLIGHT demo database, modeling – Complete Tutorial

Task

Try the SAP HANA Modeling functions and possibilities with the SFLIGHT demo database.

Reason of the Article

To illustrate the process by a concrete example based on the SFLIGHT database. During the process there are many additional steps and setups are necessary. There are also some helpful documentation is available, which can be used during the process. I am trying to collect these information also inside this post. Also, this is a step-by-step guide which goes through the process.

Definitions

SFLIGHT is a sample database. Official documentation can be found here: Flight Model

Saturday, 14 May 2022

APL Time Series Forecast using a Segmented Measure

The latest release of the Automated Predictive Library (APL) introduces the capability to build several time series models at once from a segmented measure like Sales by Store for example or Profit by Product. No need any more to define a loop in your SQL code or Python code. Just tell APL what column represents the segment in your dataset. You can also specify how many HANA tasks to run in parallel for a faster execution.

This new capability requires HANA ML 2.13 and APL 2209.

Let’s see how it works in Python and then in SQL.

Friday, 13 May 2022

Setup SAP HANA XS with HTTPS

When you install SAP HANA 2.0, SSL certificate in PSE store is self-signed. In order to allow for signed SSL HTTP connections with SAP HANA, we need to replace default self-signed certificate with a new one signed by a CA of your choice.

Steps

1. Go to below URL

https://FQDN:4300/sap/hana/xs/wdisp/admin/public/default.html

2. Open the tree of SSL and Trust configuration, Click on PSE Management

Wednesday, 11 May 2022

Running hdbcli on an Apple M1 chip: an alternative way with using arch command

A look at arch command

I tried an alternative approach, that I would like to share here. It does not involve making a copy of the terminal application, but instead using arch command.

As man arch explains:

By default, the operating system will select the architecture that most closely matches the processor type. … The arch command can be used to alter the operating system’s normal selection order.

The arch command with no arguments, displays the machine’s architecture type.

Friday, 6 May 2022

Understanding the Configuration of SAP HANA NSE

This blog is intended to provide some more understanding about SAP HANA NSE and its configuration.

Design Principles of NSE

SAP HANA NSE adds a seamlessly integrated disk-based processing extension to SAP HANA’s in-memory column store by offering a large spectrum of data sizes for an improved cost-to-performance ratio. It manages data without fully loading it into memory. This offers the ability for processing in-memory stored data for performance critical operations (hot data) and NSE-managed data for less frequent accesses (warm data).

Monday, 2 May 2022

HDI, get objects details

Introduction

When working with HANA Repository, you may be used to query the table “_SYS_REPO”.”ACTIVE_OBJECT” to get details about design-time objects.

With HDI, the same information is now split by containers and you have to query 2 objects:

◉ the view M_OBJECTS

◉ the procedure READ_DEPLOYED

For some use cases, it would be convenient to be able to query all HDI containers at once and get information from M_OBJECTS and READ_DEPLOYED at the same time.

Friday, 29 April 2022

Implementing SAP S/4HANA with SAP Activate: Best Practices

There’s a tradeoff in SAP implementation that forces users to choose between standardization and customization. SAP S/4HANA focuses on standardization while still trying to support integration from third-party providers. By standardizing the processes within SAP S/4HANA and extending that standardization to third-party add-ons, the software suite makes it easier and faster to adopt cloud innovations as they become available. Experts in the field refer to this thinking as a “cloud mindset.” It’s also colloquially termed “keeping the core clean,” meaning that their interaction with third-party plugins does not taint the core services. SAP Activate was developed to help businesses keep their core clean and create a cloud mindset for their SAP installations. Industry best practices for this process follow, underlining SAP Activate’s approach to keeping the core clean.

Thursday, 28 April 2022

Serial Number Management in SAP S/4HANA Cloud

You can use serial number management in SAP S/4HANA Cloud Warehouse Management to identify and track individual products in your warehouse, from goods receipt to goods issue. For products with serial numbers, it is easy to track, even retrospectively, on which date it was delivered from which supplier, who performed the quality inspection, who moved this product, when this was done, and when it was packed and sent to the customer.

A serial number is a series of characters that have been assigned to each product in the warehouse so that it remains separate and are identified in the warehouse system. You can use serial numbers up to a length of 18 characters in an SAP ERP system.

Wednesday, 27 April 2022

SAP S/4HANA Embedded Analytics: An Overview

In this blog post I will discuss the overview of SAP S/4HANA Embedded Analytics which  is one of the key innovations of S/4. It is a collection of SAP Fiori tiles in SAP S/4HANA that enable real time operational reporting in your transactional system. There is no ETL (Data Extraction, Transformation, and Loading) and batch processing required, compared to traditional reporting landscapes involving ERP and data warehouse systems. Embedded Analytics uses SAP Fiori as the front-end user interface and SAP has delivered standard content known as Fiori analytical apps for various functional areas. Standard content can be leveraged right out of the box as an accelerator for your implementation and can also be personalized and extended based on business requirements.

Why should I use SAP S/4HANA Embedded Analytics?

◉ Business Innovation through Radical Simplification

◉ Agility and Creativity for the Business

◉ Scale and Trust for the Enterprise

Monday, 25 April 2022

RISE with SAP to transform your business

Introduction

In recent years, business transformation has become a hot issue and a trending topic in the SAP community. Let us dive into this blog post to find more sense on the matter.

What is business transformation?

A business may undergo a transformation for a variety of reasons. They could be the result of new technology, market shifts, low profit and turnover, resulting in cost cutting, or a merger and acquisition. These factors are critical for a company’s success, necessitating a change in the business ecosystem.

Saturday, 23 April 2022

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.

Friday, 22 April 2022

Maintaining business roles in SAP S/4HANA Cloud

Introduction

This blog post describes applicable for S/4HANA Cloud system administrators scenario: during the system implementation it is necessary to create a new business role by the business key user request. In the same time, business key user request includes name of the app, to which it is necessary to set up access, but not the business role name itself. As an example we will take the app “Display Dunning History”.

Identifying business role name

To identify business role name, we will use Fiori apps library. In there we need to to to “All apps for SAP S/4HANA” -> All apps and enter then in search field name of the target app. In our case it is “Display dunning history”:

Wednesday, 20 April 2022

Key and unique building blocks of SCC Multi-Tiered Subcon Collaboration Process

In this blog, I want to share my experience and learnings with multi-tiered subcontracting collaboration process using my apparel client’s example. I will attempt to focus on the unique functional aspects that needs attention during any implementation of this process. Let me start with overview of the business case and the process adopted by business. Later, I will deep dive into the key building blocks and its details.

Business Case and Process adopted with SCC

One of my apparel clients in USA is sourcing garments from China’s manufacturer. A special fabric is used in manufacturing of specific silhouettes of garments. This fabric is sourced from Ethiopian (East Africa) supplier. In this case my client, was looking for drop shipment process for special fabric from Ethiopian supplier to Chinese manufacturer to save transportation time and space in their own warehouse. Chinese manufacturer was provided the visibility of the fabric order via manual spreadsheets and e-mails, so that he can plan the production and subsequent shipments accordingly.

Monday, 18 April 2022

Delivery Time Calculation for Summarized JIT Call with “CYCLE”

Solution Overview

As you know SAP KANBAN solution have provided external procurement function which can issue summarized JIT Call document to suppliers for fulfillment. it is definitely containing delivery date and time in the header information on summarized JIT Call documents, and those can be calculated by SAP standard JIT calculation profile configuration also. but during the solution delivery, you will be facing the “CYCLE” issues which was broadly and deeply operated on Japan automotive OEM and their suppliers who running KANBAN in factory.

Friday, 15 April 2022

Role of Migration Server/Import Server in Brownfield implementation-RISE with SAP, S/4HANA Cloud,private edition

In this blog I wish to discuss about the basic usage of migration server(VM) / Import Server during a brownfield system migration to SAP S/4HANA Cloud,private edition.

Below are the questions that this blog is targeted in addressing.

1. What is a migration server / Import server in RISE with SAP S/4HANA cloud,private edition?

2. What is the configuration of migration/Import server?

3. Why should the customer subscribe for additional storage while using Migration server?

4. How many migration/import server are needed to complete a 3 system landscape migration to SAP S/4HANA Cloud,private edition?

Wednesday, 13 April 2022

DMO: BWoH: From SAP Netweaver BI 7.0 to SAP Netweaver 7.5 BI on HANA {Technical preparation and execution}

Summary of what we achieved: We have recently migrated and upgraded the BW/BI system from Netweaver 7.0 to Netweaver 7.5 using the SAP’s robust tool SUM 2.0’s DMO feature for one of our customer. The database size was nearly 3 terabyte and the resultant HANA database was around 250 Gigabyte.

The existing infrastructure was having database as Oracle 11.2.0.2.0 and Operating System HPUX ia64.

So if anyone is going to work on a similar assignment, can refer to this blog post for insight.

Monday, 11 April 2022

Data preview on Intermediate nodes of a CV in HANA cloud/On-premise

Data preview on intermediate nodes of a calculation view is a regular task while using HANA studio as a development tool. it is useful for debugging/troubleshooting data output at each node level of a CV.

But after migrating to HANA XSA(On-Premise) or HANA cloud(Cloud platform) then you will need to use Web IDE for HANA(On-Premise) or Web IDE fullstack(Cloud) as development tools. Usually, Web IDE is connected to Dev instance and Not to Prod. if you try to connect to Prod, there is a risk of unexpected changes deployed in Prod.

In this situation, if you wanted to do the data preview on a graphical CV in Web IDE, it can only happen in Dev instance. For Production, we will have to implement the firefighter access set up and run SQL to generate data preview on the intermediate nodes.

Friday, 8 April 2022

Deploy Machine Learning/Exploratory Data Analysis Models to SAP Business Technology Platform

DISCLAIMER: Please note that the content of this blog post is for demonstration purpose only, it should not be used productively without impact evaluation on production environment.

Introduction:

In this blog, we will implement an end to end solution for Python based web application(Flask) on SAP Business Technology Platform.

◉ We will use a cloud based HANA DB, and will leverage python package hdbcli to fetch the relevant data using SQL statement.

◉ We will be using python data science packages such as pandas,seaborn and matplotlib to display various graphs showing Exploratory Data Analysis.

Wednesday, 6 April 2022

Some interesting Facts of Compatibility Views in SAP BW/4HANA and SAP S/4HANA

As the name implies, SAP BW/4HANA or SAP S/4HANA are fully integrated with the underlying SAP HANA platform. This also means, that the physical data model changed compared to their predecessor products (for example in FICO area). Some tables are removed, changed or consolidated which makes a lot of sense to leverage the full power of the columnar in-memory concepts of SAP HANA.

In order to facilitate customers´ transformations, SAP has introduced so-called compatibility views to keep some core interfaces running. If a compatibility view is in place for an obsolete table, requests to access that table are redirected to newly introduced table(s) by the help and logic provided in the compatibility view.

Monday, 4 April 2022

Multiclass Classification with APL (Automated Predictive Library)

Common machine learning scenarios such as fraud detection, customer churn, employee flight risk, aim to predict Yes/No outcomes using binary classification models. But sometimes the target to predict has more than just two classes. This is the case of Delivery Timeliness that can have three categories: Early/On-time/Late.

From this article you will learn how to train and apply a multiclass classification model in a Python notebook with HANA ML APL.

The following example was built using HANA ML 2.12.220325 and APL 2209.

Census Income will be our training dataset.

Friday, 1 April 2022

Two simple tips to boost the working efficiency of a Data Science Project

How can we make our daily work more efficient? Is there any straight forward answer? For me, the answer is only one word, experience.

Participating on several Data Science projects the last years, i was really amazed how fast you can confirm the saying “Almost 70-80% of a Data Science project is spent on the Data preparation”. There are two simple tips that will be presented on this blog post regarding the Data preparation process.

The first one is comparing four different ways, that a data scientist in SAP HANA, can create random sample datasets from an initial dataset and which can be their potential usage. The second one is exposing the power of SAP HANA ML on creating and automating a set of new aggregated columns (max(), sum(), avg() for example) from existing columns without the need of writing complex and big SQL queries (feature engineering part).

Wednesday, 30 March 2022

SAP’s Banking Product – SAP Financial Services Data Management and Platform(FSDM/FSDP), SAP Financial Planning Subledger(SAP FPSL) Part 1

SAP’s Banking Product – SAP Financial Services Data Management, Platform(FSDM/FSDP), SAP Financial Planning Subledger(SAP FPSL)

Writing this series of blog post on SAP’s Banking products formerly known as SAP Bank Analyser now known as SAP Financial Planning SubLedger or SAP FPSL. SAP was eagerly working straight after SAP S/4 HANA release to provide banking solutions on it’s flagship product Database i.,e SAP HANA and SAP Application suite ABAP stack on top it.

The main reason of writing this blog post is to showcase the power of SAP’s HANA database and there are less information available except on the SAP’s FSDP official website/Video.

Friday, 25 March 2022

How to Set Up SAP HANA on Azure

SAP HANA deployment on Azure enables companies to evaluate and then run development, test, sandbox, and training environments for different SAP products. Deploying SAP HANA in the cloud enables customers to avoid the traditional path of procuring hardware and then installing SAP. Azure offers benefits like scalability, availability, and cost savings.

Hosting SAP HANA on Azure

SAP HANA is an in-memory Relational Database Management System (RDBMS). SAP HANA uses a solid-state Random Access Memory (RAM) to store data. This functionality improves database performance compared to traditional databases that use persistent storage.

You can run SAP HANA on-premises on your own dedicated hardware, or in a public or private cloud. Launching a SAP HANA certified Virtual Machine (VM) or a bare metal server enables you to run SAP workloads in Azure while optimizing costs

Wednesday, 23 March 2022

S/4HANA Cloud Applications Monitoring with Cloud Integration

Introduction

As my first blog on the SAP Community, I would like to tell you a little story. A few months ago I joined an AMS project and some of my daily tasks involved a twice-a-day monitoring on some SAP Cloud Integration iFlows and a few SAP S/4HANA applications like Message Monitoring, Manage Output Items, etc.

In the beginning I took my time in analyzing the payloads and error sources because there were many scenarios and I could not evaluate them as fast as I can now, but because I got better at doing my job I ran into the need of fetching all the messages with their details in a more efficient way.

Monday, 21 March 2022

Why Do I Prefer Shell Conversion for BW4HANA Migration?

Abstract:


This Blogpost discusses the various migration strategies in fundamental Business and Technical sense.

Disclaimer:


In this blog post, the points that I brought are my own experience and thought process. It may vary from place to place. However, this blog post will give some thought processes to the reader before taking a call on the migration strategy.

Friday, 18 March 2022

HDI: returning multiple deployment errors

Problem:

Working with SAP HANA Cloud and HDI the tooling stopped at the first error and you had to fix them in the sequence the errors where thrown. All this one by one. This can lead to a lot of cycles that are time consuming and do not support the workflow one had in mind.

Solution:

With SAP HANA Cloud March 2022 the HDI can now return the first error it can detect per each “dependency branch”.

Wednesday, 16 March 2022

SAP HANA XS Advanced Administration, Deployment and Operations

Many SAP Customers started using XS Advanced and there were several questions on how to deploy or where to deploy and what are the consideration for choosing any of those approached. Based on my experience with various customers I tried to address some key topics in this blog to consolidate information from various sources of documentations

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:

Sunday, 13 March 2022

The fastest way to load data from HANA Cloud, HANA into HANA Cloud, HANA Data Lake

Overview

Recently as customers are moving larger and larger tables from HANA into HANA Data Lake, I am being asked what the fastest way is to move data from HANA to HANA Data Lake.  Or more precisely I am asked if there is a faster way then doing a simple HANA INSERT into a HANA Data Lake virtual table.

You may be asking why customers are moving large tables from HANA to HANA Data Lake (HDL) and the most popular use case for this is an initial materialization of a large datasets or archiving older data to HDL.  Most of these customers are using HANA Smart Data Integration (SDI) to do this materialization and often using the same interface for change data capture using SDI Flowgraphs or SDI real-time replication to keep these tables up to date.

Monday, 7 March 2022

Preserve and Identify Source Deleted Records in HANA via SLT

Requirement:

Need to preserve S/4HANA table hard-deleted records in Enterprise HANA.

Identify these records in Enterprise HANA by setting IS_DELETED = ‘Y’.

Challenge: SLT Replication by default will ensure that both source and target data records match all the time. This means that even deletion (of record) in the Source will be passed on to the Target system and cause a deletion in Target – to ensure data record count matches exactly between Source and Target tables.

Friday, 4 March 2022

SAP Tech Bytes: SAP HANA / CAP Access Tables from a Different Schema

Introduction

I read on social media about a New Year’s resolution idea: instead of answering questions sent in direct communication, write the response as a blog post and send the requester a link to the post. It sounds like a great idea to better utilize time and share knowledge so I decided to give it a try. Fourteen days into the new year and so far I’ve failed spectacularly. I find when I go to write a blog post I want to provide more background and detail. All this takes more time than you can usually squeeze into the day. This blog post represents my attempt to take at least one question I’ve received and answer via blog post, although admittedly after already responding to the original request.

Wednesday, 2 March 2022

HANA NSE (Native Storage Extension) Data Tiering Options for Utilities

Purpose – An attempt to explain HANA NSE (Native Storage Extension) concepts in simple words for anyone looking to understand this topic. I have also tried to simplify steps used in implementing HANA NSE.

Topics covered –

– Reasons or case to implement HANA NSE.

– Basic concepts of HANA NSE.

– How to find tables/objects which can be candidates for implementing NSE?

– How to use DVM, DBA cockpit, and NSE advisor.

– Examples and links to the documentation provided by SAP.

Friday, 18 February 2022

SAP Analytics Classification algorithm: Predict the potential profits of marketing campaigns

Profiling the client’s attributes that influences the positive response to sales

Classification is one of the Machine Learning algorithms of SAP Analytics cloud to find what are the variables that have more influence to get a positive result.  Based on this information we can calculate what is the maximum profit of a marketing campaign. The algorithm takes past information and evaluates the results to give how good is the data to do predictions.

We are going to train the Classification process with the data of a past marketing campaign to know the possible effectiveness percentage of a campaign based on:

Monday, 14 February 2022

Forecasting Intermittent Time Series with Automated Predictive (APL)

Starting with version 2203 of the Automated Predictive Library (APL) intermittent time series are given a special treatment. When the target value has many zeros, typically when the demand for a product or a service is sporadic, APL will no longer put in competition various forecasting models, but it will systematically use the Single Exponential Smoothing (SES) technique.

For SAP Analytics Cloud users, this functionality is coming with the 2022.Q2 QRC release in May.

Let’s take the following monthly quantity as an example.

Friday, 11 February 2022

Move data FAST from an SAP HANA Cloud database to a HANA Data Lake

If you’ve ever been stuck wondering how you can move data from your SAP HANA Cloud database to your SAP HANA Data Lake with minimal effort, this is for you. In fact, it might be the fastest way to move your data depending on your data lake’s configuration. Plus, it’s simple enough that a single Python function can do all the work for you!

This blog will outline how you can leverage remote servers in the data lake to make a connection to your HANA database and pull the data from HANA to data lake. I also experiment with different data lake configurations to see what parameters affect the speed of this data transfer the most, that way you know how to scale your data lake instance to achieve the best performance.

Thursday, 10 February 2022

Reduce SAP HANA Memory Footprint and TCO of SAP HANA with NSE

Efficient Data Management strategy is important for SAP HANA customers to achieve low TCO (Total cost of ownership) and maintain memory footprint.

SAP HANA Data growth comes with its associated challenges and leave customers in Dilemma about the actionable to manage the growth, TCO and performance as depicted in below graph

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

Wednesday, 9 February 2022

Can data modeling be enhanced by incorporating business knowledge?

If the answer is yes, then in what extent and how?

In this blog post we will try to answer the question by approaching a real-life scenario. We will discuss the challenges related to high amounts of data and the resulting processing times if the access to that data is not optimally planned and the structure of the data is not designed in a proper way. Finally, we will see how business knowledge about the scenario will provide information about the data modelling, which will boost the performance significantly.

Wednesday, 2 February 2022

Presales capability in SAP S/4HANA

Introduction

This blog post provides an overview of SAP S/4HANA On Premise (and PCE) Presales Management features (or Sales Force Support – don’t get confused with a 3rd party “SaleForce” solution).

It is not a secret that SAP S/4HANA architects’ strategic goal is to build a comprehensive core ERP solution which may also contain capabilities from other formerly standalone SAP applications. One of those is CRM functionality coming from the good old SAP CRM 7.0.

Historically, SAP offered its “classic” SAP CRM solution which has been evolving over years from version 3.0 to its final 7.0 EHP4. SAP CRM 7.0 is a part of SAP Business Suite 7 for which SAP is going to provide mainstream maintenance until the end of 2027 with optional extended maintenance until the end of 2030 (according to official announcement made on Feb 04, 2020). However, no major improvements will be delivered for SAP CRM 7.0.

Tuesday, 1 February 2022

External HANA view configuration in BW4HANA

Overview

SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA tools.

This document will provide you an overview of the external HANA view configuration from the SAP BASIS point of view.

Thursday, 27 January 2022

SAP HANA Database Explorer VSCode Extension Getting Started Tips

You might have seen that SAP just recently released the first version of SAP HANA Database Explorer as a Visual Studio Code Extension.  You can get that extension here: SAP HANA Database Explorer – Visual Studio Marketplace

SAP HANA Database, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Certification, SAP HANA Skill, SAP HANA Job, SAP HANA Learn
SAP HANA DB Explorer in VSCode Marketplace

Wednesday, 26 January 2022

7 methods to retrieve the version of SAP executables

During support situations you might often be asked to upgrade the executables of your system (often called kernel) to a current release.

But which version is running in your system?

Here are several methods to determine the version of an SAP executable:

1. Using SAPMMC

2. Using sapcontrol.exe

3. Using Windows Explorer

4. Using Windows Powershell

5. Using command line parameter -version

6. Using transaction SM51

7. Using System – Status

Monday, 24 January 2022

Return to External Supplier Using Advance Return Management in S/4HANA

Introduction

In this blog, the steps outlined for configuring and executing ‘Supplier Advance Return Management process in S/4HANA’. This will help users to configure advance return management and execute, monitor in S/4HANA Environment. The Business user can effectively monitor the complete return process cycle end to end and take corrective measures. The system can be configured as per the business requirement.

Pre-requisite:

◉ Ensure return indicator enabled in the Supplier Master (in the purchasing view) with the indicator “Ret. with shipping proc.”

◉ Create Supplier as Customer for creating a return delivery and link Customer number in the supplier master

◉ Shipping determination Configuration

Friday, 21 January 2022

You used to use SE16/SE16N and SQVI, Try SE16H!

SAP S/4HANA, SAP ERP, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Certification, SAP HANA Guides

As you know, SAP HANA comes with many enhancements and features. The new transaction SE16H comes with new features which enables rapid tables check and small queries.

SAP Consultants used to use the transactions code SE16/SE16N/SQVI to check table’s value and/or extract data.

Thursday, 20 January 2022

Fleet Management – Detail SAP Configuration Steps along with Rationale

Fleet management is very popular in Industry’s where lot of vehicles are used, it is used to track the vehicle usage, fuel consumption etc.

I am trying to explain the detail steps used in Fleet management configuration along with some rationale, I hope the reader can follow these detail steps to understand and configure SAP Fleet Management.

Step 1

SAP Customizing->Plant Maintenance and Customer Service->Master Data in Plant Maintenance and Customer Service -Technical Objects-General Data-Set View Profiles for Technical Objects

Wednesday, 19 January 2022

SAP BTP End-to-End Demo: Integration of Qualtrics

Introduction

In this blog post I will demonstrate how to load Qualtrics Survey Data via a custom SAP Data Intelligence operator into a SAP HANA Cloud table for use in SAP Data Warehouse Cloud and SAP Analytics Cloud. I will show how solutions from unified data and analytics can be used together to get insights from a Qualtrics Survey by going step by step over how to integrate Qualtrics in them creating an End-To-End-Story.

This demo is split in the following parts:

Part 1: Creating a survey in Qualtrics that you can publish to gain valuable insights into customer opinions about a topic you are interested in

Part 2: Loading the survey data into a SAP HANA Cloud Table by creating and using a custom python operator in SAP Data Intelligence

Tuesday, 18 January 2022

Error during execution of HdbCmdClazz ’GET_DEFAULT_DATA_BACKUP_LOCATION’ – SAP Control validating error resolution doc during HANA Refresh via SWPM tool

Background

SAP Control validating error resolution doc during HANA Refresh via SWPM tool. This document is not necessarily having the strategy but also config information too some extent however content can be viewed and leveraged as appropriate. It gives an overview and resolution for sapcontrol validation issue using SWPM tool

Keywords: GET_DEFAULT_DATA_BACKUP_LOCATION, SAP HANA, SYSTEM REFRESH, SWPM Refresh, SAPCONTROL,

Landscape

To demonstrate this configuration, the below landscape is required

Monday, 17 January 2022

Helpful Techniques For Adapting Projects to Operate in a Different Environment (e.g., Move from on Premise to SAP HANA Cloud)

One benefit of using the HANA Deployment Infrastructure (HDI) is that a clear interface exists that lists the dependencies to objects outside of the respective HDI container. With this it becomes pretty simple to adapt a project that should run in a different environment, such as when moving a project that has been developed in an on premise XSA environment with SAP Web IDE for SAP HANA to SAP HANA Cloud.

Below several concepts are illustrated that help to adapt existing projects that refer to objects that are not contained in the project.

The main challenge you will face when moving your project to a different environment is that you cannot rely on resources that are not included in your project. For example, resources might only exist under a different name or schema. The new development concepts of SAP HANA, in particular the deployment with the SAP HANA Deployment Infrastructure (HDI), prepares you for this task by abstracting away dependencies to resources outside of your project. Dependencies in HDI come into your project via mainly two routes:

Wednesday, 12 January 2022

Capture Deleted Records-Using SLT

Context/Background: As we all know using SLT we replicate the records from source system, so as part of the replication, SLT basically perform three actions which are insert, update and delete. So lets consider we have a below scenario, where are replicating records from S4 system to HANA database. This seems to be normal and this is what SLT suppose to do.

But actual problems arrives when you have further downstream system which read data from your HANA database directly. Also, if there is non-sap system which is reading from HANA database, it is difficult to capture deleted records on target, so it goes out of sync if it is not a trigger based solution or stores the data to the flat files.

Monday, 10 January 2022

Finding the right CDS Extractor in SAP S/4HANA

SAP ABAP Core Data Services (CDS) is a core technology for data modeling in SAP S/4HANA. Due to the fact, that S/4HANA cloud edition does not provide the classic ABAP extractors (aka DataSources) for consumption, the clear requirement to set up new extraction options based on this concept has emerged in the last years. As you can see in the numbers below, this area has received tremendous innovation recently.

Number of released CDS extractors in SAP S/4HANA on premise

(Note: the cloud edition reflects the similar evolution with probably even more objects)

– release 2019: ~400 extractors

– release 2020: ~1100 extractors

– release 2021: ~1800 extractors

Friday, 7 January 2022

SAP HANA Monitoring with RybaFish Charts

Standard SAP HANA monitoring tools sometimes require initial configuration or specific setup and this might be a problem when you need quickly jump into the case and check what is happening on the SAP HANA DB side. And this is exactly where RybaFish Charts will help you.

All you need to start using it – just download the tool (no installation required, it is portable) and connect to the database. Within seconds you will be able to check the resource consumption on the database:

SAP HANA Monitoring, RybaFish Charts, SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Preparation, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs
SAP HANA Resource Consumption

Wednesday, 5 January 2022

MDG-BP: Innovations in S/4 HANA 2021

In this blog we will cover some innovations on MDG-BP which has aligned the addresses function more with the S/4HANA business partner.

INTRODUCTION:

Business partner in S/4HANA allows to maintain address specific communication methods in the BP address tab as well as address independent communication methods which allows users to maintain different email ID’s phones numbers apart from the one standard one assigned to the business partner.

MDG till S/4HANA 2020 didn’t have the function to maintain the address independent data, however from S/4HANA 2021 it allows this data maintenance and its under governance scope.

Monday, 3 January 2022

SAP HANA Platform: Fault Tolerance Features & High Availability

Ensuring a rapidly available SAP landscape involves the eliminations of all possible points of failure within the environment. A failure in system availability is very costly and hampers the productivity of the organization. Hence monitoring measures are set in place and alerts notifications are configured to be sent out to responsible operators for any possible threats caused by but not limited to:

◉ Power Failure

◉ Hardware Failure

◉ Network Latency

◉ Data Centers

The sole purpose of Implementing a High Availability SAP HANA system is to ensure a smooth and time effective  recovery strategy from any failures. A fully automated High availability system is a combination of the following: