SAP ABAP On HANA Training Institute in Delhi Noida NCR
SAP ABAP On HANA Training Institute in Delhi Noida NCR
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
- SAP HANA as Secondary Database – Access via Open SQL
- Optimize Open SQL Access to SAP HANA
- Performance Rules and Guidelines for SAP HANA
- Database Interface
- Role of the Database for the ABAP Application Server
- Data Types, ABAP Database Access
- ABAP Data Dictionary
- Open SQL
- Database Views in the ABAP Data Dictionary
- Database Access via Native SQL
- Secondary Database Connections
- Analyzing Database Accesses Using the SQL Trace
- Statement Transformations
- Secondary Connections
Access to SAP HANA Using Native SQL and ADBC
- Open SQL and its Limitations
- ABAP Database Connectivity (ADBC)
- Native SQL Syntax
Consuming SAP HANA Views in ABAP
- Working with Views in SAP HANA Studio
- Consuming SAP HANA Views via Native SQL
- Accessing SAP HANA Views via External Views in ABAP
- Dictionary
Calling SAP HANA Database Procedures in ABAP
- Working With Database Procedures in SAP HANA Studio
- Calling SAP HANA Procedures in ABAP
- Calling SAP HANA Procedures via ABAP Database Procedure
- Proxies
Advanced Topics
- Full Text Search in SAP HANA
- ABAP List Viewer (ALV) with Integrated Access to SAP HANA
- Transport of SAP HANA Objects
- Working With Database Procedures in SAP HANA Studio