AMDP is Database Procedure which is Managed by ABAP. It is governed and managed by ABAP

Both CDS and AMDP fall in Top-Down Approach of HANA, which are recommended by SAP.

Can be defined for any language, which is clear from the AMDP method.

AMDP can detect Database independent syntax errors; HANA specific syntax error and SQL Script errors. One Advantage over ADBC

If a Class has Marker Interface “IF_AMDP_MARKER_HDB” (student batch) then it is an AMDP class. If one or more METHOD of AMDP class has the keyword BY DATABASE PROCEDURE , then it is AMDP method

When you create a class,we need to include this interface in the public section and at least one method should be an AMDP method and it will have parameter that will be of value references only.

Implementation of the method must contain the keyword BY DATABASE PROCEDURE

DBC still, lacks native SQL check during compile.

Native SQL was the method to consume Stored Procedures before ABAP 7.4. Now we can use ADBC as it has better advantage (OOPs, where-used analysis, exception handling etc)

creation, modification, activation and transport are all handled at ABAP layer, i.e. stored procedure runtime objects on HDB is created and managed by AMDP in ABAP AS. Also, SQLScript source code is managed at ABAP AS by AMDP. SQLScript syntax check also happens in HDB (but not in another database), unlike ADBC.

But AMDP methods are executed like static methods, even though they are defined as instance methods.Database procedures are created when they are called by AMDP for the first time. This is call Lazy Approach.

If we make any change in the source code of database procedure or any dependent objects, then the new version of the database procedure is created and old versions are deleted asynchronously

lthough AMDPs are created in Eclipse, they are saved at the ABAP layer

AMDPs are defined at ABAP layer but they are dependent on the underlying database so that they can optimize the database in use at the fullest.

we cannot directly pass SELECT options as is it to AMDP Methods.We need to select the data from the database and then APPLY the Filter using the function APPLY_FILTER.

SELECT OPTIONS need to be converted to FILTER STRING using some way and then pass the FILTER STRING as an input PARAMETER of the of the AMDP Method.

class CL_SHDB_SELTAB

method COMBINE_SELTABS