Course Content
ABAP on HANA TRAINING and SAP
HANA SPS 10
SAP ABAP HANA new content
1.0 Introduction to SAP HANA
1.1 Evolution of HANA
1.2 Introduction to SAP HANA
1.3 Introduction to SAP In-Memory Strategy and
Technology
1.4 HANA compare to BWA
1.5 SAP HANA Landscape
1.6 SAP In-Memory Computing Product Strategy and
Roadmap
2.0 SAP HANA STUDIO Look
& Feel
2.1 In-Memory Computing
Studio
2.2 Administration view
2.3 Navigator View
2.4 System Monitor
2.5 Information Modeler
3.0 SAP HANA Architecture
3.1 Architecture Overview
3.2
IMCE and Surroundings
3.3 Row Store
3.4 Column Store
3.5 Loading data into HANA
3.6 Data modeling concepts
3.7 Reporting
3.8 Persistent Layer
3.9 Backup & Recovery
4.0 Introduction to
Development Environment – SAP HANA STUDIO
4.1 Overview of Eclipse
4.2 SAP’s Eclipse Strategy
4.3 Unbundling of Eclipse and SAP Software
4.4 Central Update Site
4.5 Installing the Development Environment
4.6 Installing SAP HANA Studio
4.7 Installing the ABAP Development Tools for SAP
NetWeaver
4.8 Getting Started in the Development System
4.9 Basic Principles of Eclipse
5.0 Performance Tools in SAP
HANA
5.1
Understand the Runtime Analysis (SE30)
5.2
Understand the ABAP Trace (SAT)
5.3
Understand the Code Inspector (SCI)
5.4
Understand the SQL Trace (ST05)
5.5
SQLM and SWLT
6.0 Migration concepts and
Prerequisites on EHP7 on HANA Database
6.1 Changes need to be done in the Custom reports
7.0 SQL SCRIPTS Programming
and ABAP SQL concepts for SAP HANA
7.1 SQL
Clause New Feature
7.2 SQL
Functions
7.3 Using
Tuple Variables
7.4 Case
Statements in SQL
7.5 Group
By
7.6 Order
By
7.7 IS
NULL/ NOT NULL
7.8 Between
7.9
LIKE Predicate
7.10 Order Precedence
7.11 Aggregate Functions
7.12 UNION and UNION ALL
7.13 Joining Table
Inner Joinà
Left Outer Joinà
Right Outer Joinà
Full Outer Joinà
7.14 Data Manipulation
Insertà
Updateà
Deleteà
7.15 Data Definition
Create column tableà
Alter Tableà
Rename Tableà
Drop Tableà
8.0 Core Data Services
8.1 Core Data Services View Definition
8.2 CDS View on View
8.3 CDS View Extensions
8.4 CDS Views with Input Parameters
8.5 CDS Views Associations
8.6 Filtered Associations
8.7 CDS Annotations
9.0 ABAP Managed Database
Procedures(AMDP)
9.1 AMDP debugging using GUI and Eclipse Studio
10.0 OO ABAP List Viewer with
integrated Data Access( IDA )
10.1 ABAP List Viewer (ALV) with
Integrated Access to SAP HANA
SAP HANA Side Car Approaches
11.0 ADBC (ABAP DATABASE
CONNECTIVITY) to SAP HANA
11.1 Accessing SAP HANA tables from ABAP
11.2 Accessing SAP HANA Procedures from
ABAP
11.3 Pros and Cons of ADBC
12.0 Secondary Database
Connection to SAP HANA
12.1 Accessing SAP HANA tables from ABAP
12.2 Pros and Cons of Secondary DB
Connection
SAP HANA ANALYTICS
13.0 Creating SAP HANA
Artifacts
13.1
Creating Packages
13.2 Creating Delivery Units
13.3
Creating SAP HANA Database(Column/Row tables)
13.4
Creating SAP HANA Database Views
13.5
Creating Authorization Objects
13.6
Load data into SAP HANA tables using CSV Files
13.7
Creating Sequences
13.8
Creating Synonyms
13.9
Creating SAP HANA Procedures
13.10 Creating
SAP HANA Functions
14.0 SAP HANA Views Creation
14.1 Attribute Views
14.2 Analytic Views
14.3 Analytic Privileges
14.4 Calculation Views
14.4.1 Graphical
14.4.2 Script
15.0 Stored Procedures
15.1 Creating the Stored Procedures
15.2 Debugging the stored Procedures
16.0 Consuming SAP HANA Views
in ABAP
16.1
Working with Views in SAP HANA Studio
16.2
Consuming SAP HANA Views via Native SQL
15.3
Accessing SAP HANA Views via External Views in ABAP
17.0 Calling SAP HANA
Database Procedures in ABAP
17.1 Working with Database Procedures in SAP
HANA Studio
17.2 Calling SAP HANA Procedures in
ABAP
17.3 Calling SAP HANA Procedures via
ABAP Database
Procedure Proxies
18.0 Transport of SAP HANA
Objects
18.1 SAP HANA Transport -- ABAP CTC
18.2 SAP HANA Transport -- Delivery
Unit
19.0 XS ODATA Services
19.1 Exposing tables and views
19.2 Defining relationship between tables
Reporting Tools
20.0 Reporting Tools
20.1 Accessing the SAP HANA Views from
Lumiro Reporting Tool
20.2 Accessing the SAP HANA Views from
Qlik Sense Reporting Tool
20.3 Accessing the SAP HANA Views from
Excel
for more details Contact us:
Ambati,
gettrainingwithme@gmail.com,
+91-7799542066.
