ABAP-Managed Database Procedures (AMDP) with Example

 

Syntax of AMDP Classes

An AMDP is implemented in an AMDP class with a regular static method or instance method in any visibility section.

CLASS <my_amdp_class> DEFINITION.

  PUBLIC SECTION.
* Marker interface with SAP HANA DB as database type
  INTERFACES IF_AMDP_MARKER_<DB_TYPE>.
   ...
   	
  METHODS <my_amdp_method>.
   ...
     
ENDCLASS.


CLASS <my_amdp_class> IMPLEMENTATION.

...

* AMDP method 
  METHOD <my_amdp_method> BY DATABASE PROCEDURE 
		FOR <db_type>
		LANGUAGE <db_language>
 		OPTIONS <db_options>  
     	USING   <db_entity>.
     	
  	"Implementation of the procedure in a DB-specific language 
 	...

  ENDMETHOD.
	...

ENDCLASS. 
 

Example:

Click on File->New->ABAP Class


CLASS zvb_amdp_class DEFINITION

PUBLIC

  FINAL

  CREATE PUBLIC .

 

  PUBLIC SECTION.

    TYPES:BEGIN OF ty_stu,

            id   TYPE numc10,

            name TYPE char20,

          END OF ty_stu.

    TYPES:tt_stu TYPE STANDARD TABLE OF ty_stu.

    INTERFACES:if_amdp_marker_hdb.

    CLASS-METHODS:fetch_data IMPORTING

                               VALUE(iv_id)  TYPE zvb_stu-id

                             EXPORTING

                               VALUE(et_stu) TYPE tt_stu.

ENDCLASS.

 

CLASS zvb_amdp_class IMPLEMENTATION.

  METHOD fetch_data BY DATABASE PROCEDURE

                    FOR HDB

                    LANGUAGE SQLSCRIPT

                    OPTIONS READ-ONLY

                    USING zvb_stu.

    et_stu = select id,name from zvb_stu WHERE id = :iv_id;

  ENDMETHOD.

ENDCLASS.

 

Call AMDP Class in Report Program

REPORT zvb_amdp_program.

PARAMETERS:p_id TYPE zvb_stu-id.

zvb_amdp_class=>fetch_data(
  EXPORTING iv_id = p_id
  IMPORTING et_stu = DATA(lt_stu) ).

cl_demo_output=>display_data( name = 'Student Details' value = lt_stu ). 


Output:

 

 

 

Comments

Post a Comment

Popular posts from this blog

Passing Dynamic Variables to SO10 TEXT

REPORT  ZTEST_POPUP . PARAMETERS : A  TYPE  i ,  B  TYPE  i . DATA:  C TYPE  i ,       lv_text  TYPE  string , C  =  A + B .   data : it_final  TYPE  TABLE  OF  tline . DATA : CHANGED  TYPE  STRING . CALL  FUNCTION  'READ_TEXT'    EXPORTING     CLIENT                         =  SY - MANDT      id                             =  'ST'      language                       =  SY - LANGU  ...
Read more

Implicit Enhancement with Example

    Implicit Enhancement : Implicit point is available at the starting or at the last of the Program,Sub routines, Function Modules etc. We will create the Implicit Implementation using those points  Example:  Changing the Title of the Presentation Layer while using the Function Module 'F4_FILENAME'. 1.Go to T-code 'SE37'. 2.Execute the FM 'F4_FILENAME'.   Now the title is 'File Select.'. We are changing this title to 'Choose file'.  3.The Title is coming from the FM 'WS_FILENAME_GET'. Steps to create Implicit Enhancement: 1.Go to T-code 'SE37'. 2.Enter FM ' WS_FILENAME_GET'. 3.Click on 'Display'. 4.click on 'Edit'. 5.Click on 'Enhancement Operations'.  6.Click on 'Show Implicit Enhancement Options'.   7.Click on the 'Enhance' Icon.  8.Right click on the implicit points (""""""""""""""""""...
Read more

TMG Events

Image
In SAP ABAP, TMG (Table Maintenance Generator) events are used to customize the behavior of table maintenance dialogs generated by the Table Maintenance Generator. The Table Maintenance Generator is a tool provided by SAP that allows developers to create basic maintenance screens for database tables without having to write extensive ABAP code. TMG events are predefined function modules that are called at specific points during the execution of the table maintenance dialog. These events provide developers with hooks to add custom logic or validations to the standard table maintenance process without modifying the generated code. Some common TMG events in SAP ABAP include: BEFORE OUTPUT: This event is triggered before the maintenance screen is displayed. Developers can use this event to modify the screen layout or initialize screen fields. AFTER INPUT: This event is triggered after the user enters data on the maintenance screen and clicks the save button. Developers can ...
Read more