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://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