SAP HANA Course Curriculum

Learning HANA : course contents

index of topics

SAP HANA Course Curriculum

HISTORY OF SAP  About SAP

 SAP Releases and Versions  What Is SAP ERP

 SAP Modules

SAP HANA Features & Introduction  Introduction to SAP HANA  Importance of SAP HANA IMDB  SAP HANA Applications overview  SAP HANA Evaluations

 Detailed discussion of SAP BWA,SAP HANA and differences  SAP HANA IMDB storage types

 Row oriented storage  Column oriented storage

 SAP HANA Compression & Portioning  SAP HANA Memory allocations,e.t.c SAP HANA

 Architecture of SAP HANA(Discussing below topics in detail)  Importance of In-memory studio

 SAP HANA Versions  Importance of Reporting  Importance of Session Mngt  Importance of Relational Engine

 Importance of Request Processing/Execution Control  Importance of Managers

 Importance of Persistence Layer  Importance of Disk Storage  Importance of Load Controller  Importance of Replication Agent  Importance of BOBI 4

SAP HANA LICENSING  SAP HANA Versions

 SAP HANA Platform Edition  SAP HANA Enterprise Edition

 SAP HANA Enterprise Extended Edition HANA Studio

 What is PERCEPTIVES  What is catalog

 What is Content

 What is schema & How to create Schema  How to create Package

 Importance of Description Mapping  Importance of Text Join

 How to create Hierarchies  How to create Analytical View  Importance of Data Foundation  Importance of Logical

 Importance of Save & Activate, Data Preview  How to create Calculation View

 What is Calculation View

 Importance of Save, Attributes, Measures, Variables  Importance of Find Column

 Importance of UNION/JOIN & PROJECTION  Importance of Decision Table

 Importance of Analytical Privileges  Overview on SQL Script related to HANA ETL BASED DTA Provisioning USING BODS

 Data services-One stop solution

 Data Integration ,Data Quality ,Data Profiling  Metadata management and Text data analysis  Working with BODS

 BODS Server  Repository  Job Server

 Management Console  Data Services Designer  Creating Formats  Creating Datastores  Creating projects  Creating Batch jobs

 Scheduling and monitoring Batch jobs  Creating Dataflows

 Creating Connection to HANA DB IMPLEMENTATION SCENARIOS

 Loading Data from Excel File to HANA Database Table  Loading Data from Flat File to HANA Database Table  Using Template Tables

 Loading Data from Oracle Database to HANA Database  Loading Data from SAP ECC to HANA Database with Dataflow  Loading Data from SAP ECC to HANA Database with ABAP Dataflow  Loading Data from SAP BW to HANA Database

 Loading metadata from SAP ECC to HANA Database DATA PROVISIONING USING SLT

 SAP Landscape Replication server for HANA  Key benefits of SLT Replication server  Key benefits of Trigger-Based Approach  Architecture for SAP source Replication  Architecture for Non-SAP source Replication

 Configuration and monitoring Dashboard for HANA(LTR)  Creating new Configuration for SAP Sources

 Creating new Configuration for Non-SAP Sources  Result of Creating new Configuration

 Launching Data provisioning UI in HANA studio  Start Load/Replication

 Stop/Suspend Replication

 Status Monitoring in HANA Studio  SLT based transformation Concept  Advanced Replication Settings

 Change of table Structuring and Partitioning  Filtering and Selective data replication

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC) Overview

 DXC Concept  Challenges  DXC Benefits

 Activation mechanism for handling Delta Processing  Data Source Extractor Concept

 SAP Business Content Data Source Extractors  SAP HANA DXC Connection setup and Configuration  Activating Data Sources in Source system

 Understanding the tables of IMDSO

 Creating info package and Scheduling data load  Monitoring Data loads

 Comparisons with other data acquisition techniques  DXC sidecar approach

Reporting

 MS-Excel based reporting

 Defining business layer on IDT(Information Design Tool) Environment  Webi Reporting on HANA DB

 Crystal reporting on HANA DB

 SAP HANA Database Connectivity Options  Relational Connection with HANA DB  Lumira(Visual Intelligence)

 SAP BO Analysis for office

 Creating Connection, Data Foundation, Business Layer  Dashboards

 Publishing HANA Models to SAP BW Information Designer Tool

 Understand concepts of Web intelligence  Creating Folder

 Creating Connections

 Types of Connections Relational and OLAP  Creation of Data Foundation

 Creation of Data Foundation using single source or multiple sources  Inserting Tables

 Making Joins and Types of Join  Resolving Loops

 Creation of Business Layer using Data Foundation  Creation of Classes and Objects

 Exporting the Business Layer into Repository. Web Intelligence Rich Client

 Create Web Intelligence documents with Universe  Change the Existing Web Intelligence document  Restrict Data returned by a query

 Design a report

 Enhance the presentation of data in reports  Form a report

 Calculate data with formulas and variables  Analyze data

 Manage and share Web intelligence documents  Work with Filters Query and Report level  Work with Prompts at Query level  Work with Drilling , Purging

 Work with Breaking, Section, Ranking,  Work with Sub Reports

 Create formulas with characters &date string functions  Create hyperlinks

 Create a Web I Reports on SAP Bex Query using OLAP Connection  Converting Table into Graph

 Creation of Web Intelligence reports using Info cube& BW Query Crystal Reports

 Planning a Report with Universe  Selecting Records

 Formatting a Report  Representing Data Visually  Distributing Reports

 Creating Basic Formulas  Organizing Data on a record  Applying Section Formatting  Applying conditional Reporting  Using Report Templates  Creating Formulas

 Building Parameterized Reports  Using Report Sections

 Add hyperlinks to a report Dash Board Designer

 Creating a Model

 Adding Interactivity to a model  Creating a connected Model

 Connect to crystal reports data and create dashboard  Connect to WEB I Reports data and create dashboard  Using Query as a web service and create dashboard

 Using Query as a web service and create dashboard  Use Live Office data and create Dashboard

 Use Other connectivity components and create Dashboard  Create a Dash Board with Alerts

 Create a Dash Board with Dynamic Visibility

 Create a Dash Board with all Dash Board Components  Create a Dash Board with Query Browser.

Authorizations

 User Creation  Role Creation

 How to assign role to user

 How to assign Analytical privileges to role Transport Management

 Introduction to Transport Connection  Overview on SAP Transport Connection  HANA Transports

Different Types of Privileges  System  SQL  Package  Granted Role SAP HANA SQL  HANA SQL DDL  HANA SQL DML  HANA SQL DCL

 SAP HANA Referential Join  Procedures

 Creating Table Types  Calling Procedures CE-Functions

 Control Statements

 Understanding Currency Conversations in SAP HANA  Using Currency Conversions in SAP HANA

 Generate Auto Documentation  Import & Export Models  Delivery Units

 Developer Mode  Support Mode  Documentation  Translations

 Managing model Content  Manage Schemas  Security & Authorizations  HANA Privileges

 Creating Users

 Assigning Privileges Users & Roles Course Highlights

 HANA-Functional, Technical, Documentation  ECC with SLT Configuration

 SLT with HANA Configuration  BODS with HANA Integration  HANA with BO Reporting BW HANA

 BW DB2 Migration Process to HANA  BW with HANA DB vs DB2

SAP HANA ABAP TRAINING

SAP HANA ABAP Training Introduction:

SAP HANA ABAP Training lays the foundation for seamless SAP applications, with a broad range of

features & functionality for creating powerful business solutions. SAP HANA provides an opportunity to innovate with new and sophisticated technologies. With support package stack for SAP

NetWeaver 7.4, SAP has brought ABAP and SAP HANA Training together with features that enable developers to get the best of both worlds, not only in new custom development projects, but also in their existing applications.

As an ABAP _developer you might ask, what is important & necessary to know concerning ABAP development for SAP HANA? SAP HANA ABAP Training is aimed at answer this and other related questions.sap hana abap tutorial are prepared with best care & latest industry updates.

SAP HANA ABAP TRAINING ONLINE COURSE CONTENT

INTRODUCTION: SAP HANA ABAP TRAINING  Introductions to SAP HANA

 Introduction to ABAP on HANA

SYSTEM REQUIREMENT AND SYSTEM SET UP:  SAP HANA ADT Installation on HANA Studio  Overview of HANA studio

 Overview of ABAP development environment in eclipse  Adding system in HANA studio

 Creating package in HANA Studio

 Setup environment in eclipse for ABAP development  ABAP perspective in SAP HANA

ARCHITECTURE FOR ABAP FOR HANA  Evolution and architecture

 Overview for ABAP meets HANA  Code to data paradigm

ABAP DEVELOPMENT CHANGE FOR HANA  Coding guide line for ABAP On HANA  Performance Impact

 SQL Foot Prints in your productive system  Performance Analysis

 ALV For HANA and Other improvement NEW IN ABAP DEVELOPMENT ENVIRONMENT  Open SQL Enhancement

 Introduction to advance view building in ABAP for HANA  Core data service

 SAP HANA Usage in ABAP

 ABAP managed database procedure

 Core data service with input parameter

SAP HANA Overview :

 SAP HANA is an in-memory computing engine (IMCE) used for real-time processing of huge volumes of data and building and deploying real-world applications.

 Adopting the row-based and column-based DB technology, SAP HANA is an advanced relational DB product serviced by SAP SE.

 With this high-performance analytic (HANA) system, the big data exists on the main memory and not on the hard disk.

 It replaces the onus of data maintenance separately on the legacy system and simplifies the tasks of administrators in this digital world.

 SAP SLT works on trigger based approach; such approach has no measurable performance impact in the source system

 It offers filtering capability and transformation

 It enables real-time data replication, replicating only related data into HANA from non-SAP and SAP source systems

 It is fully integrated with HANA studios

 Replication from several source systems to one HANA system is allowed also from one source system to multiple HANA systems is allowed.

SAP HANA ABAP Training Overview:

 SAP HANA on the ABAP stack is available from Netweaver 7.4 and will allow your standard ABAP code to take advantage of the performance improvements for HANA.

 Applications such as BW will also will also have access to this and be able to harness the power of HANA.

 There are also standard improvements out of the box for functionality such as ALV.

 In-order to take advantage of this functionality you need to upgrade your databases to SAP HANA, but note you do not have to do this in-order to go to Netweaver 7.4 and beyond.

 SAP Advanced Business Application and Programming (ABAP) is a programming language used in the process of coding SAP R/3.

 SAP HANA can perform business calculations directly on the original data in the main memory without the need to transform data.

 When using ABAP 7.4 these views can then be imported to the ABAP Data Dictionary.

 The objective of the course is to increase the productivity and efficiency by introducing participants to numerous tools and techniques available in SAP ABAP.

 SAP ABAP on HANA training teaches how to detect and analyse the performance of ABAP coding and which features AS ABAP provides for database-oriented programming.

 ABAP lays the foundation for countless SAP applications, with a broad range of features and functionality for creating powerful business solutions.

 SAP HANA provides the opportunity to innovate with new and sophisticated technologies.

 With support package stack (SPS) 05 for SAP NetWeaver 7.4, SAP has brought ABAP and SAP HANA together with features that enable developers to leverage the best of both worlds, not only in new custom development projects, but also in their existing applications.

 All the features discussed can be easily explored using the Eclipse-based ABAP

development tools for SAP NetWeaver (known as ABAP in Eclipse), which provide many productivity features that can help developers in their daily development work.

SAP HANA ABAP Training Features and benefits:

SAP HANA ABAP Training – FEATURES:

 Extensive ABAP, Java & Hana instances monitoring

 24/7 real-time surveillance & daily reports

 Usage analysis for capacity planning

 Ready-to-use monitoring library

 Simple and flexible configuration interface

SAP HANA ABAP Training – BENEFITS :

 Quickly identify problems – even in large SAP landscapes

 Prevent downtime and ensure SLA compliance

 Continually improve SAP performance and response times

 Gain of productivity by automating monitoring tasks

 Can be used by non-SAP experts

Objective of SAP ABAP on HANA

 The Objective of SAP ABAP on HANA training is to increase the productivity and efficiency by introducing numerous techniques available in SAP ABAP.

 The sessions are interactive with extensive live examples with complete certification guidance.

 Students learn how to build core data services views in ABAP on HANA, how to implement and debug managed database procedures on SAP HANA and how to create FPM application consuming CDS view using ACT by expert trainers who are highly qualified in their respective domains.

What Will Learn at SAP HANA ABAP Training:

 Develop and optimize ABAP applications that access data stored in the SAP HANA database

Who Need to Attend SAP HANA ABAP Training:  Developers and development consultants

Roles involved with implementing or reviewing program code to optimize ABAP based applications for SAP HANA

PREREQUISITES for SAP HANA ABAP Training:

 BC400 – ABAP Workbench Foundations

 BC401 – ABAP Objects

 Experience in ABAP programing (procedural and object-oriented)Open SQL Details (joins, view, aggregations)

 HA150 – SQL Basics for HANA is highly recommended

 BC404 – ABAP Programming in Eclipse is highly recommended

Scope of ABAP ON HANA:

1. ABAP is a 4GL programming language with syntax originating from COBOL, updated with modern constructs like Object Oriented programming.

2. It is also the programming language that forms the basis of SAP R/3, Business Suite and NetWeaver software stacks.

3. All these SAP systems come with millions of lines of ABAP code as part of their core software stack.

4. SAP S/4HANA is a next-generation ERP based on SAP’s in-memory database, SAP HANA, and it is based on the code-base for the SAP Business Suite, ERP, and R/3 before it.

5. Much of it is rewritten to be optimized for SAP HANA, but the core programming language for S/4HANA remains ABAP.

6. In the cloud version of SAP S/4HANA, custom extensions are not possible in ABAP, but in the on-premises version of SAP S/4HANA, ABAP customizations are absolutely possible.

7. So in short, ABAP is just as pervasive in SAP S/4HANA as ever before, but depending on your implementation, it may be only the code used in the core rather than by custom code

developers.

SAP HANA ABAP Training outline:

 Course Name: SAP HANA ABAP Training course

 Duration of the course : 35 Hours

 Timings : According to one’s feasibility

 System Access : will be provided

 Batch : Regular , weekends and fast track

 Trainees will get the soft copy material in form of PDF OT WORD

 Sessions will be conduct through WEBEX, GOTOMEETING OR SKYPE.

 Basic Requirements for training Good Internet Speed, Headset

Benefits of SAP HANA ABAP Training

 Scenario Oriented SAP HANA ABAP Training

 Materials and server For SAP HANA ABAP Training

 Access For Hands-On

 Customized Course Agenda For SAP HANA ABAP Training

HANA Studio  HANA Overview  Tables Creation  Attribute Views  Standard Attributes  Derived Attributes  Time Attributes  Analytic Views  Joins  Calculated Columns  Restricted Columns  Variables  Input Parameters  Currency Translations  Hierarchies

 Different Types of Functions

 Calculation Views with Graphical

 Calculation Views with SQL Script

 Calculation Views with CE Functions

 Calculation View with Star Join

 Different Types of options in the Studio

 Auto Documentation

 Privileges  Decision Tables  Synonyms  Sequences  Views  Triggers