Data Migration: Using a Single program to Upload any database table

Introduction:

We often come across situations where we would like to directly upload data in the custom database tables (Transparent tables) which we create. The main intention of such kind of a direct update is primarily based on the fact that these tables only hold relevant data and there are no complex validations which needs to be taken care during the upload process.

Steps to create a data connection between a SAP on-premise system and SAP Web IDE using cloud connector

Overview

This blog post will guide you through the steps to create a data connection between a SAP on-premise system and SAP Web IDE. I will also be discussing steps to configure cloud to on premise and steps to map virtual to internal system in a cloud connector. At the end, I will be creating a list report application using an OData service in Web IDE.

Break point for SELECT statement with Table Filter

1. OVERVIEW

In some occasions we need to find exactly where a SELECT statement is done for a particular table.

We can use breakpoint for SELECT statement but, most probably, the debugging session can be hard due to the number of hits we can get.

To go straight forward and find exactly the place in the code where table, or a group of them, are being involved in a SELECT statement we can use Filter Criteria for the Breakpoint.

How to use BAPI_PRICES_CONDITIONS to mass upload price conditions

Brief overview of BAPI_PRICES_CONDITIONS:  is the unreleased BAPI and deficient in many aspects as there is missing documentation and also the BAPI has structural defects. This BAPI fairs not so well when compared to VK11 BDC updates [ or other application transactions ] or Idoc Creation. However like all BAPIs, we can rollback our changes in mass and the use of it to load all conditions from excel file and if any error, rollback is one of the reasons I would recommend to use this.

Building connected UI5 apps using Fiori Elements

It is a common requirement to enable app to app navigation and intra-app navigation when building a suite of UI5 apps. Anybody who has experience with traditional UI5 apps (free style apps before the Fiori elements era) will acknowledge that it is a bit challenging to implement and a variety of approaches can be used to achieve this. Things are streamlined a lot in apps using Fiori elements and usage of navigation controller(provided as part of extension API). In this blog I will share my experience building apps that talk to each other.

Gateway – OData Post using Postman

In this blog i’m gonna demonstrate how to use Postman to execute Post calls to a SAP Gateway server.

Then, create the Z table below in your backend (assuming it’s a Hub scenario) server:

ABAP on SAP Cloud platform – ABAP RESTful Programming Model (RAP) for beginners with CRUD example

Prerequisite: 

Concepts of Core Data Services(CDS) and annotations.

Lets Start

RESTful ABAP Programming Model (RAP): The term RESTful ABAP Programming Model (RAP) is chosen to reflect its orientation towards a “stateless” REST architecture.

S/4 HANA Embedded Analytics KPI Tile: Configuring Insight to Action

S/4 HANA Embedded Analytics KPI tile provides drill down capabilities. Clicking on KPI tile takes you to default drill down, where you can continue your analysis apply filters and drill down to the most granular data level e.g document level. Finally you can drill down to application (insight to action) to make transaction changes etc.

Currency and Unit conversion in ABAP CDS views

Recently, I’ve been checking some examples of unit and currency conversions based on ABAP CDS views and I noticed is quite common to find people applying manual conversions in the formulas.

A simple example of a days to years conversion is conceived with a multiplication of the original value by 365, for more complex situations like an expansion of this same conversion from days to months and years a CASE statement is implemented to adjust the output of the value.

How to create an openApi Rest Service from an oData v4 Rest Service with SAP Netweaver ABAP

Motivation and Introduction:

Rest Services are very popular and widely used. But Rest is only a programming paradigm and or an architectural approach as such it doesn’t set up any contract how services are offered, and which format the payload will have finally.

Step-by-Step Archiving of Material Documents

1. Step by Step Archiving Procedure for Material Documents Archiving:

Archiving Object MM_MATBEL is used for the archiving of Material Documents.To perform data archiving in the SAP system, SARA transaction code is used. This is the standard method for executing the Archival.

Read COMM port using ABAP w/o third party software

Case: Weighbridge scale sends the weight data to COMM Port.

Earlier we had to write a .NET program using SAP.NET Connector (Using VB.NET) and then from SAP side we had to create RFC so that the COMM port data gets utilized in SAP.

Now there is no need to use the third party software (VB.NET, C# etc) Using the following steps we can directly fetch the weight data at the COMM Port to SAP:

How to create OData for GET operation in SAP Cloud for Customer System ?

Open Data Protocol (OData) is an open protocol which allows the creation and consumption of quarriable and inter-operable RESTful APIs in a simple and standard way.

This blog post covers the step by step process for beginners on how to create the OData service for GET operation in the SAP Cloud for Customer System.

Excel Data to Internal table using ALSM_EXCEL_TO_INTERNAL_TABLE without additional code

This blog post will help you avoid extraneous code every time you create Excel upload program by creating a simple Interface and a structure.

Before I came across FMs like TEXT_CONVERT_XLS_TO_SAP and SAP_CONVERT_TO_XLS_FORMAT, I used  ALSM_EXCEL_TO_INTERNAL_TABLE widely.
For ALSM_EXCEL_TO_INTERNAL_TABLE, explicitly we need to write code to transfer output of this FM into internal table of desired format. For this we have to map column number of FM output with columns of required internal table using

ST Transformations: XML 2 ABAP, a working example

Note: this post is not about the differences between XSLT and ST, it’s just a little example for quickly understanding the general structure of a Simple Transformation.

Comparative Analysis with S/4 HANA Embedded Analytics

Comparative Analysis is a common requirement, for example, Y2Y. The challenge is to model CDS View in such a way that make data selection flexible and easy for both reporting period and reference period.