ABAP Managed Database Procedures(AMDP)

[Siva_Prasad_Ramani]

Hi Gurus,

I'm new to SAP HANA.

And I want to crate basic AMDP methods and know its benefits.

So Could you please provide sample basic code of creation of AMDP and its uses.

Regards,

Siva R

[Siva_Prasad_Ramani]

Hi Gurus,

I'm new to SAP HANA.

And I want to crate basic AMDP methods and know its benefits.

So Could you please provide sample basic code of creation of AMDP and its uses.

Regards,

Siva R

[CarineTchoutouo]

Hi Silva,

please search in the content page of this space and you'll find various threads/documents on AMDP.

Here some links:

Kind regards,

Carine

[Former Member]

Hello Carine,

Thank you for the links. The below video on AMDP is really great and well presented. Can I have a request if you can share the code that you have presented in the tutorial.

How to implement ABAP Managed Database Procedures on SAP HANA - YouTube

I have few complex scenarios which involves getting data from several tables. I am using AMDP for my approach.

I did notice you were going thru some code in the tutorial and the class is 'ZCL_OIA_CLASSIF_BY_RULE_AMDP", which has methods AMDP_GET_BUPA_GUID, AMDP_GET_RANK1 to RANK6. I could see AMDP_GET_RANK2 has some complex queries built, I would like to request if you can share the code so I could understand it better.

Basically, I am trying to learn and implement how can I pass select-options to AMDP, also how to use FOR All entries inside an AMDP method.

Thanks,

Suresh

[Siva_Prasad_Ramani]

Hello Carine,

Thanks for your reply.

Could you please explain the difference between CDS Views and AMDPs. I.e' In which scenario we are going to use CDS Views and in  which scenarios want to choose AMDPs.

Which is the best among these two.....??

Regards,

Siva R

[Former Member]

Siva,

Please go thru the below video and Carine has explained it really well.

How to implement ABAP Managed Database Procedures on SAP HANA - YouTube

Thanks,

Suresh

[Siva_Prasad_Ramani]

Hi all,

Thanks for reply.

The above mentioned video on AMDP is really well presented. Now I'm using AMDP methods.

So could you please brief explain about what is the difference between normal class methods and AMDP class methods..???

Regards,

Siva R

[amol_samte]

Hi,

Normal Class : We can use existing ABAP standard functionality inside methods and can be changeable and createable through SAP GUI/ABAP Ecplise.

AMDP Class : Only we have to use HANA SQL (Since we are pushing code to HANA DB) and required ABAP ecplise for development.

We can not use for all entries inside AMDP because it supports HANA SQL only.

Handling Select options :

-Amol

[Siva_Prasad_Ramani]

Hi all,

Thank you very much for your reply.

Could you please explain the difference between CDS Views and AMDPs. I.e' In which scenario we are going to use CDS Views and in  which scenarios want to choose AMDPs.

Which is the best among these two.....??

Regards,

Siva R

[amol_samte]

Just go through below training which is very well explained by Dr. Jasmin

-Amol S