Fully Integrate Your SAP HANA Database Procedures into ABAP with AMDP

  • by Sigrid Wortmann, ABAP Language Team, SAP SE
  • Christiane Kettschau, ABAP Language Team, SAP SE
  • December 21, 2015
ABAP Managed Database Procedures (AMDP) is a new technology to embed native database source code into ABAP applications. With the current focus on SAP HANA, ABAP developers now can use database features beyond the scope of Open SQL. AMDPs are available with SAP NetWeaver 7.40 Support Package 5 though some features described here require subsequent Support Packages.
Learning Objectives

Reading this article you will learn:

  • How to write native database procedures using the Eclipse-based ABAP Development Tools (ADT)
  • How to benefit from the full integration into the ABAP life cycle
  • How to analyze syntax and run-time problems in database procedures, which enables you to use AMDP productively
Key Concept

ABAP Managed Database Procedures offer an integration of native database source code into both the ABAP language and the ABAP development environment. This includes syntax checks and run-time error analysis as well as life cycle management.

Most ABAP developers have come across the need for native database access. For instance, they might need database features that are not in the scope of Open SQL or might want to optimize code for a particular database.

Now with ABAP Managed Database Procedures (AMDP) they have the ability to push down more complex application logic to the database. In contrast to earlier solutions this can be done in a well-structured and concise way.

In this article we introduce AMDP using the standard ABAP development environment. We explain the syntactical embedding and the interaction between the ABAP application server and the database engine, which helps developers to understand why and when certain syntax or run-time errors arise.

We troubleshoot database procedures with familiar ABAP tools, such as ABAP Debugger and ABAP Runtime Error Analysis, and outline enhancement capabilities and the integration into the Business Add-In (BAdI) framework.

Sigrid Wortmann

Sigrid Wortmann studied mathematics at the University of Münster/Westfalen, Germany. After receiving a Ph.D degree in mathematics at the University of Cologne (Germany), she worked for the University of Heidelberg, Germany. Sigrid joined SAP in 2005 as a member of the ABAP language team. In her role as development expert, she has been involved in several kernel projects. In particular, she is responsible for ABAP’s internal tables.

See more by this author

Christiane Kettschau

Christiane Kettschau is a member of the ABAP language team in the SAP NetWeaver organization. Christiane joined SAP in 1997, after graduating in mathematics at the University of Göttingen, Germany. Before joining the ABAP kernel team, she worked for several years in SAP's development support organization and as a developer in system life cycle management. Christiane is also responsible for the ABAP profiler and various parts of the ABAP kernel.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.