Automating Username Generation for Employee BP Records mandatory in SAP EHS

In the context of SAP EHS (Environment, Health, and Safety), ensuring that all employees have a unique Business Partner (BP) record is crucial for effective management and compliance. Each employee must have a username to be assigned as part of their BP data, which is essential for proper system integration and user access.

This guide demonstrates how to create an ABAP program that automatically generates usernames for employees. The usernames are derived from the first letter of the employee’s first name and their last name, followed by a numeric suffix to ensure uniqueness if similar usernames already exist. This is particularly useful in the SAP EHS module, where each employee's BP record requires a unique identifier.

Understanding SAP RAP, CAP, Build, Joule, Embedded Analytics: A Simple Guide

Introduction

In the rapidly evolving world of SAP, staying updated with the latest technologies can be challenging. Today, we will simplify five key SAP technologies: SAP RAP, SAP CAP, SAP Build, SAP Joule, and SAP Embedded Analytics. Let’s understand what they are, how they differ, and when to use each one.

SAP RAP (Restful ABAP Programming)

Let’s start with SAP RAP. ABAP has been the backbone of SAP for years, and RAP brings a modern approach to it.

SAP Cloud Transport Management

Introduction

I have experimented a bit with SAP Cloud Transport Management.

The Big Picture

As usual on SAP BTP you have to use a service from the service marketplace to use the SAP Cloud Transport Management. You also have to create a solution landscape on the SAP BTP. 

I designed it as follows:

How to replicate your Fiori Inbox in Microsoft Teams

Using Looply you can replicate your Fiori Inbox in Teams, and it’s fast and easy.

Putting outstanding workitems in the face of those users who are not logged into SAP Work Zone / Fiori LaunchPad / SAPGUI can accelerate processes and lead to a host of other benefits.

We can build the solution in 4 steps.

[1] Consider the trigger points.

You have options. You might run a background job periodically to update Teams. This is easy to set up, but resource-intensive if you decide to run it every few minutes instead of, say, twice per day.

Upload and modify OpenXML documents via RAP App in SAP BTP ABAP Environment

Introduction

In this blog post, I would like to share some insights for generating OpenXML documents by use of the RESTful Application Programming Model with Cloud-released development objects. With this app, you will be able to upload .docx templates and fill them with information from you CDS view (could be used for generating invoices, business documents and so on...).

Prerequisite

• SAP BTP ABAP environment or an S/4 system to your disposal.  
• Eclipse IDE installed on your local machine with the ABAP Development Tools.

Organize and categorize your documentation in SAP Cloud ALM

I want to highlight some important new features of “Documents” that will help you better organize your documentation in SAP Cloud ALM.

Create Process Hierarchy

You might already know about and use the functionality to create your own process hierarchy. You can access this feature from the “Processes” application or by adding the tile to your launchpad.

How to identify the actually used UserInterface Technology from ABAP

I would like to share with you a method I wrote in my last S/4HANA 2022 Assetmanagement Project to identify from ABAP side (Userexit, BADI, Enhancement, ...) the UserInterface (UI) Technology ("WinGUI", "htmlbased GUI", "WebDynpro", "Fiori", ...) the user is currently using.

Adapt Clean Core Principle using SAP Cloud ALM

Introduction:

The main aspect of an ERP systems are:

◉ Business Processes

◉ Extensibility

◉ Data

◉ Integration

◉ Operations

Creating ABAP Dataframes for SAP PAL

Machine learning algorithms often need large datasets for training. E.g. the MNIST dataset consists of 100.000 records. Each record represents a little greyscale image of size 28x28 pixels of a handwritten number and the respective number as integer value ,  i.e. 28x28 =  784 integer values in the range interval [0,255] and one integer value for the number value.

Assume you want to train a neural network in PAL using AMDP (ABAP managed database procedures) in order to predict the number. For this task you could e.g. use the PAL algorithm "Multilayer Perceptron", which is a neural network. In order to supply the input neurons with data a dataframe is needed, i.e. an ABAP-DDIC structure containing the following fields:

Unable to log in to SAP BusinessObjects CMC

We were recently performing regular maintenance, including an OS patching of the SAP BO development server for one of the SoftwareONE customers.

During the patching, some issues were encountered leading to a failure. It was decided to restore the operationability of the application by reverting to the previously backed-up state of the VM back to the patching event, and the Basis team was tasked to bring the application up and do the sanity tests.

The application was able to start but the login to the CMC was denied.

Analytical Query CDS View creation and consumption in RSRT along with publishing OData Services

Introduction

In this blog you will learn about the creation of Query CDS Views for Analytical purpose and their consumption in RSRT tool, along with the required steps that needs to be followed to achieve it. Once after the Analytical query creation, I have tried replicating one of my project scenarios to have better understanding on defining key figures/ measures in CDS views. In the end blog explains about the process needs to be followed to expose the given Query CDS view into OData service links. The Query CDS Views are created specifically for Analytical reporting purposes within SAP systems. They can be optimized for certain reporting scenarios, analytical queries, aggregations and further can be integrated with SAP FIORI tool providing much better visual reporting experience.

Creation of query CDS view:

For the creation of query CDS view we must follow 3 basic steps as mentioned below:

Export the Analytic Application to PDF

Introduction:

We can use the "Export to PDF" component and its script APIs to export an analytic application to a PDF file. By default, the export settings we defined in the Export to PDF panel cannot be modified during the application run time by the users.

In this example, to offer application users the flexibility to customize the export settings, I have designed a new settings dialog by leveraging relevant APIs.

Tip: SAP GUI Scripting VBA Code Snippet to Detect all IDs of the UI Elements

In a few cases it is in business context not allowed to install additional analyze software or tools. So applications that are permissible and available must be used, e.g. like Microsoft Office applications. This makes things a bit more laborious, but not impossible.

Here a Visual Basic for Application (VBA) example to detect all IDs of the UI Elements of a session of the SAP GUI for Windows with SAP GUI Scripting. The result is written into a Microsoft Excel table.

The sub routine Start connects to the session and calls the recursive sub routine GetAll, which detects all IDs. The global variable gColl stores all IDs as an array of strings.

SAP BTP Environments – Cloud Foundry Vs ABAP Vs Kyma

Introduction

Introduced in January 2021, SAP Business Technology Platform (SAP BTP) is a unique and powerful solution offering by SAP. It is the technical foundation of entire SAP ecosystem and plays a crucial role for all SAP customers and partners.

SAP BTP offers 3 major environments – Cloud Foundry, ABAP and Kyma. SAP BTP offers one more environment as well called Neo, which is going to sunset.

SAP Business Workflow – Trigger Workflow Behind Tcode: CJ20N

There was a requirement in a project that the users wants to control project creation with workflow. Project Builder (CJ20N) screen does not have standard workflow process working behind. First of all we need to find the triggering event works behind Project Builder (CJ20N) screen. In my case I need to start workflow process after creating project.

In this blog I will show you how to reach the standard class, events and event parameters to trigger and design a workflow.

Using memoization to optimize pure functions in ABAP

I recently needed to drastically improve performance of a recursive method, and memoization was there to save the day. I’d like to demonstrate the technique, in case you’re not familiar with it, using the recursive Fibonacci sequence as a base.

FAQ:

Q: Was the Fibonacci calculation what I needed to improve performance for?

A: No, but the recursive Fibonacci calculation is a great and simple example that lends very well to memoization demonstration.

Q: Aren’t there better performing ways to calculate the Fibonacci sequence than the recursive method?

A: Well, there are other, but I need somthing “slow” to demonstrate the memoization I have included two other options in the end, for good measure…

ABAP CDS View Where used List – A simple utility

Introduction:

CDS doesn’t need any introduction so let’s get to the core of the topic for which I am writing this blog post.

I was investigating on certain CDS annotations and I was missing something called “where used” option for CDS, this is a feature which we ABAPers use almost every day! But when comes to this CDS, no such option I could find. If you are using DDIC view instead of DDLS Entity then probably you can, but that is NOT the right approach and with “define view entity” syntax you wouldn’t get any DDIC view generated, right?

Gobang Game write in ABAP OO!

This is a small game, Gobang, you can play with an AI(not very smart).

Just write it for learning abap oo and new Syntax.

If any question, please leave a message.

looks like a ALV? haa, yes, this is a ALV.

ABAP REST API http Service call from Postman: JSON to ABAP data

This blog post will describe the steps of how to expose REST API and handle REST API request from SAP ECC 6.0 without installing SAP Gateway service builder component. It will also help to convert json data to ABAP data. In this blog post I have described how to build web server service in ECC application server of Rest APIs using JSON data format.

Prerequisite JSON data format, SAP logon and postman.

◉ Define JSON structure:

JSON is a text-based data format which follow JavaScript object syntax. It stores the value in form of key value pair. Each of the property and value is separated with colon (:).

Changing i-flow name permanently in SAP CPI/HCI

Introduction:

In this blog post you will learn how to change the i-flow name permanently in CPI. I am sharing my inputs which I had gone through while I was doing this.

Let’s consider that you have an i-flow and you want to change the i-flow name. There are two ways to change the i-flow names. So, that in UT & SIT(Unit & System Integration Testing) also flow name will be changed permanently.