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