TLDR;
Namaste everyone! This video is an introduction to ABAP Managed Database Procedures (AMDP). It covers what AMDP is, why it's needed, and some important points to remember while working with it. Key takeaways include:
- AMDP allows you to run SQL script code within ABAP classes, pushing data-intensive operations to the HANA database for better performance.
- AMDP works on a top-down approach and was introduced after the 7.4 version of SAP.
- AMDP classes must implement the
IF_AMDP_MARKER_HDBinterface and can only be created using ABAP Development Tools (ADT) like HANA Studio or Eclipse.
Introduction to AMDP [0:32]
AMDP stands for ABAP Managed Database Procedure. It's basically a method within a standard ABAP class (created using SE24) that contains SQL script code. When you call this AMDP method for the first time, a procedure gets created in the corresponding ABAP schema within your HANA database. AMDP follows a top-down approach and was introduced after the 7.4 version of SAP. Using AMDP, you don't need to connect directly to the HANA server; changes can be done from the application server itself. AMDP is a replacement technology for database procedure proxies.
Why do we need AMDP? [7:16]
The main idea behind AMDP is to manage SAP HANA procedures and their lifecycle directly within the ABAP server. It allows native consumption of SAP HANA features within the ABAP layer. The SQL script language has been integrated into the ABAP stack. AMDP is implemented in ABAP class methods, which act as containers for the SQL script code. This approach enables the shipment of AMDP in the same way as any other ABAP development object and allows for implementing SAP Corrections for AMDPs, just like for ABAP classes.
AMDP Class Explained [12:29]
An AMDP class must implement the interface IF_AMDP_MARKER_HDB. This interface is a marker interface for database procedures. An AMDP class can contain both AMDP methods and non-AMDP methods. Non-AMDP methods are normal class methods. AMDP methods contain specific declarations, including specifying the database type (HDB for HANA), the language (SQL script), and using dictionary artifacts.
Important Notes about AMDP [17:25]
An AMDP class can only be created using ABAP Development Tools (ADT), such as HANA Studio or Eclipse. You cannot create an AMDP class from the SC24 transaction code, which is used for creating normal global classes. You also cannot make changes to an existing AMDP class from SC24; you can only view it. When you call an AMDP method, a database procedure is automatically created in the HANA database server. Remember, AMDP can only be created if your database is HANA.
