In this SAP ABAP video tutorial, the author explains how to implement ABAP Managed Database Procedures (AMDP) in SAP. Here’s the list of topics covered in video:
- Introduction to AMDP: The video begins with an explanation of AMDP and its advantages. AMDP allows developers to write database procedures and functions directly in ABAP, using SQLScript for HANA databases.
- Creating an AMDP Class: The presenter demonstrates how to create an AMDP class in Eclipse, an IDE tool used for AMDP development. The class is initially created as a normal ABAP class, which is then converted to an AMDP class by implementing the IF_AMDP_MARKER_HDB interface.
- Creating Methods: The presenter shows how to create methods within the AMDP class. These methods can be either AMDP methods or normal methods. The presenter creates a simple method first, then modifies it to be an AMDP method.
- Writing SQLScript: The presenter explains how to write SQLScript within the AMDP methods. He demonstrates how to select specific fields from a database table and how to use the GROUP BY clause to aggregate data.
- Creating a Report Program: The presenter creates a report program to call the AMDP method. He demonstrates how to instantiate the AMDP class and call its methods.
- Debugging: The presenter shows how to debug the report program and the AMDP method. He explains that the AMDP debugger is used when the control is within the AMDP method, and the ABAP debugger is used otherwise.
- Displaying Output: The presenter runs the report program and displays the output in the console. He shows the top 10 customers based on the net amount of their sales orders.
- Important Points: The presenter discusses some important points about AMDP, such as the fact that AMDP methods cannot be empty, that they cannot have a RETURNING parameter if they are AMDP procedures, and that they cannot perform operations on database tables where buffering is switched on.