sgitinfo123@gmail.com

📘 SAP ABAP on HANA Training Content Outline

1. Introduction to SAP HANA
What is SAP HANA?
Architecture Overview
Key Features of SAP HANA
In-Memory Computing and Columnar Storage
Evolution from Classic ABAP to ABAP on HANA

2. Overview of ABAP for SAP HANA
What is ABAP on HANA?
Benefits of Code Pushdown
Classical vs. HANA-Optimized ABAP
Tools: Eclipse (ADT), SAP GUI, HANA Studio

3. Setting Up Development Environment
Installation of ABAP Development Tools (ADT)
Navigating Eclipse for ABAP
Package, Class, and CDS View Management in Eclipse

4. Code Optimization for SAP HANA
Performance Tuning Techniques
Expensive SQL Statements Analysis
SQL Trace (ST05), SAT, and Runtime Analysis
Using SQL Monitor (SQLM)
Best Practices in ABAP for HANA

5. Core Data Services (CDS Views)
Introduction to CDS in ABAP
Types of CDS Views: Basic, Composite, Consumption
CDS Annotations and Metadata Extensions
Associations and Path Expressions
Parameterized CDS Views
CDS with UI Annotations (Fiori)

6. AMDP (ABAP Managed Database Procedures)
What is AMDP?
Creating and Implementing AMDP Classes and Methods
SQLScript Basics for AMDP
Calling AMDP from ABAP
Exception Handling in AMDP

7. Advanced Open SQL
Enhancements in Open SQL for HANA
Inline Declarations
Aggregate Functions and Joins
Up to Date Expressions
Group By, Having, and Case Expressions

8. Performance Techniques
Code Pushdown Strategy
Avoiding Nested Loops
Buffering and Caching Considerations
Using HINTS for Optimized Execution
Table Functions in HANA

9. CDS Views with Annotations
UI Annotations for Fiori Apps
OData Exposure of CDS Views
Analytical Annotations
Value Help and Search Annotations

10. ALV with IDA (Integrated Data Access)
What is ALV IDA?
Benefits over Classical ALV
Creating ALV Reports Using IDA
Integration with CDS Views

11. HANA Modeling Basics (Optional for ABAP Developers)
Attribute, Analytic, and Calculation Views (Read-only)
Using HANA Views in ABAP via External Views

12. Transport Management
Transport of CDS Views and AMDP
Handling Transport Requests in Eclipse

13. Real-Time Project Scenarios
End-to-End CDS and AMDP-Based Reporting
Optimization of Legacy ABAP Code for HANA
Real Case Studies and Hands-On Practice
Debugging AMDP and CDS-based Programs

14. Tools for Monitoring & Debugging
ABAP Test Cockpit (ATC) for HANA Compliance
SQL Performance Tuning Worklist
Code Inspector with HANA Checks
Runtime Analysis Tools

15. Best Practices and Upgrade Considerations
Migration from ECC to S/4HANA – ABAP Impact
Code Remediation Techniques
Naming Conventions and Modularization
Notes and SAP Guidelines for ABAP on HANA