Delete duplicate entries in ABAP CDS views using Table Function and SQL Window Function

With the Code Push-Down strategy introduced by SAP HANA some of the functionalities used by ABAP developers haven’t been easily translated to the newest technologies, for example, CDS views.

In this blog post we are going to explore one of this scenarios trying to delete duplicate entries using ABAP CDS Views.

AMDP class and methods and how to use in an extractor

Introduction

An AMDP class is a global class in the class library that contains one or more of the following tag interfaces:

◈ IF_AMDP_MARKER_HDB for the SAP HANA database

The names of the interfaces all start with IF_AMDP_MARKER and a suffix indicates the database system for which the ABAP Managed Database Procedures can be implemented in AMDP methods of the class.

Activate HTTP/2 on AS ABAP 752 SP01 Dev Edition

The quickest way to maintain an Instance Profile is through transaction RZ10 however, I was not able to locate one when I ran this transaction on the server. Weird, isn’t it?

ODATA services from Queries BEX

1. Introduction

The following document discusses the method to create ODATA services from BEX queries in the SAP BW environment.

ODATA services allow a BEx query to be consumed by any system external to SAP that has this service.

SAP ABAP Unit test class with Test double

Introduction

ABAP Unit is the new unit test tool for ABAP which solves the problems with developer tests. Unit tests are a methodology for software development and are a mature framework in the developer toolbox. Tests can be conveniently grouped into test tasks. Test results are condensed and become evident at once. Test tasks can be performed by automation. In this document we will discuss how to automate Test Double Framework which is used to remove dependency from main CUT (Class under test) class.

Hosting a Netweaver ABAP Developer System on Google Cloud Plattform

This blog aims to provide a reference to students and teachers at universities on how to easily host an SAP Netweaver ABAP Developer system on the Google cloud platform. Also some of the information is specific to people teaching at universities the general approach might also be interesting for ABAP developers looking for an alternative approach to installing the SAP Netweaver ABAP Developer in a virtual machine or via docker.

General Usage Of Search Help Exits (Icons Display)

To bring some colour into SAP transactions I like to use Icons. I also think that Icons help to recognize faster what kind of data is displayed. Using different icons for different status help to get a better overview.

There is no witchcraft about the dynamic usage of Icons. But dynamic Icons in a search help exit comes quite close.

Options for editing table in ECC

This blog collates some of the techniques which helps me to edit tables directly in ECC without having to use Table Maintenace generator.

CAUTION: Modifying table entries in SAP directly is not recommended as it can corrupt the specific record or your DB. It is important to do this change with caution and only in Dev or Quality systems.

Dynamic Handling of Decimal Places for Amounts

Introduction

Currency in SAP is largely handled extensively with the currency functionality and TCURC and TCURX tables. However, every now and then we come across a requirement where we need to extend this to accommodate other requirements.

In this blog we would like to share our experience of a requirement we came across in our project where the number of decimal places for a currency needed to be increased in order to attain more precision.

SAP Standard Fiori Apps : PR Approval Process

1. Config Part for PR Approval Process.

This Part Usually done by Functional team.Most of the issues will occur with this part only,so be careful while doing the config part.

Mainly the issues occur such as release code,release strategies,agent assignment for particular release code.

Ensure values of the newly added fields to the database table in SE11 for the existing records are left as NULL and a default value is not filled in them.

INTRODUCTION:

This blog post highlights with details how to ensure that NULL values are assigned to the the newly added fields for the existing records in the database tables, so that huge amount of time is not wasted to fill them with default values. This requirement is even more relevant for Production systems where the database tables already have millions of existing records.

Making your own planning and scheduling system

The aim of this blog is to show how you can make your own planning and scheduling system as an add-in into your SAP or at least the first step:  building order net for particular order-position-schedule combination or in other words order status report known from the transaction MD04.