Customer Aging and Supplier Aging Reports at the Line Item Level using Analytical Query in S/4HANA Cloud, Public Edition

Introduction

Functional consultant or a business key user can effortlessly generate supplier and customer aging reports using the Custom Analytical Queries App for the scenarios outlined below.

Scenario – Accounts Payable Aging:

Your client requires a supplier aging report that displays the aging at different levels: Supplier level, Reconciliation G/L level, Supplier Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

SAP HANA Overview

1. What is HANA?

SAP HANA (High Performance Analytical Appliance) is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk.

HANA is the first system to let you perform real time online applications (OLAP) analysis on an online transnational processing (OLTP data structure).

XSA Data Loading

Introduction

We will be addressing the data loading process in detail. How is data loaded from a source system? How is data loaded from one table to another within an HDI Container? What artifacts exists for loading? All relevant questions will be answered and considered with the help of our example project.

Data loading basics

In our first blog, we explained the fundamentals of XSA, while in our second blog we understood persistent structures and created our XSA example project. The XSA environment takes a new course when it comes to data loading as well, and uses its own services and structures.

How to find the underlying Data structure of an Application Building Block ID and Node name to enhance FPM application.

This blog is relevant to a scenario wherein underlying Data structure is not provided in the component configuration.

Problem Statement Example

Create a custom field in the External Data tab of maintenance order app.

Maintenance order app – External Data tab

Internal Server Error occurred when trying to log in to Hana cockpit in web browser

Overview:

Logon to the HANA Cockpit Server with the <sid>adm user

XSA: HDI Container, Persistence and CAP

Introduction

We will be addressing persistent data storage in the modern HANA platform. How are tables created in XSA? What role do HANA Deployment Infrastructure (HDI) containers play in this respect? What are the advantages of SAP’s Cloud Application Programming Model (CAP)? We will answer these exciting and essential questions with the help of an example project which we have created in the Business Application Studio (BAS).

HDI Containers

Based on our first blog, we know that the introduction of XSA resulted in a fundamental paradigm shift in creating native HANA models. The approach of a central (database-focused) system is giving way to a cloud-focused system with separate applications and dedicated services. But how are applications separated, exactly?

Data ingestion from SAP HANA to Databricks Cloud and visualize in Tableau

The process of gathering data from numerous sources is an essential prerequisite for organizations to carry out advanced analytics, data science, and machine learning. However, ingesting and consolidating this data to establish a trustworthy, unified data repository is an arduous and expensive task.

In this blog post, I will demonstrate the process of ingesting data from the SAP HANA Cloud database by establishing a connection with HANA DB using the Python Database API Specification. We will then explore how to seamlessly integrate this data into Databricks Delta Lake. Finally, I will guide you through visualizing the ingested data in Tableau by establishing ODBC connectivity between Databricks and the Tableau tool.