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
