How to analyze query performance for ABAP CDS Views

Purpose

As you may know, ABAP CDS View is one of the important development objects in SAP S/4HANA, which supports multiple purposes including transactional or analytical applications. ABAP CDS Views leverage the power of the underlying HANA DB to boost the performance. However, sometimes the performance is not good enough and needs some fine tuning. There are already some very good blogs and documents out there.

Working with JavaScript Object Notation (JSON) format in ABAP (Serialization – Deserialization)

This blog post will give an overview of working with JavaScript Object Notation (JSON). We will create JSON string output from the internal table and read JSON data as input in ABAP program. Nowadays JSON format preferred over XML format due to lightweight and simple syntax.

JSON consists of two-part information data first part as key fields (name attribute) and the second part as field value which separated by a colon “:”. This JSON output can be easily readable via any text edition or JSON viewer.

The New Client Copy Tool for S/4HANA #ASUG Webcast Recap

This was an ASUG webcast given last month.  It was a repeat of a session given at SAP TechEd Bangalore.  Special thanks to SAP’s Carine Tchoutouo Djomo for arranging this for ASUG.

SAP Solution Manager – Qualtrics Integration

X+O case for IT Service Management

INTRODUCTION 

Qualtrics is an experience management platform, which combines the experience data and operational data (X+O) and provides meaningful and deep insights into customer expectations, patterns and helps to improve satisfaction.

Real-Time Open Order Calculation with S/4HANA CDS Views

Real-time open order calculation was always a challenge in R/3 due to slow DB. Developers had no choice but do calculations in ABAP layer with endless loops, if statements and interim tables / variables. With S/4HANA ABAP CDS Views game changing technology it is time to use set based SQL calculations and push calculations to HANA DB where they belong.

ESS – Anatomy of the 2020 W-4 Webdynpro Application and Customization

Depending on your need, there may come a time where you must customize the standard ESS W4 Webdynpro application in some way. Very typical examples include:

◉ Remove the “delete” column from the list of infotype 0210 records. (many clients do not want to allow the employee to do this).

◉ Change the layout of the “detail” section for a inftype 0210 selected record.
Lucky me…..I got to do BOTH of these so I will talk about them as it comes up in this discussion.

Automating authority-check in Z/Y transactions

After some years, I’ve faced with a new project that could be a little bit boring, that were called “check user authorizations in Z transactions” in the security information sector, but in the end of the day, it was funny.

The number of Z transactions were higher than I expected, something like 1000 transactions, so after some thinking, I’ve found a “automatic” way to deal with it.

Performance of Add & Aggregate vs Aggregate & Add in CDS Views

Introduction

When implementing HANA models or CDS views, it is often required to calculate total values of multiple measures in each record and aggregate total values for specific record range. The question is whether we should add measures’ values first and then aggregate them or aggregate component measures first and then total their aggregated values.