Friday 29 November 2019

ABAP Tool for receiving automated e-mails for SAP HANA Alerts


You want to receive automated e-mails for the currently active SAP HANA Alerts. These e-mails should be triggered by an ABAP program and the SAP Job scheduler (transaction SM36).

For this purpose, we have developed a little standalone ABAP program with the name RSHDB_SEND_ALERTS_BY_MAIL. This program sends automated emails with the currently active SAP HANA Alerts. Additionally, the program allows to restrict the alerts by the Rating and the Alert ID.

Thursday 28 November 2019

SAP HANA Flat File Upload

In this post, I would like to explain data upload to SAP HANA. SAP HANA support uploading data from a file. SAP HANA Support the following type of files,

.CSV (Comma Separated value files)

Wednesday 27 November 2019

Open Source GIS with SAP HANA


SAP’s in-memory database SAP HANA features a geospatial engine, which makes SAP HANA a predestinated storage for geospatial vector data. Once data is residing in SAP HANA developers can leverage the power of HANA’s multi-model engines (e.g. graph and json document store) as well as the advanced analytics capabilities and embedded machine learning (e.g. PAL, APL, EML).

Monday 25 November 2019

MRP Planning #2

This is in Continuation of my Previous Blog MRP Planning 

So in this Blog will see about

Planning with MRP areas

Multi-plant/site planning

Requirements grouping for individual project planning

Saturday 23 November 2019

MRP Planning Process

In this blog will try to Explore different Planning Process used for Full filling Business Needs.

We use special planning processes, for below reasons

◉ if we do not want to plan on a plant level, but either on a multi-plant levelor only for a part of a plant

◉ if we want to work with special procurement types.

Friday 22 November 2019

Get Started with Data Modeling in SAP Data Warehouse Cloud


Before we start our tour into SAP Data Warehouse Cloud world, I’d like to mention, that all content here was written based on the Beta Version of SAP Data Warehouse Cloud. Software settings, coding and/or code snippets are examples. They are not for productive use. This blog post is only intended to better explain and visualize new functionalities in SAP Data Warehouse Cloud.

Wednesday 20 November 2019

Sandbox system via Homogenous System Copy (SAP HANA-specific: Backup/Restore) step-by-step guide


SAP system landscape is defined as an layout of SAP servers. Basically SAP environment consist a three-system landscape paradigm. A system landscape consists of Development Server (DEV), Quality Assurance server (QAS) and Production Server (PROD) Over time, you begin to understand that for experiments you need another independenty system – Sandbox (SAND).

Friday 15 November 2019

SAP HANA Data Strategy: HANA Data Modeling a Detailed Overview

Why talk about HANA Data Modeling?

HANA data modeling is what drives real-time analytics while lowering the total cost of ownership (TCO) and time to deliver (TDL) business insights using SAP HANA digital business platform.

Thursday 14 November 2019

Wednesday 13 November 2019

Friday 8 November 2019

MRP Live on SAP S/4 HANA

In this blog will see some of the important things we need to see when we are suggesting MRP Live to your Clients.

There is Myth / negative opinions, as well as many of us, are not suggesting MRP Live to Clients because of earlier in 1511 versions there are some bugs and limitations but MRP Live has evolved year by year and now with 1809 onwards MRP Live is Stable and Runs without any issues.

Wednesday 6 November 2019

Simple Linear Regression Python enjoy….

Once again I am writing this because of the motivation i am receiving from one of the most important course running @openSAP Introduction to Statistics and i am sure many of us are the active participant of that ,this resulted in writing this stuff on linear regression.

Regression: In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships between a dependent variable and one or more independent variables. Wikipedia

Tuesday 5 November 2019

How to Optimize BPC Model in SAP BPC 11, version for SAP BW/4HANA

In this blog, I will briefly describe you how to create a data manager package to achieve this. In the end, user could trigger this package no different to what he can do in older BPC release.

1. Create a BW Process Chain for BPC Model

a) Goto tcode RSPC in SAPGui, and create a new Process Chain.

b) Create a step with process type ADSOREM

Monday 4 November 2019

Data loads to SAP HANA DB using SAP DS (Data Services)

SAP Data services:

SAP Data services is an ETL tool which gives a single enterprise level solution for data Integration, Transformation, Data quality, Data profiling and Text data processing from different source systems into a target DB.

Saturday 2 November 2019

What’s different in SAP Sales and Distribution (SD) in S/4 HANA

If your knowledge of SAP’s S/4 HANA only came from attending Sapphire, or reading the company’s marketing materials you might think that it was old news. After all, the product launched four years ago and has been pitched so hard since that surely by now every SAP customer must have not only drunk the Kool-Aid dry but also signed up and finished implementing it. But outside of the Orlando conference center spin zone, businesses need more than trade show hype to jump at the latest bright and shiny object. Business cases must be made, budgets approved, and projects scheduled, all of which take time. Lot’s of time.

Friday 1 November 2019

How to support both MySQL and SAP HANA during development phase

Have you ever experienced a project that require support both MySQL and SAP HANA during the development phase.

In this blog post, I’d like to share my experience of how to support MySQL and SAP HANA during the development phase.

If We want to develop applications that support both MySQL and SAP HANA at the same time. We have to find the difference between them.