Sap/ABAP Hana Programming

Learn to design and build SAP HANA applications with ABAP/4

Sudipta Malakar

• Publisher: BPB Publications
• Year: 2018
• eBook ISBN: 9789387284289
• Topic: Computer Science
• Subtopic: Entreprise Applications
• Index: Computer Science

Enrich your skill set with Open SQL and CD5 views Key Features

• Comprehensive coverage of SAP / ABAP HANA with emphasis on real-time case studies.
• Practical examples along with Screen personas, SAP Fiori cloud, OPEN SQL, Native SQL & ADBC, CDS support in SAP NW ABAP 7.4 SP5, SAP HANA Studio, performance enabler Rules & guidelines.
• Simple language, crystal clear approach, straight forward comprehensible presentation.
• Concepts are duly supported with examples.
• Topic coverage with the aim to fill the skill gap among industry and academia.
• SAP Business Suite powered by SAP HANA are helpful for developing projects for IT consultants

Description
The book has been written in such a way that the concepts are explained in detail, giving adequate emphasis on examples. To provide clarity on the programming examples, logic is properly explained and discussed by using comments in program itself. The topics covered in this book include starting the software using snapshots of the same and writing programs. Simple to complex SAP/ ABAP HANA examples are provided in detail, considering the requirement of IT consultants the basic idea of developing projects in it. The examples provided in this book are user-focused and are provided through sections, figures and examples. What You Will Learn

• Gaining Customers by adopting and implementing SAP HANA in organisations / projects / programs
• Facilitating to maintain Customer Relationships as the core of all successful working relationships are two essential characteristics: trust and commitment. To demonstrate their trustworthiness and commitment to customers, progressive suppliers periodically provide evidence to customers of their accomplishments.
• Help in delivering "Superior Value and Getting an Equitable Return" as understanding value in business markets and doing business based on value delivered gives suppliers the means to get an equitable return for their efforts.
• This document is a compilation of SAP ABAP/4 coding and efficiency standards and will provide guidance in creating readable, maintainable code. It is intended for all developers in the SAP R/3 system. This document is based primarily on ABAP/4.

Who This Book Is For
Person from IT domain having software background, preferably with SAP technical or techno functional or functional or domain knowledge. Table of Contents
1. Introduction
2. General Programming Standards
3. ABAP Internal Names
4. ABAP/4 Dictionary
5. Security Authorisations considerations
6. ABAP/4 Coding Techniques About the Author
Sudipta Malakar is an accomplished IT SAP Project Manager, Program Manager, Agile Coach with 15+ years of experience in directing SAP DEV teams in supporting many major fortune 500 clients in multiple large accounts (of more than $10M+) that include more than 7 years of experience in IT Project/Program & Solution Delivery Management and 5+ years of experience in Agile as SCRUM Master, Agile Coach.

CHAPTER 1

Introduction

Notice how SAP HANA has changed the world now. Whether you are a newbie or an old-hat, you can learn to design & build simple and advanced SAP HANA applications with ABAP/4 by using this comprehensive artifact. You can also enrich your skillsets with the use of new Open SQL enhancements and CD5 views, and integrate native SAP HANA objects. Use this detailed programming referral guide to develop database procedures and optimize your applications. You’ll be programming for SAP HANA in no time.

Readers may enhance their skillsets with numerous buzzwords currently being used in IT organizations worldwide , like SAP HANA, SAP screen personas, SAP Fiori, ABAP, SAP HANA tables and their advantages over conventional tables, SQL, AMDP, CDS views on HANA, DML/DDL/DCL etc.

Target audience for this book may be in IT domain having software background, preferably with SAP technical or techno functional or functional or domain knowledge.

This book will teach you the basics of SAP HANA. The book is divided into sections such as SAP HANA Basics, SAP HANA-Modeling, Reporting, SAP HANA-SQL and case studies.

1.1 HANA Overview

What is HANA - SAP HANA (High-Performance Analytical Appliance) is an in-memory database engine from SAP that is used to analyze large data sets in real time that reside entirely in memory. Very crudely it is a Database System which totally changes the DBMS methodology and it can be deployable on premises or over cloud.

What is new in HANA – HANA is the first system to let you to perform real-time online application processing (OLAP) analysis on an online transaction processing (OLTP) data structure. As a result, you can address today’s demand for real-time business insights by creating business applications that previously were neither feasible nor cost-effective.

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

Ref: SAP S/4HANA 1709 Release Highlights - SAP - Run Simple

1.2 HANA Goals

✓ Enables New Application and Optimize Existing Application

✓ High Performance and Scalability

✓ Hybrid Data Management System

✓ Compatible with Standard DBMS feature

✓ Support for Text analysis, indexing and search

✓ Cloud support and application isolation

✓ Executing application logic inside the data layer

SAP HANA Vendors

SAP has partnered with leading IT hardware vendors, like IBM, Dell, Cisco etc. and combined it with SAP licensed services and technology to sell SAP HANA platform.

There are, total, 11 vendors which manufacture HANA Appliances & provide onsite support for installation and configuration of HANA system.

Top few Vendors include:

✓ IBM

✓ Dell

✓ HP

✓ Cisco

✓ Fujitsu

✓ Lenovo (China)

✓ NEC

✓ Huawei

According to statistics provided by SAP, IBM is one of major vendor of SAP HANA hardware appliances and has a market share of 50-52% but according to another market survey conducted by HANA clients, IBM has a market hold up to 70%.

SAP HANA Installation

HANA Hardware vendors provide preconfigured appliances for hardware, Operating System & SAP software product.

Vendor finalizes the installation by an onsite setup & configuration of HANA components. This onsite visit includes deployment of HANA system in Data Center, connectivity to Organization Network, SAP system ID adaption, updates from Solution Manager, SAP Router Connectivity, SSL enablement and other system configuration.

Customer/Client starts with connectivity of Data Source system and BI clients. HANA Studio Installation is completed on local system & HANA system is added to perform Data modeling and administration.

SAP HANA – IN-MEMORY-COMPUTING ENGINE

An In-Memory database means all the data from source system is stored in a RAM memory. In a conventional Database system, all data is stored in hard disk. SAP HANA In-Memory Database wastes no time in loading the data from hard disk to RAM. It provides faster access of data to multicore CPUs for information processing and analysis.

Features of In-Memory Database

The main features of SAP HANA in-memory database are:

• SAP HANA is Hybrid In-memory database.
• It combines row based, column based and Object Oriented base technology.
• It uses parallel processing with multicore CPU Architecture.
• Conventional Database reads memory data in 5 milliseconds. SAP HANA In-Memory database reads data in 5 nanoseconds.

It means, memory reads in HANA database are 1 million times faster than a conventional database hard disk memory reads.

Ref: Tutorialspoint

Analysts want to see current data immediately in real time and do not want to wait for data until it is loaded to SAP BW system. SAP HANA In-Memory processing allows loading of real time data with the use of various data provisioning techniques.

Advantages of In-Memory Database

• HANA database takes advantage of in-memory processing to deliver the fastest data-retrieval speeds, which is enticing to companies struggling with high-scale online transactions or timely forecasting and planning.
• Disk-based storage is still the enterprise standard and price of RAM has been declining steadily, so memory-intensive architectures will eventually replace slow, mechanical spinning disks and will lower the cost of data storage.
• In-Memory Column-based storage provides data compression up to 11 times, thus, reducing the storage space of huge data.
• This...

Table of contents

• Cover Page
• Title Page
• Copyright Page
• Acknowledgements
• Preface
• Table of Contents
• Chapter 1: Introduction
• Chapter 2: General Programming Standards
• Chapter 3: ABAP Internal Names
• Chapter 4: ABAP/4 Dictionary
• Chapter 5: Security Authorizations Considerations
• Chapter 6: ABAP/4 Coding Techniques