SAP Training: Introduction to HANA Models with ADBC Programming

Introduction to HANA Models with ADBC Programming

In this course, you will learn the clear differences and use cases for HANA Views through discussion and live demo examples. If you do not know how to consume HANA Views in SAP or you do not know how to connect to HANA Database & retrieve data using Models (Views), then this course is a must for you. This course includes code samples for download.

In this course you will learn:

1  Reviews    5.0 of 5.0

Course Goal

  • Introduce the participants to HANA Information Models
  • Learn how to consume HANA Models and View Proxys in ABAP Programs
  • Learn about HTC HANA Transport Container
  • Learn ADBC Programming for S/4HANA ABAP
  • Understand Analytical Calculation Views


  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members

Lesson Plan

Lesson Description Preview
1 Introduction and Course Goals Preview
2 Meet your Instructor
HANA Information Model (HANA View) Concepts
3 What is the need of an Information Model?
4 What does an Information Model look like?
5 What are the different types of Information Models?
6 What are the different types of Data in SAP ERP?
7 What are the different types of Engines in HANA?
8 What are Dimension, KPI, Fact and Measure?
9 Some Examples of Dimensions and Facts
10 What is the Star Schema in HANA?
11 What is an Attribute View?
12 Example - Attribute View
13 Example - Join of an Attribute View with Sample Output
14 What is an Analytical View?
15 Example - Analytical View
16 Example - Join of an Analytical View with Sample Output
17 Graphical Representation & Analysis of an Analytical View
18 What is a Calculation View?
19 Example - Calculation View
20 Example - Join of a Calculation View with Sample Output
Hands on Exercise Demos
21 Welcome to Part 2 - The Hands On Session
22 How do we consume HANA Models in SAP ABAP?
23 What is View Proxy?
24 Are HANA Models & View Proxies Equivalent?
25 Taking a look at the steps to Create View Proxy
26 Exercise 1 - Create your first View Proxy / Demo in HANA Studio
27 Exercise 2 - Check View Proxy in GUI / Demo in HANA Studio
28 Tak a look at the steps to Display View Proxy Data in GUI & in ADT
29 Exercise 3 - Display View Proxy Data in GUI & ADT / Demos
30 Why can we NOT display data for some View Proxy in SE16?
31 Why we cannot Preview Data for some View Proxy in ADT as well?
32 Exercise 4 - Synchronize HANA Model changes in View Proxy
33 FYI - Introduction to ABAP7.4 for S/4HANA Course at MMC
34 Exercise 5 - Consume HANA View Proxy in ABAP Program
35 How are HANA Models Transported across SAP Landscape?
36 Graphical Explanation of Transport of HANA Models
37 Problems & Solution for HANA Model Transport Issues
38 What is HANA Transport Container (HTC)?
39 What is ADBC (ABAP DataBase Connectivity)?
40 8 Common Steps used in ADBC Programming
41 Exercise 6 - ADBC Programming in ECC 6 - DEMO 1
42 Exercise 6 - ADBC Programming in ECC 6 - DEMO 2
43 Exercise 7 - ADBC Programming with ABAP 7.4 non-HANA DB - DEMO
44 Exercise 8 - ADBC in S/4HANA & Debug all 3 Programs - DEMO
45 Exercise 9 - End to End ADBC Programming - DEMO 1
46 Exercise 9 - End to End ADBC Programming - DEMO 2
47 Exercise 10 - End to End Debugging of ADBC in S/4HANA - DEMO
48 Salient Features of ADBC
Take Away from the Course and Wrap Up
49 Course Summary
What Next? Action Plan for the Participants
50 What Next?
Custom Program Code Snippets from the Course
51 End to End ADBC Program in S/4HANA
Course Hand Out PDF
52 Course Hand Out PDF


Raju Shrestha

4.8 Average Rating

33 Reviews

155 Students

5 Courses

Top Instructor with 5 live courses
Top Rated Courses

SAP ABAP (ex-IBM & creator of

Houston, TX, US

Raju is the founder of the popular SAP Technical knowledge sharing site He is an ABAP Consultant with more than 12 years of experience, who has helped clients in Automation, Heavy Machinery, Pharma, and Energy Industries. Groomed and Trained by the Big Blue i.e. IBM, where he served 8 years in different capacities viz Application Programmer, System Engineer, Team Lead and Advisory System Associate. Part of the Innovation Team who developed Automation Tools and Products. Official trainer at IBM Learning and Knowledge (L&K) Department. He is an enthusiast in SAP HANA, Odata and SAP Netweaver Gateway with a special interest in SAPUI5 and Fiori.

More Courses by Raju Shrestha:
Debugging ABAP for SAP Functional Teams


21 Steps-Purchase Process Cycle in S/4HANA


Introduction to ABAP 7.4 in S/4HANA


Create, Test, Debug & Analyze Your First SAP OData Service


Annual Subscription to All Courses


Or subscribe to this individual course for

Student Feedback


Average Rating







Annual Subscription to All Courses


Or subscribe to this individual course for

Language: English
Level: Intermediate
Duration: 4.00 hours
Type:  Instructor-led
Delivery: Online, instructor-led
Release: ECC 6.0
Category: ABAP

Share this course with a friend

SAP students


student views.
Join them!

SAP Student testimonial
It`s a very simple and intuitive e-learning site. Well done.
-Marco  S.

Thai Union Group PCL

Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses