SAP ABAP On HANA

Home SAP ABAP On HANA

Course Content

1  Introduction to  SAP HANA Technical Concepts, ADT, HANA Studio

  •   Architectural Scenarios
  •  SAP HANA as Database for other Applications
  •  SAP HANA HW and SW Technology
  •  Row Store Vs Column Store
  •  Data Compression
  •  Parallel processing
  •  When to Use Row and Column Store
  •  Classical Vs New Approach
  •  Introduction to HANA Studio

 

2  Introduction to Core Data Services

  •  Paradigm Changes
  •  CDS Enablement
  •  What are Core Data Services ?
  •  Core Data Services – ABAP
  •  Bottom Down
  •  Top Down approach
  •  ABAP CDS Architecture
  •  ABAP CDS Views

 

3  CDS SQL Features

  •  General and Enhanced features
  •  Simple CDS View ABAP CDS Entity
  •  Case Expressions in CDS Views
  •  ABAP CDS Literals
  •  Joins in CDS Views
  •  Aggregation, Grouping, Filtering Groups

 

4  Advanced Concepts in CDS

  •  Annotations in CDS Views
  •  Unions in CDS Views
  •  Consuming CDS Views
  •  View on View
  •  View Extensions
  •  ABAP CDS Associations
  •  Path Expressions
  •  Filter Expressions
  •  View with Input parameters

 

5  Different ways of exposing CDS Views as OData Service

  •  Expose CDS Views as OData Service Type 1
  •  Expose CDS as OData Service Type 2
  •  Expose CDS as OData Service Type 3
  •  Where CDS Views are used?

 

6  New Open SQL Features

  •  New Features in Open SQL
  •  Few Limitations Removed
  •  New Open SQL SELECT

 

7  Taking ABAP to SAP HANA

  •  SAP HANA as Secondary DB Connection
  •  Tools to Analyze potential functional and performance issues in ABAP Programs
  •  Guided Performance Analysis
  •  Performance Rules and Guidelines for SAP HANA

 

8  Code to Data with SAP HANA as Secondary Database

  •  Paradigm Changes
  •  Open SQL
  •  ABAP Database Integration
  •  Limitations of Open SQL in ABAP < 7.4
  •  ABAP Database Connectivity ADBC
  •  Use of ADBC
  •  Native SQL in ABAP
  •  Testing native SQL in HANA studio

 

9  HANA Artifacts, HANA Studio

  •  Bottom up approach AS ABAP < 7.40
  •  Search functions in HANA Studio
  •  HANA Views
  •  Consuming HANA Views via Native SQL
  •  Database Procedures in HANA Studio
  •  Calling HANA Procedures in ABAP

 

10  Using ABAP Managed Database Procedures

  •  Top Down approach ABAP 7.4
  •  AMDPs
  •  CDS Table Functions ABAP NW 7.5
  •  AMDP Sample method

11  SAP HANA Proxy Objects

  •  Bottom up approach AS ABAP < 7.40
  •  External Views
  •  Creating External View in ADT
  •  Data type mapping between HANA and ABAP Dictionary
  •  Access HANA Views via ABAP External Views
  •  HANA Transport Container
  •  Calling SAP HANA Procedures in ABAP Procedure Proxies in ABAP 7.4
  •  Database Procedure Proxies
  •  Creating Database Procedure Proxy in ADT
  •  Data type mapping between HANA and ABAP Dictionary
  •  Access DB Procedure Proxy in ABAP
  •  Code to Data Techniques Preferences

 

12  Debugging in ABAP Development tools(ADT)