ABAP Managed Database Procedures (AMDP) are the preferred way for developing HANA DB procedures on the ABAP platform. AMDPs allow you as an ABAP developer to write database procedures directly in ABAP; Special ABAP classes (so-called AMDP classes) can contain embedded code (SQLScript) that is used to generate DB procedures in the HANA DB layer.
An AMDP class can contain both regular methods and AMDP methods. An AMDP class is defined as follows:
CLASS <class_name> DEFINITION ... PUBLIC. PUBLIC SECTION. INTERFACES: if_amdp_marker_<db>. "Tag interface ... ENDCLASS. CLASS <class_name> IMPLEMENTATION. ... METHOD <amdp_meth> BY DATABASE PROCEDURE FOR <db> LANGUAGE <db_lang> [OPTIONS <db_options>] [USING <db_entities>]. < SQLScript code > ENDMETHOD. ... ENDCLASS.
More on this: For syntax help, press F1 in the ABAP source editor.
As an ABAP developer you have the option to edit, enhance, and transport the database procedures in the same convenient way you are familiar with from standard ABAP classes. In addition, the AMDP Debugger that is part of the ADT client installation, allows you to debug the embedded AMDP code within the ABAP development IDE.
The AMDP Debugger is not part of the ABAP Debugger but an autonomous debugger:
If you want to debug native DB procedures (that are not generated from AMDP), you can use the HANA Studio Debugger instead. For further information, visit our community (SCN) page:
The AMDP Debugger provides you with the following basic functions: