Posts

Showing posts from October, 2023

AMDP - ABAP Manage Database Procedure

Image
AMDP – ABAP Managed Databased Procedure ABAP Managed Database Procedures, is a procedure, we can write code inside AMDP by using SQLSCRIPT which is a database language same as SQL script, this language is easy to understand and code.  After coding logic inside AMDP method, you can consume it in ABAP report, or use AMDP same as delegate method in CDS table function. With AMDP, We can take advantage of new features of HANA (code push-down technique), hence we still code all logic on application layer, then this logic will be executed on the database layer. AMDP is only supported in ADT bundle or HANA studio, and don’t be supported in SAP GUI. So if you want to learn AMDP, please change IDE to ADT bundle instead SAP GUI. Besides HANA DB, AMDP can support many other DB, maybe in the future. So, at this time, we can only use it in HANA DB Limitations of AMDP We can only create, debug AMDP in ADT bundle or HANA studio. With AMDP, we can’t use MSEG table. So, we can use MATDOC table or pr...