Skip to Content
-1
Jun 01, 2018 at 08:54 AM

How to implement AMDP (ABAP Managed Database Procedures)

781 Views Last edit Jun 03, 2018 at 05:21 AM 2 rev

Hi guys,

Do you have an tutorial or guide on how to implement AMDP?

I read some blogs regarding it and tried to implement one using EXPERT ROUTINE (I followed the steps in the last link) but I can't make it work. Do you have any step by step guide for me to understand this?

https://help.sap.com/doc/abapdocu_740_index_htm/7.40/en-US/index.htm?file=abenamdp.htm

https://www.just-bi.nl/bw-hana-transformations-amdp-script-start-thinking-set-based/

https://blogs.sap.com/2014/01/15/implement-and-consume-your-first-abap-managed-database-procedure-on-hana/

https://www.sap.com/documents/2016/06/745031b8-757c-0010-82c7-eda71af511fa.html

***NOTE: I can do ABAP routines.

So here is my sample scenario:

Then I just added this code below the METHOD:

outTab = select "BUS_AREA",

"COMPANYCODE",

"CO_AREA",

"ERPSYSTEM"

from :inTab;

But I keep getting this error.

So I revised the code to match the number of characters of OUTPUT and INPUT.

outTab = select cast(substring("BU",2,4) as varchar) as "BUS_AREA", "COMPANYCODE",

' ' as "CO_AREA",

cast(substring("ERPSYSTEM",3,2) as varchar) as "GN_R3_SSY"

from :inTab;

But it still gives me same error.

Questions:

1. How will I correct this error? This is just a one on one mapping.

2. Since in my original design, I don't want to map 0CO_AREA, how will I do it in the code?

3. Any tutorial so I can properly implement AMDP?

Thanks a lot!

Loed

Attachments

delete.jpg (75.0 kB)
delete.jpg (53.0 kB)
delete.jpg (53.0 kB)
delete.jpg (133.3 kB)