ROADMAP OF ABAP ON HANA
ERP
smart Automation
ERP
ISO 9001:2015 Certied
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 Roadma
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 & Recover
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 Eclips
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 SWL
6.0 SQL SCRIPTS and ABAP SQL concepts for SAP HANA
6.1 SQL Clause New Feature
6.2 SQL Functions
6.3 Using Tuple Variables
6.4 Case Statements in SQL
6.5 Group By
6.6 Order By
6.7 IS NULL/ NOT NULL
6.8 Between
6.9 LIKE Predicat
6.10 Order Precedence
6.11 Aggregate Functions
6.12 UNION and UNION ALL
6.13 Joining Table
Inner Join
Left Outer Join
Right Outer Join
Full Outer Joi
6.14 Data Manipulation
Insert
Update
Delete
6.15 Data Denition
Create column table
Alter Table
Rename Table
Drop Table
7.0 Core Data Services
7.1 Core Data Services View Denition
7.2 CDS View on View
7.3 CDS View Extensions
7.4 CDS Views with Input Parameters
7.5 CDS Views Associations
7.6 Filtered Associations
7.7 CDS Annotations
8.0 ABAP Managed Database Procedures(AMDP)
9.0 OO ABAP List Viewer with integrated Dat
Access( IDA )
9.1 ABAP List Viewer (ALV) with Integrated Acces
to SAP HANA
SAP HANA Side Car Approaches
10.0 ADBC (ABAP DATABASE CONNECTIVITY) to
SAP HANA
10.1 Accessing SAP HANA tables from ABAP
10.2 Accessing SAP HANA Procedures from ABAP
10.3 Pros and Cons of ADBC
11.0 Secondary Database Connection to SAP HANA
11.1 Accessing SAP HANA tables from ABAP
11.2 Pros and Cons of Secondary DB Connectio
12.0 Creating SAP HANA Artifacts
12.1 Creating Packages
12.2 Creating Delivery Units
12.3 Creating SAP HANA Databas
(Column/Row tables)
12.4 Creating SAP HANA Database Views
12.5 Creating Authorization Objects
12.6 Load data into SAP HANA tables using CS
Files
12.7 Creating Sequences
12.8 Creating Synonyms
12.9 Creating SAP HANA Procedures
12.10 Creating SAP HANA Function
13.0 SAP HANA Views Creation
13.1 Attribute Views
13.2 Analytic Views
13.3 Analytic Privileges
13.4 Calculation Views
13.4.1 Graphical
13.4.2 Script
14.0 Stored Procedures
14.1 Creating the Stored Procedures
14.2 Debugging the stored Procedures
15.0 Consuming SAP HANA Views in ABAP
15.1 Working with Views in SAP HANA Studio
15.2 Consuming SAP HANA Views via Native SQL
15.3 Accessing SAP HANA Views via External
Views in ABA
16.0 Calling SAP HANA Database Procedures in ABAP
16.1 Working With Database Procedures in SAP HANA
Studio
16.2 Calling SAP HANA Procedures in ABAP
16.3 Calling SAP HANA Procedures via ABAP Databas
Procedure Proxies
17.0 Transport of SAP HANA Objects
17.1 SAP HANA Transport -- ABAP CTC
17.2 SAP HANA Transport -- Delivery Uni
Reporting Tools
18.0 Reporting Tools
18.1 Accessing the SAP HANA Views from Lumir
Reporting
18.2 Accessing the SAP HANA Views from Qlik Sense
18.3 Accessing the SAP HANA Views from Exce
Fe
25000/-
