// Require https if ($_SERVER['HTTPS'] != "on") { $url = "https://". $_SERVER['$_godaddy.com'] . $_SERVER['https://www.terasconsulting.com']; header("Location: $https://www.terasconsulting.com"); exit; }
Request For A Demo

SAP ABAP On HANA Training Institute in Delhi Noida NCR

111.gif

Course Goals

This course will help the participant to Develop and optimize ABAP applications that access data stored in the SAP HANA Database

Target Audience

This course is intended for Developers and development consultants who need to write or review performance-optimized ABAP code for SAP HANA.

Course Prerequisites

Required Knowledge

• HANA Overview

• ABAP Workbench Fundamentals

• ABAP Objects

• Experience in ABAP Programming ( procedural and object oriented)

• Open SQL details (joins, views, aggregations)

Course Objectives

After completing this course, the participant will be able to:

• Understand the technical concepts of SAP HANA

• Understand how to optimize classic ABAP for SAP HANA

• Describe the use of analysis tools for performance optimization (Runtime Analysis, Code Inspector, SQL Trace, SQL Performance Tuning Worklist)

• Understand the SQL performance rules of ABAP for SAP HANA

• Access SAP HANA from ABAP using native SQL and ADBC (ABAP Database Connectivity)

• Use enhanced Open SQL

• Use Core Data Services in ABAP to define advanced views

• Call SAP HANA stored procedures in ABAP and embed stored procedures in ABAP

• Consume SAP HANA views in ABAP

Course Content

Taking ABAP to HANA

  1. SAP HANA as Secondary Database – Access via Open SQL
  2. Optimize Open SQL Access to SAP HANA
  3. Performance Rules and Guidelines for SAP HANA
  4. Database Interface
  5. Role of the Database for the ABAP Application Server
  6. Data Types, ABAP Database Access
  7. ABAP Data Dictionary
  8. Open SQL
  9. Database Views in the ABAP Data Dictionary
  10. Database Access via Native SQL
  11. Secondary Database Connections
  12. Analyzing Database Accesses Using the SQL Trace
  13. Statement Transformations
  14. Secondary Connections

Access to SAP HANA Using Native SQL and ADBC

  1. Open SQL and its Limitations
  2. ABAP Database Connectivity (ADBC)
  3. Native SQL Syntax

Consuming SAP HANA Views in ABAP

  1. Working with Views in SAP HANA Studio
  2. Consuming SAP HANA Views via Native SQL
  3. Accessing SAP HANA Views via External Views in ABAP
  4. Dictionary

Calling SAP HANA Database Procedures in ABAP

  1. Working With Database Procedures in SAP HANA Studio
  2. Calling SAP HANA Procedures in ABAP
  3. Calling SAP HANA Procedures via ABAP Database Procedure
  4. Proxies

Advanced Topics

  1. Full Text Search in SAP HANA
  2. ABAP List Viewer (ALV) with Integrated Access to SAP HANA
  3. Transport of SAP HANA Objects
  4. Working With Database Procedures in SAP HANA Studio
We also provide online training on SAP ABAP On HANA, SAP S4 HANA, SAP HANA ADMIN, SAP BASIS ON HANA, SAP BI ON HANA, SAP HANA, SAP ABAP, SAP BASIS, SAP BI, SAP BO, SAP CIN, SAP CRM, SAP FICO, SAP FIORI, SAP SIMPLE FINANCE, SAP IS RETAIL, SAP MM, SAP SD, SAP HR, SAP Successfactors, SAP UI5, SAP HCM, SAP SCM, SAP SECURITY, SAP CO, SAP PI, SAP PS, SAP PM, SAP PP, SAP QM, SAP EWM, SAP ISU, SAP MDM, SAP NET WEAVER, SAP BPC, SAP SRM, SAP WEB DYNPRO, SAP AFARIA, SAP WM, SAP AWS, SAP APO, SAP CUSTOMER SERVICE, SAP EHS, SAP EP, SAP FM, SAP FSCM, SAP GRC, SAP OIL, SAP TRM, SAP WORKFLOW, SAP GST, SAP SIMPLE LOGISTICS and all modules.