Fiori PO Approver app Accept and Reject button customization from ECC backend

Many time there are custom requirements for which it requires the need of creating Enhancement in standard SAP functionality.

Overview: PO Approvers are maintained in Release Strategy. Once the PO is generated it is set to be approved by PO approvers based on the levels maintained in PPOME structure. Only then the PO will be set to 03 status in EKKO.

Pre-requisite: All the roles and authorization must be given to the approvers to access the PO Approval Tile in SAP Fiori.

Monitoring the Performance of Outbound Communication in the ABAP Environment in the Cloud

Since the ABAP environment in SAP BTP typically interacts with other BTP services, you may be interested in a performance monitoring of such outbound communication. In this blog post, I’ll show you how you can use the System Outbound Communication app in the ABAP environment. You can even get alerted by mail if the performance of a specific outbound service gets critical. In the example I’m describing here, I am logged on to an ABAP test system in the cloud in the role of a customer (with the administrator role).

Communication Scenarios

When you open the app, you first get an overview of the top 10 outbound communication scenarios by calling time of the past day. If there are multiple communication arrangements that belong to one scenario, they are aggregated to one column in the chart.

How to Manage and Move Transport Request in S/4HANA Public Cloud in 3 System Landscape

Purpose of this Document

This document helps you understand moving transport request from Development to Q system and Q system to Production system in 3 System Landscape. Transports for business configuration, key user extensibility, and developer extensibility are of the different categories and that is why these are separated. So, we need to understand all of three.

How to Create Table and Push Data to ODBC/Remote Database using Native SQL with ABAP DB Connectivity (ADBC)

Recently I had a task to Push Data from SAP Reports to MS SQL DB, periodically, and to Create Tables of the required Reports in their MS SQL DB, as well

Being a complete novice ABAP developer, I learned about ABAP DB Connectivity (ADBC) DDL and DML methods, which helped me complete the task more dynamically, instead of using EXEC SQL with Placeholders ? for each field

Before moving forward I would like to state the obvious that by no means my approach is best/optimal out there

Parallelize cl_http_client

You have the requirement to call an external scalable REST micro-service. Unfortunately the system needs a few 100ms to respond and you have to call the system multiple times with different parameters. As the code is called by end users you want to parallelize the REST calls.

So what is the “normal” solution for that problem? The Standard ABAP answer is of course: ABAP Parallelization using Worker-Processes (using e.g. that wonderful library ZTHREAD ). This has multiple problems though:

Archive Conversion with SAP LT Tool

SAP offers for the execution of the conversion on the db as well as for the related archives the Landscape Transformation Tool (LT Tool). There are a lot of kind of conversions possible. Some examples are Company Code splits, Controlling area merges or also renaming of supplier numbers for example.

In this blog we are going to focus on the archive conversion which will in most cases take place after the database conversion has already been conducted successful. The advantage is that the mapping of the db conversion can be taken over for the archive conversion as well.

To start with the archive conversion you need to call the process monitor for the merge package. This is done via Transaction code CNV_MBT_SLOP

Process Order Screen Enhancements (COR1/COR2/COR3)

Customer fields in process order transactions (COR1/COR2/COR3) : PPCO0020 Screen Exit

Objective

In this blog post we are going to create a custom tab for Process Order transactions (COR1/COR2/COR3) with below 3 additional fields:

◉ Reason for Schedule Variance (Drop down options)

◉ Schedule End Date (Non-editable)

◉ Schedule End Time (Non-editable)

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

gCTS configuration and integration with GitHub

SAP has launched Git-enabled Change and Transport system (gCTS) back in 2019 with S/4 HANA 1909 to manage the ABAP changes which can leverage Git as an external system for Version Management.

Now let us understand what are the planned use cases of gCTS are:

Planned use case 1: You need to build N+1 landscape for new project requirement

Using gCTS we can create a Feature branch and a Maintenance branch and perform changes in the same N landscape development system in parallel.

Easy way to write data via a deep entity in OData

Introduction

I have seen many tutorials based on OData but I really found them complex for beginners.

So, I am writing this blog post for quick easy reference. This is the 2nd blog post in the series.

For the first post please check the Easy way to read data via a deep entity in OData.

Easy way to read data via a deep entity in OData

Introduction

I have seen many tutorials based on OData but I really found them complex for beginners.

So, I am writing this blog post for quick easy reference.

Solution

Please follow the steps:

BTP Integration – Process email Attachment to Post Deep insert using odata on Premise ECC

There are different integration scenarios where we would like send to an email with attachment of contents (XML or json) which can be read and sent to ECC to post a transaction identified by the integration. To achieve this we have to perform the following Steps

1. Configure ECC and cloud connector for http

2. check connectivity for IMAP download and import the certificates into Integration Suite key Store

3. Create the BTP Integration iflow to process inbound email to read the attachment and invoke the configured odata service and send result email or exception process email

4. Test the end to end process

Integration Program With PI and Automatic creation of Goods Receipt by using a BAPI for MIGO Transaction and sending the details to third party system

This Program will help to upload the data for MIGO Transaction and also to send the data to third party system by using PI

1. Creation of PI

2. Need to display the excel file as ALV output.

iii. In MIGO there are two operations that are performed to post a GR.

iv. a) Check Operation

v. b) Post Operation.

ABAP Managed Database Procedure

The technology is evolving and SAP has developed techniques like CDS View or AMDP to solve the performance issues of fetching data from the database and also to take advantage of the HANA power.

Let’s keep up with innovations!

I would like to share with you some of the basic information we need to have about AMDP.

ABAP Managed Database Procedures (AMDP)  was introduced in Release 7.40, SP05, allowing developers to create their software and write directly in ABAP. Database procedure, but fully managed on ABAP.

Accessing SuccessFactors OData APIs using OAuth 2.0 Client APIs

This article describes the process on how one can access SuccessFactors OData APIs from an ABAP program using the OAuth 2.0 Client API. The OAuth 2.0 client enables one to access protected services and resources that are offered by any external service providers. The communication between OAuth 2.0 client and server is secured by an HTTPS connection.

With the sunset (planned retirement) of HTTP Basic Authentication for API Calls (SFAPI and OData), one of the recommended alternative approaches is to use OAuth2 SAML Bearer Assertion.OAuth 2.0 client handles the storing of OAuth 2.0 tokens and client secrets in the secure store.During the authentication, OAuth 2.0 client passes the OAuth 2.0 scopes to the service provider which contains references to all the allowed resources. The objective of this article is to share a working sample of OAuth 2.0 with OData API calls required for custom development integrations involving SAP ERP system with SuccessFactors Employee Central.

Kernel Badi Sorter with Multiple Implementation

The intention here is to do a sample test Sorting of Multiple Implementations of a Kernel BADI.

A pre-requisite of knowing Kernel BADI basics is required.

So, I have defined a Enhancement Spot ZDPK_KERNEL_BADI_SORT_EHN

Create Badi

Using the ODBC driver for ABAP on Linux

Prerequisites on Linux

A 64-bit Linux version is required because the ODBC driver for ABAP is a 64-bit ODBC driver. To define ODBC data source names (DSN) for the ODBC driver for ABAP on Linux, you need to install the unixODBC software package on your Linux system. This software package will also provide some simple command-line tools to test an ODBC connection and to execute SQL queries.

You may also want to install the LibreOffice software package to follow my simple application scenario.

FBL1N Enhancement Document Date Functionality

Standard FBL1N transaction fetches the vendor line item display based on posting date. When there is a requirement to fetch customer line items based on document date, a custom enhancement needs to be developed.

To make them work based on document date (To fetch records based on BLDAT-Document date) enhancement needs to be developed in the logical database.The logical database holds all the structures. Here we cannot enhance the structures and nodes directly. Only the source code program of the database can only be enhanced.

By using submit functionality (passing vendor,open items date) in custom z reports ,records based on the posting date will only be fetched. But in order to fetch open items based on document date(BLDAT), enhancement needs to be done. The standard transaction code FBL1N cannot be enhanced to accomodate this functionality. The standard FBL5N fetches the customer line item display based on posting date(key date).

Exceptions in oabap for new abapers

First we can discuss what is exceptions exactly.

Exceptions: The Exception is a problem that arises during execution of the program. When an exception occurs the normal flow of an execution is disrupted and the program application is terminating abnormally, which is not recommended, by avoiding these you can handle the errors. When you fail to capture the error the runtime system will abort the program (i.e., crash)

Whenever the exceptions are raised in case of ABAP the program is going to short dump, this is not the right case, as a developer you can think about the exceptions where it is raised from where you need to capture the exceptions, Exceptions are always play an important role while developing the application.

What is exception handling ?

Exception handling is a process of handling an exception in such a way the short dump of a program is avoided and normal termination of the program is achieved. If the generated exception successfully handled the normal termination of the program is achieved and the performance of the software is not affected.

Sending Spool List into Excel Format through Email Attachment

Requirement

I got one requirement where i need to call the SUIM transaction -> Roles by Complex Selection Criteria with multiple variants selections as background job and need to send the output in XLS format to multiple users maintained in distribution list.

There was one more additional requirement where i need to create single excel output with multiple tabs ( indicating each variant of report ).

Solution

This Solution will help for any report which we want to execute as background job and display the List View in Excel format.