ABAP Managed Database Procedures (AMDP)
Limitations
You can create database procedure in Hana database and if you want to consume it in ABAP then every time you have to create a proxy in ABAP layer.
After creating a proxy, if you change underlying database procedure then you have to sync those changes in proxy manually.
Transporting from one system to another is a challenge since you have to transport both the objects database procedure and proxy together which are created in different packages.
While creating database procedure HANA data types are used and when you create a proxy, those HANA data types are converted into ABAP data types. However there are certain HANA data types for which there is no corresponding matching ABAP data types. Example VARCHAR. So if you use such data types while creating a database procedure, the system throws an error while creating a proxy.
-Sanjana