AMDP Transformation Routines

AMDP Transformation Routines

Part of our online library flat rate.

  • By
  • Robert Geipel

Flatrate 12 month

19 USD per month

  • 12 Months
  • Single License
  • 19 USD 228 USD per year
  • 850+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

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

Language

English

Level

Intermediate

Release

2021

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