SQL Statement Collection for SAP HANA - The output is right aligned

In some ABAP Support Packages the SQL Editor of DBACOCKPIT will show a right-aligned output.

SAP Note 1969700 (section 'The output is right aligned') respectively 3343639 describe the reason and solution for this from ABAP aspect.

The aim of this post is to present an instant workaround to convert the output to a kind of "human readable" format.

The SQL statement referenced here is a statement from the statement collection attached to the SAP Note 1969700.

Methods to identify VIEW and TABLE name(s) from IMG node

Whenever a IMG node configuration is done in SAP, data get stored in View. Views are basically combination of one or more Tables. So, technically when a configuration is saved data is stored at Table level which could be one or more Table but virtually it is possible to view data from one or more table at a single virtual storage location called View. Implementation projects would require Views and Table for IMG Node to custom build tools as per local business requirement.

I have come up with methods to find VIEW(S) and TABLE name using IMG node to all beginners.

Follow either Method 1 or Method 2

Method 1:

Upload transport files from SAP

Introduction

This blog is useful consultants/Admins/functional folks who can’t not have access to operating system to transfer cofiles and data files

This blog describes detailed steps “How to upload and download cofiles/data files directly from SAP” pretty useful. You don’t need to have access to OS.

How to Do: Download and upload Co-files/Data files (Transports) directly from SAP

SAP S/4HANA Cloud, public edition, ABAP Environment Case 5: Purchase Requisition Mass Upload

This is a detailed step-by-step technical guide document to introduce a Developer Extensibility case followed by this blog.

1. Case Background:

In this case, we create an custom Fiori application, which can create multiple purchase requisitions from an Excel file template. Furthermore, you can define the upload template based on your own requirement.

YTD(Year To Date), MTD(Month To Date) and Quarter wise separation of data in HANA Modelling.

Introduction:

In a live connection dashboard, Standard content dashboard or in SAP HANA dashboard passing the whole data will make a lack or slow down the front-end(SAC, Lumira, PowerBi, etc). To overcome this type situation, we can use YTD, MTD, QTD concept in the HANA modelling.

Fiscal Year:

A fiscal year is a 12-month period of time that a company or government uses for accounting purposes to measure its financial performance.

Convert Multiple Rows in One Row with different columns in CDS Views

I’ve been searching for a solution for a while now, but I’ve been unable to find one that meets my requirements, even after consulting multiple blogs. It took some effort, but I’ve finally found a solution that fits my needs. Lets goo (Nervously excited)

Introduction

Dealing with multiple rows of data can be challenging, especially when you need to consolidate them into a single row with different columns. Fortunately, SAP CDS provides a powerful solution for performing this data transformation. In this blog post, we’ll show you how to use SAP CDS to convert multiple rows into a single row with different columns.

S/4 Hana Enforcement Actions and Debt Set Relationships

Introduction

The purpose of this article is to explore the relationship that exists between a DCM Debt Set and an enforcement action. These new entities within S/4 Hana essentially act as an adapter or bridge between the worlds of CRM and PSCD. The new capabilities of the Debt Set and Enforcement actions means that complex transactional processing can be managed by one order object entities with the added benefit of linkages to financial processing where appropriate.

Debt Set

A Debt Set entity has been introduced which essentially acts as a container to group like fica items for a specific debtor together. A debt set may also be categorised by utilising the concept of a debt set type.

AppGyver + CAI = Productivity & Digital Assistance

This post how we can combine AppGyver and SAP CAI together to achieve business goals.

Let’s see how AppGyver can help in increasing the productivity in your day-2-day business activities – you can be so close to your relevant information which can improve decision making and off-course a fast way to take decisions how ?

If we combine AppGyver & CAI together then – On tap you can access information and if you want to see the data at granular level – you have ConversationalAI with you to help.

Let’s see the architecture and understand the integration of these two in details and implementation too.

SAP S/4 HANA Custom Fiori app for Project & WBS using CDS View Table Function, SmartFilter & Tree table

In this blog, I would like to present the custom Fiori app that I developed for searching for Projects, WBS elements, and settlement cost centers. This blog will present details on how to read Project and WBS data using CDS views and table functions and then render the data in a tree table with a smart filter.

Here is a snapshot of the custom Fiori application showing Project, WBS element and settlement cost center data in a nice tree view table with a smart filter bar:

Calling Stored Procedure from SAP ABAP Application [BW on HANA, BW/4HANA, S/4HANA]

Stored Procedure – Introduction

Stored Procedure are frequently used Objects in SAP HANA. Stored Procedures allows to group the SQL statement into a single block and can return data in the form of output parameters.

In Mixed modelling Scenario calling a Stored Procedure from SAP Application can also be a good approach. Below is one Scenario we have faced in our Project.

Scenario: We had created a S/4HANA Report based on a Transient Provider and when checking for InfoProvider report gives a System Generated Tech name 2H*.

Implementing DCL with CDS Views and Roles

I am going to write here about how to use the concept of DCL with CDS views and using roles to provide row based authorizations in UI.

So, DCL stands for Data Control Language. It provides an access control mechanism to restrict the results returned by the CDS view from the database according to conditions. With the help of roles (PFCG), we can also use the same DCL and restrict the results for different categories of users.

Let us look into the process, with the help of an example.

ABAP CDS VIEWS simplified – PART 1

INTRODUCTION:

ABAP Core Data Service Views also known as ABAP CDS Views. There are so many limitations in SE11 views but we can come out of all the limitations and create a powerful views with the help of ABAP CDS Views.

In general SE11 views and ABAP CDS Views both will create a database views at the backend. When we try to access these views as a table in the ABAP code, this code will be executed at the database level.

ABAP CDS recursive association using hierarchy

Introduction

In this article, I will show a practical example of self-association in CDS. You will learn how to define a simple hierarchy in your CDS and how to consume it in your ABAP code.

Memory wasted by spring boot application

One of the widely wasted resources in the world today is: Memory. Due to inefficient programming, surprising (sometimes ‘shocking’) amount of memory is wasted. We see this pattern repeated in several enterprise applications. To prove this case, we conducted a small study. We analyzed the famous spring boot pet clinic application to see how much memory it is wasting. This application has been designed by the community to show how the spring application framework can be used to build simple but powerful database-oriented applications.

Implementing Cartesian Transformation in SAP ABAP CDS Views

Introduction

This paper presents in detail how to implement Cartesian Transformation in SAP ABAP CDS Views to convert a record with hundreds of measures to multiple records with few measures and their IDs.

This approach could be very useful when converting COPA and/or CCA data with hundreds of measures in each record to P&L data with multiple records; e.g., Sales, Rent, …, Revenues, Payroll, Utilities, …, Expenses for each original record and; e.g., , 2 measures in each record; e.g., current year and previous year values.

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.

Role of BTE process RWBAPI01 in BAPI_ACC_DOCUMENT_POST

Introduction

BAPI_ACC_DOCUMENT_POST is use for creating/posting accounting document for AP, AR and GL documents. This is an alternate solution in place of BDC which is used for posting documents through transactions like FB01 and FBB1. This BAPI can take input from legacy system and convert data into accounting document.

Report Creator

Introduction

Oftentimes, access to SE16 or SE16n is not granted to SAP end-users. This program would allow an analyst to configure their own reports by pointing to existing CDS Views, Views or SAP Tables without writing code. They configure their selection screens by importing an Excel spreadsheet. Lastly, create an SAP Transaction code which points to the report and assign certain users’ authorization to the new transaction. This program is suitable for those SAP installs with HANA.

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.

Solution Manager 7.2 SP 06 Upgrade Planning – Java Stack Part-2

Solution Manager 7.2 implementations have been gaining momentum. Recently I was a part of Solution Manager 7.2 on HANA support package 06 upgrade for a customer and I want to share how I planned the upgrade via Maintenance Planner for an already existing Solution manager Java System.