HANA SQL Statements Optimization

In this article will demonstrate complete steps “How to optimize HANA SQL statements”.

What is an expensive SQL statement?

SQL statements consuming significant resources are called expensive SQL statements.

SQL statements that are not executed efficiently can cause local and system-wide problems. The most critical are the following areas:

HANA Authorization Fundamental

1. Introduction to HANA and Authorization

SAP HANA Authorization is to protect important data from unauthorized access and ensure compliance and standards are met as adopted by an organization.

SAP HANA provides a facility of multitenant database container i.e multiple databases can be created on single SAP HANA DB System. Hence SAP HANA provides Authorization related feature for all multitenant database container.

SAP S/4 LEAN Integration with Manufacturing Execution systems

This case study talks about Cognizant’s Achievement in Implementing SAP S/4 LEAN- MES System Integration for efficient control over Manufacturing process in Pharma & Life Sciences Industry. As first of its kind, Cognizant team recently worked on S/4 LEAN and MES Interface development. This article covers some of the challenges that we faced, case for change, transition approach we took, the relevant reasons and some of lessons learnt.

Details of Manufacturing Execution systems

Manufacturing execution systems (MES) are computerized systems used in Pharma/ LS Client manufacturing Sites to track and document the transformation of raw materials to finished goods. MES provides information that helps manufacturing decision-makers understand how current conditions on the plant floor can be optimized to improve production output. MES works in real-time to enable the control of multiple elements of the production process (e.g. inputs, personnel, machines, and support services).

Email template in S/4 HANA using OOPs concept

Email template feature explained in very simple way using OOPs concept.

Very often we get a business requirement to send email with table format. Before S/4 HANA we use to design the table using HTML <table> <th> <td> tags which is tedious and then use the conventional way of calling FM to send the mail but after S/4 HANA release SAP has ease by providing email template feature which can be send by calling methods.

SAP SAP HANA XSA (mainly FSPRO) applications Access via external web dispatcher

Overview

Under this blog, I have outlined how to configure an SAP Web Dispatcher (WD) so that it acts as the reverse-proxy server for an XSA instance where SSL is terminated at the XSA server. The WD will simply route requests to the XSA instance. This setup allows the XSA host to be hidden from the end user.

Mainly if you have port-based XSA installed due to application limitations.

Enhanced Custom Code Analysis in SAP Readiness Check for SAP S/4HANA Upgrades

In SAP Readiness Check for SAP S/4HANA upgrades, the Custom Code Analysis check now provides enhanced visibility to the ABAP test cockpit findings related to the target SAP S/4HANA product version. By creating a baseline of existing findings (that is, historical findings left over from a past SAP ERP conversion or SAP S/4HANA upgrade project) and exemptions in the ABAP test cockpit before running SAP Readiness Check, you can exclude these results from the check and focus on findings that are relevant for your upgrade project.

In addition, the custom code analysis has been integrated into the data collection framework of SAP Readiness Check for SAP S/4HANA upgrades to assist in the data collection process.

The culture of repair as an analogy for Application Lifecycle Management

Introduction

I recently read the book “The Culture of Repair” by Wolfgang M. Heckl. The topic and the core message also apply to Application Lifecycle Management. Anyone who no longer understands the basics and relations will soon feel lost.

Die Kultur der Reparatur

Implement a More Efficient GIS-ERP Integration Following a Few Simple Steps

Deploy faster, more efficiently using in-built SAP HANA platform capabilities

After spending seven years at SAP developing patterns for a more efficient way to integrate GIS and ERP systems, I’ve returned to Locana to get directly involved in implementations that use in-built HANA platform capabilities to accomplish that objective. Below, I’ve listed steps that eliminate technical debt and complexity found in typical integration patterns.

IT leaders, GIS managers, and others can use the HANA platform to simplify integrations, enhance performance, and access advanced analytical capabilities by taking these steps. Combining ArcGIS Enterprise and S/4HANA ERP on the HANA platform makes this possible.

Mastering the SAP S/4HANA Transformation: A Comprehensive Guide to Technology Options

Your company is making a big move from SAP ECC to SAP S/4HANA. The transition is no small feat, and it requires careful consideration of your technology and tooling choices, including some crucial decisions that are often overlooked.

This article discusses technology options that organizations typically use during their S4 journey to transform various areas. Throughout the process, it’s crucial to find a balance between leveraging existing tools and introducing new ones, avoiding overwhelming teams.

Multiple Input parameter in Hana Calculation graphical view

Aim: To create a calculation view with multiple input parameter that should display data corresponding to the input parameter.

The entire calculation view is here,

Step by Step creation of Custom Database Table and Updated it with HANA Class using ABAP on HANA Development

Now I am going to explain how do we create Customized Data Dictionary Table in ABAP on HANA environment and updating the created Table 

Step1: Open the Hana studio and Go to the project explorer.

Step2: Click on the package and Right click on Dictionary.

I.e.. Dictionary –> New –> Database Table