AMDP on #S4 HANA

Mayank Chourasia
2 min readMay 13, 2024

--

In this blog I will discuss AMDP.

What is AMDP?

ABAP Managed Database Procedures (AMDP) helps to create and execute database procedures in an ABAP environment using the ABAP method. It is a class-based framework. AMDP Development can only be done in an ADT(eclipse-based development environment).

Why AMDP not CDS View?

CDS View has some limitations over AMDP.

If we want to join more tables in CDS view, we can’t (queries will not work correctly). CDS View can be created with parameters but not for Select Inputs (multiple inputs). At CDS View we cannot handle complex solutions.

At ADMP we can write multiple SQL statements. AMDP is also a Top-down approach at HANA Database. In AMDP we need to define and implement methods globally.

Features of AMDP

  • All AMDP method parameters have to be passed by value, and must be of either table or scalar types. Pass by reference is not permitted
  • Exporting, importing and changing parameters are allowed. Returning parameters are not allowed
  • Debugging is possible with external sessions.
  • Specific to the HANA database (no other database it supports).
  • Transportation to higher environments is not easy.
  • It can handle complex solutions(multiple inputs and multiple outputs).

Thanks for reading.

If you Want to Connect with Me:

LinkedIn: https://www.linkedin.com/in/mayank-chourasia-38421a134/

Twitter: https://twitter.com/ChourasiaMayank.

YouTube: https://youtube.com/channel/UCo7iSPDHeg9iFObGNE9lFMA

Thank you, stay safe, stay healthy.

Stay tuned till the next blog.

--

--

Mayank Chourasia

Hey, My name is Mayank Chourasia. Currently I am working on SAP Utilities as a SAP ABAP Developer. I had written a blogs on SAP ISU, SAP ABAP, Google Cloud .