Introduction to AMDP in SAP S4HANA.

 

    * AMDP -- ABAP managed database procedures.

    * It is a framework for managing and calling stored/database procedure and database function in as ABAP.

    * The AMDP manages AMDP procedures and functions.

------------------------------------------------------------------------------------------------------------------------------

    * AMDP is a global class that contains special tag interface that starts with IF_AMDP_MARKER_*.

    * For HANA database IF_AMDP_MARKER_HDB.

-------------------------------------------------------------------------------------------------------------------------------

    * Constructors can't be implemented as AMDP methods.

    * There are two types of AMDP methods.

            1. AMDP procedure implementation.

            2. AMDP function implementation.

    1. AMDP procedure implementation.

            * Implementation must be flagged with BY DATABASE PROCEDURES.

            * It can be static or instance method and can be declared in any section.

            * Parameters must be declared using pass by value. (Pass by reference is not allowed).

            * Return values can't be declared using RETURNING.

            * Raising can only be used to specify the exception classes with - CX_AMDP_*.

            * Method implementation.

                    - Can't be empty.

                    - No DDL statements like creating/changing/ Deleting database.

                    - No execution of transactional statements like COMMIT WORK/ROLLBACK WORK.

                    - Method don't have implicit enhancement option.

                    - WRITE can't be performed on database tables.

                    - Dynamic programming should not be used.

    2. AMDP function implementation.

            * Implementation must be flagged with BY DATABASE FUNCTION.

            * AMDP functions are 

                1. AMDP table function.

                     * AMDP table functions for AMDP methods.

                      * AMDP table functions for CDS table functions.

                2. AMDP scalar functions.

                1. AMDP table function for AMDP methods.

                    * AMDP table function can be declared as static or instance method can be declared in any section.

                    * Must have return parameters can be declared using RETURNING.

                    * Return value must be tabular with a structured row type with elementary components.

                    * Can be elementary or tabular input parameters but can't have output parameters.

                    * Class based exceptions can't be declared using RAISING in method interface.

            2. AMDP table functions for CDS table functions.

                    * It can be declared in the public section of static AMDP class.

-----------------------------------------Differences between normal and AMDP class------------------------------

    * Normal Class.

        - Code execution happens on the application server.

           - Performance is slow when compared to AMDP class.

           - Uses ABAP programming language.

           - can be edited SAP logon and eclipse.

   * AMDP class.

             - Code execution happens on directly within the SAP HANA database.

            - Performance is fast when compared to Normal class.

            - Uses SQL script.

            - can be edited only in eclipse.

********************************Thank You*****************************

Comments

Post a Comment

Popular posts from this blog

New syntax for append- VALUE (new syntax 7.4+) in ABAP

Image
* We use APPEND statement to insert the records at the last of the internal table. * In SAP ABAP new syntax, we can use VALUE expression instead of APPEND statement. * Value expression is a powerful mechanism to declare as well as initialize the internal tables. * It is a powerful utility where we can achieve the result with minimal coding. * Value expression is of 2 types.      -  Define the type before using it with VALUE keyword. The type defined is structure type  or table type.      -  Using # character for type and use it with VALUE keyword. Report REPORT  zab_rp_append_value . TYPES :  BEGIN  OF  ls_stu ,          st_id ( 10 )    TYPE  n ,          st_name ( 15 )  TYPE  c ,         END  OF  ls_stu . DATA :  lt_stu  TYPE  TABLE...
Read more

Read statement new syntax in ABAP. (7.4+).

Image
*  Before ABAP 7.4, we used READ TABLE statement to read the first matching record from the internal table  based upon key or index . * In SAP ABAP new syntax, instead of READ TABLE , we can use the table expressions. * We need to use the square bracket [ ], In the square bracket, we need to specify the key or index. * While using table expression, If the table entry does not exist, system throws the exception CX_SY_ITAB_LINE_NOT_FOUND. * Use line_exists statement to check the existence of a record. Report REPORT  zab_rp_read_new . TABLES :   vbak . SELECT-OPTIONS :   s_vbeln  FOR  vbak - vbeln . SELECT  vbeln , erdat , erzet , ernam , auart         FROM  vbak         INTO  TABLE  @DATA ( lt_vbak )          WHERE  vbeln  IN  @s_vbeln . WRITE :   'Index value'  COLOR  5 . READ  T...
Read more

Concatenation new syntax( 7.4+ ).

Image
  Report REPORT  zab_rp_concat_7_4 . DATA :   lv_str1    TYPE  string  VALUE  'ajay' ,       lv_str2    TYPE  string  VALUE  'babu' ,       lv_str3    TYPE  string  VALUE  'varikallu' ,       lv_final1  TYPE  string ,       lv_final2  TYPE  string . CONCATENATE  lv_str1 lv_str2 lv_str3  INTO  lv_final1  SEPARATED  BY  space . WRITE :   /  'Old syntax: '  ,  lv_final1  COLOR  4 . lv_final2  =  | { lv_str1 } { lv_str2 } { lv_str3 } | . WRITE :   /  'New syntax: '  ,  lv_final2  COLOR  5 . Output ****** *********** ******** Thank You ****** ******* *********
Read more