Skip to Content

Hi All,

While developing AMDP class there must be a situation like how to handle internal table inside AMDP.

Well below is the example for that in short and sweet manner.

Before moving forward let’s see an overview of AMDP and other intresting stuff is

here,

ABAP Managed Database Procedures – Introduction

Accessing tables from different schema through AMDP.

Call AMDP(ABAP Managed Database Procedure) Inside AMDP Method

Scenario :- 1.Suppose you have Airline code(Carrid) and connection number(Connid) in an internal table based on that you need to fetch data from inside AMDP.

Steps :

AMDP Definition :

Defination.PNG

AMDP Implementation :

Implimentation.PNG

Calling AMDP In Program :

Program.PNG

Output :

Output.PNG

Hope this will help,

Thanks & Regards,

Amol.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Jasmin Gruschke

    Hi Amol,
    just a short comment to clarify for those new to AMDPs. In the SQLScript coding, so in the AMDP implementation, the objects it_sflight and et_flight_dtl are *not* internal tables. What technically happens, is that the AMDP runtime creates temporary tables for your tabular input/ouput parameters, which contain the data of the ABAP internal tables during runtime. This also means, that the data is copied from the ABAP layer to the DB layer and vice versa. This is something you have to keep in mind from a performance perspective. So my advice of precaution – when you use AMDPs for code pushdown and you use this pattern, keep also in mind that you don’t do “data pushdown” by means of transferring a lot of data from internal tables to HANA and vice versa.
    Cheers,
      Jasmin

    (0) 
    1. SeethaRamaiah Bharani

      Hello Jasmin,

      Guten Tag!!!

      I have read document and have a little confusion.

      AMDP Method Code looks like a FAE functionality in ABAP. As you said as a precaution, transferring huge amount of ITAB data to HANA DB causes performance issue. In case if we want transfer the huge amount of the data  to achieve Code Push down, AMDP is not suitable?

      Thanks and Regards,

      Bharani.

      (0) 

Leave a Reply