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.
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
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.
Would you like to see this full item?