topic Re: ABAP Managed Database Procedures(AMDP) in Application Development and Automation Discussions

ABAP Managed Database Procedures(AMDP)

Siva_Prasad_Ramani — Mon, 16 Nov 2015 06:10:43 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

CarineTchoutouo — Mon, 16 Nov 2015 09:17:07 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

Former Member — Tue, 17 Nov 2015 23:03:36 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

Former Member — Tue, 17 Nov 2015 23:04:38 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

Siva_Prasad_Ramani — Wed, 18 Nov 2015 05:10:07 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

amol_samte — Mon, 23 Nov 2015 09:04:23 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

Siva_Prasad_Ramani — Mon, 23 Nov 2015 12:29:40 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

Siva_Prasad_Ramani — Mon, 23 Nov 2015 12:30:38 GMT

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

Re: ABAP Managed Database Procedures(AMDP)

amol_samte — Mon, 23 Nov 2015 14:09:23 GMT

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

-Amol S