AMDP Transformation Routines

AMDP (ABAP Managed Database Procedures) originally referred to a framework from SAP for defining, implementing, managing and calling database procedures in the SAP HANA database from the ABAP application server. This 4 hour course will cover the following topics:

1. Intro SQL Script
2. Preparation
3. ABAP Managed Database Procedures (AMDP)
4. DTP execution in SAP HANA with AMDP
5. Access to database tables
6. Exercise 1: Lookup for master data with a JOIN
7. Parameter of the routines
8. Routine types
9. Exercise 2: Transpose data from an account model to the key figure model
10. Error handling and error stack
11. Exercise 3: Calculating running totals
12. Procedure for creating a routine
13. Exercise 4: Transpose data from key figure model to account model
14. Tips & tricks for working with Eclipse
15. Appendix - How to create your own BW/4HANA system in the SAP Cloud Appliance Library