SAP Training: Introduction to HANA Models with ADBC Programming
Introduction to HANA Models with ADBC Programming

IC0869

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:

Not Enough Reviews Yet

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

Audience

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


Lesson Plan

Lesson Description Preview
Welcome
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?
Quiz
Different TYPES of HANA INFORMATION Models
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
Quiz
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
Quiz
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



Instructor

Raju Shrestha

4.8 Average Rating

24 Reviews

119 Students

5 Courses

SAP ABAP (ex-IBM & creator of www.SAPYard.com)

Houston, TX, US

Raju is the founder of the popular SAP Technical knowledge sharing site www.SAPYard.com. 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:
21 Steps-Purchase Process Cycle in S/4HANA

  (5.0)

Debugging ABAP for SAP Functional Teams

  (4.8)

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

  (4.4)

Introduction to ABAP 7.4 in S/4HANA

  (5.0)



Student Feedback

Not Enough Reviews Yet




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

Share this course with a friend



SAP students

25

student views.
Join them!


SAP Student testimonial
The courses offered are very informative.
-Daniel  B.
RDC Operation Manager
Lennox International


Related Training


Training 10 or more people?

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

SAP Training for Businesses