Nothing Special   »   [go: up one dir, main page]

Abap Hana

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

ABAP HANA

(Mandatory Future Module for ABAPERS)


@

GENSOFT Technologies GENSOFT SYSTEMS Fees: 6000/- (Class-room)


Plot No 28, Second
Office Floor,((oNL
Address: 8000 /- (On-line)
Behind HUDA (45 hrs)
Plot No 28, Ground Floor, SAP Street,
470-460 / 9848-985-270
Behind HUDA Mythrivanam Lane, Ameerpet, Hyderabad,
Telangana, INDIA
Mobile: dd
9246-550-660
E-mail: info@gensofthyderabad.com
Website: www.gensofthyderabad.com
Powered By:  INDEPTH
Mr. Sridhar Sunkari  UNCOMPARABLE
(19+ yrs Exp.)  SUBJECT GUARANTEED
On-line Training Only

 Leader in SAP Technical Modules Training


 Trained 1000’s of students both in On-line and Class-room and also conducted
Corporate Trainings for the IT COMPANIES which includes TCS, WIPRO, CMC, VERIZON,
GENPACT, SIERRA ATLANTIC, VOLKSWAGON, INDIAN RAILWAYS and many more…
 Program Delivered by Real-Time consultant - SRIDHAR SUNKARI having over 19+ yrs
of experience in different SAP and NON-SAP technologies
 Real-time Scenarios with In-depth and Advanced Topics covered
 Numero Uno in SAP Technical Modules training which includes BASIC ABAP, OOPS
INDEPTH OBJECT-ORIENTED ABAP
ABAP, CROSS APPLICATIONS, ABAP HANA, WEBDYNPRO, SAP UI5 (FIORI Apps Development)
 Detailed Day-wise notes will be shared, need not depend on any other material

INDEPTH OBJECT-ORIENTED ABAP
As an additional service, Day-wise recordings will be shared for preview during
the course period
 Most of our old students are working in TOP IT COMPANIES worldwide; we welcome
you to take the feedback before registering for any courses @ Gensoft
Technologies
 To attend online 2nd time for the same module, participants need to register again

1
ABAP HANA
(PRE-REQUISITES: ABAP PROGRAMMING)

SAP HANA Introduction


Features and Architecture of HANA Database

ABAP HANA Introduction


Role of ABAP consultants in SAP HANA
Data to Code Vs Code to Data Approach
Introduction to HANA Studio

Native HANA Development


Introduction to SQL and Database Objects
Schema
Row Store Table Vs Column Store Table
Database Tables – CRUD Operations
Transaction Control Statements
Order By, Group By, Having, Where Clauses
Primary key and Foreign Key Constraints
Global Vs Local Temporary Tables
Defining and Managing Triggers
Sequences
Synonyms
Altering Database Objects
Table Types
Procedures
Functions
Temporary Internal Tables
Conditional and Looping statements
Cursors
Exception Handling
Views
Arrays
Joins
Indexes
SQL Functions

STORED PROCEDURES
Creating Stored Procedures
Creating Database Procedure Proxies
Consuming Stored Procedure from ABAP Reports
Scalar Functions
Table Functions

2
ADBC (ABAP DATABASE Connectivity)
Introduction to ADBC Framework
Consuming Select Queries in ABAP Reports using ADBC
Parameter Binding in Queries using ADBC
Consuming Stored Procedures using ADBC
Parameter Binding in Stored Procedures using ADBC
Accessing DDL and DML statements using ADBC

AMDP (ABAP Managed Database Procedures)


Introduction to AMDP and ADT
Creating AMDP’s
Consuming AMDP’s from ABAP Reports
AMDP Vs Stored Procedures
Passing Parameters to AMDP
Select-option functionality in AMDP

IDA (Integrated Data Access)

Traditional ALV Vs ALV IDA


Report Development using ALV IDA
Interactive ALV Reporting using ALV IDA
Manipulating Field catalog and Toolbar in ALV IDA
Selection-Conditions in ALV IDA

CDS (CORE DATA Services)


Introduction and Components of CDS Views
CDS simple views
Consuming CDS views from ABAP Reports and ALV IDA Reports
CDS views with parameters
CDS Views with Functions and Arithmetic Expressions
CDS Views with Joins and Associations
CDS view Implemented in AMDP Table Functions
Exposing CDS Views as ODATA Service
Consuming CDS views in UI5
View on View
CDS View Extension

HANA MODELING

Introduction to HANA Modeling


Creating Attribute, Analytic, Graphical Calculation Views
Creating External Views for HANA Modeling Views
Consuming External Views from ABAP Reports
Creating Graphical Calculation views integrating with Table Functions

You might also like