ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  AMDP - ABAP Managed Database Procedures 

AMDP - Use

AMDP methods can be used in ABAP programs as follows:

• AMDP procedure implementations

An AMDP procedure implementation is called from an ABAP program in the same way as any other ABAP Objects method.

• AMDP function implementations

• An AMDP function implementation for an AMDP scalar function is called in an ABAP program in the same way as any normal functional method.

• In an ABAP program, an AMDP function implementation for an AMDP table function is used by accessing an assigned CDS table function in an ABAP SQL read statement.

In all cases, this requires that the standard database of the current AS ABAP is managed by the database system for which the AMDP method is implemented. If not, a runtime error is produced.

Before the method is used for the first time, the ABAP runtime environment creates the procedure implemented in the AMDP method in the database system of the standard AS ABAP database or updates any existing database procedure or database function. Execution is performed in the database system and the interface parameters are passed from the Native SQL interface to the database system or applied by the database system itself.

Once a database procedure or database function (managed using AMDP) has been created on the database, this procedure can be used in other database procedures or database functions using the database syntax (provided that this is permitted by the database). These can themselves be AMDP procedures or AMDP functions, or database procedures or database functions not managed by AMDP. If an AMDP procedure or function uses another AMDP procedure or function, this procedure must be specified after the addition USING of the calling method.

Other versions: 7.31 | 7.40 | 7.54

Notes

• It is recommended that AMDP procedure implementations that are not to be called from the AMDP methods of other classes are created as private methods of an AMDP class and that they are called in a regular method (specified by the standard AS ABAP database). In database systems that do not support AMDP, a regular method can be created using an alternative implementation in ABAP SQL or Native SQL.

• For the calling program of an AMDP procedure implementation from ABAP, it is usually clear whether the method is an AMDP method and in which database system it is executed. For this reason, the implementation of the method must ensure that the interface parameters are returned in a format expected by the calling program. This is particularly important for ABAP types that do not have a corresponding type in the type system of the database system. These types must either be forbidden in the interface or an appropriate casting must take place in the procedure.

• Generally, the database procedures and database functions managed using AMDP are called using AMDP methods from ABAP only or in ABAP SQL.

• It is not advisable to make calls of AMDP-managed database procedures or database functions from non-AMDP-managed database objects or by using Native SQL. If, in exceptional cases, calls like this are necessary, all required database objects must exist. The public methods of the documented class CL_AMDP_RUNTIME_SERVICES can be used to do this (see ADBC, Stored Procedures).

• The constant CALL_AMDP_METHOD of the class CL_ABAP_DBFEATURES can be used to query whether the current database supports AMDP procedures.