Description

Introduction

Core Data Services (CDS) and ABAP Managed Database Procedures (AMDP) are two powerful techniques that allow ABAP developers to leverage the full performance capabilities of the SAP HANA database.
CDS provides a data modeling infrastructure for defining semantically rich database views, while AMDP enables developers to execute database procedures directly in HANA using SQLScript.
This training explores both concepts in depth — helping participants design, implement, and optimize data models and database logic efficiently using modern ABAP for SAP HANA.

Prerequisites

Participants should have:

• A good understanding of ABAP programming and Open SQL

• Basic familiarity with SAP HANA concepts and Eclipse-based ABAP Development Tools (ADT)

• Knowledge of data dictionary objects and database tables

• Experience with SAP NetWeaver or S/4HANA environment

Table of Contents

1. Introduction to CDS and AMDP
1.1 Overview of data modeling in SAP HANA
1.2 Importance of CDS and AMDP in modern ABAP development
1.3 Comparison of classic ABAP data access vs. HANA-optimized techniques
1.4 Key benefits of using CDS and AMDP for performance optimization

2. Understanding Core Data Services (CDS)
2.1 Concept and architecture of CDS in ABAP
2.2 Differences between database views and CDS views
2.3 Role of CDS in ABAP Data Modeling

3. Creating and Managing CDS Views
3.1 CDS view syntax and structure
3.2 Defining fields, joins, and associations
3.3 Using annotations for UI, authorization, and analytics
3.4 Managing CDS views in Eclipse (ADT)
3.5 Example: Creating a basic CDS view on MARA and VBAK tables

4. Advanced CDS View Concepts
4.1 Parameterized CDS views
4.2 Using expressions, CASE, and aggregations
4.3 Creating associations and path expressions
4.4 Chained and nested CDS views
4.5 Extending standard CDS views with CDS view extensions

5. Analytical and Hierarchical CDS Views
5.1 Creating analytical CDS views for reporting
5.2 Hierarchies and data aggregation
5.3 Using annotations for analytical queries
5.4 Example: Building a sales performance dashboard CDS view

6. Consuming CDS Views in ABAP
6.1 Accessing CDS views using Open SQL
6.2 Integrating CDS views into ABAP reports and programs
6.3 Using CDS views in OData services and SAP Fiori applications
6.4 Debugging and analyzing CDS-based applications

7. Introduction to ABAP Managed Database Procedures (AMDP)
7.1 Overview of SQLScript and procedural logic in HANA
7.2 Role of AMDP in ABAP-HANA integration
7.3 Syntax and structure of AMDP methods
7.4 AMDP lifecycle and execution process

8. Creating and Implementing AMDP
8.1 Defining AMDP classes and interfaces
8.2 Passing parameters to AMDP methods
8.3 Executing AMDP methods from ABAP programs
8.4 Handling SQLScript syntax errors and debugging
8.5 Example: Implementing an AMDP for order total calculation

9. Advanced AMDP Techniques
9.1 Managing multiple result sets in AMDP
9.2 Using temporary tables and table variables
9.3 Integrating CDS views within AMDP methods
9.4 Performance considerations for complex logic
9.5 Comparing AMDP and CDS for specific use cases

10. Best Practices for CDS and AMDP Development
10.1 Choosing between CDS and AMDP for data processing
10.2 Avoiding redundancy in database access
10.3 Naming conventions and documentation standards
10.4 Transport and activation considerations
10.5 Testing and performance optimization

11. Hands-on Exercises
11.1 Creating and consuming a CDS view for material data
11.2 Building a parameterized CDS view for order analysis
11.3 Writing an AMDP to process sales data using SQLScript
11.4 Integrating CDS and AMDP in a real-world use case

The Core Data Services (CDS) Views and AMDP in ABAP training provides ABAP developers with in-depth knowledge of HANA-optimized data modeling and procedural processing.
By mastering CDS, developers can build semantically rich and reusable data models, while AMDP enables the execution of complex database logic directly in HANA for maximum performance.
This course equips participants with the skills to design, implement, and maintain efficient, scalable, and high-performing SAP HANA-based ABAP applications in modern enterprise environments.