AMDP- ABAP Managed Database Procedures

light111Database Procedures as ABAP Managed Database Procedures

With HANA Database, many options are available to write application logic at DB level which was not possible in earlier conventional databases. 

DATABASE PROCEDURE– These are queries written in using SAP HANA  SQL Script syntax and used to implement some application logic that allows multiple I/P & O/P parameters.

AMDP( ABAP Managed Database Procedure)– The HANA database procedure language SQL script been integrated in ABAP stack and idea of AMDP is to manage HANA procedures in the ABAP server and implemented in ABAP class methods also known as AMDP methods which servers as a container for SQL script code. 

In the context of ABAP development in SAP HANA, AMDP is one of good option for ABAP code optimization.

AMDP development(editing) is only supported in eclipse based development environment(ADT- ABAP Development tool) and not in GUI (class builder) but code view is possible in GUI.


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s