AMDP Transformation Routines

AMDP Transformation Routines

  • By
  • Robert Geipel

Subscription

$159

  • Single License
  • 400+ eBooks and video tutorials
  • Instant access

Share this Product

Get Custom offer

  • 10+ Users
  • For depatments or complete companies
  • Premium analytics

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