Posts

Showing posts with the label Day 9: AMDP Advanced Concepts

Day 9: AMDP Advanced Concepts

  Day 9: AMDP Advanced Concepts Insert, Update, Delete in AMDP Error handling and exception class Performance tuning tips Hands-on : Create AMDP for aggregation and update logic 🔹 1. Operations: Insert, Update, Delete in AMDP 🧠 Concept: AMDP methods allow not just SELECTs, but also DML operations : INSERT , UPDATE , DELETE , UPSERT . These statements are written in SQLScript inside the AMDP method. 💡 Must be declared as MODIFYING methods. ✅ Example – ZCL_AMDP_DML_EXAMPLE (Insert, Update, Delete) CLASS ZCL_AMDP_DML_EXAMPLE DEFINITION   PUBLIC   CREATE PUBLIC.   PUBLIC SECTION.     INTERFACES: IF_AMDP_MARKER_HDB.     CLASS-METHODS:       insert_sales_order_data         IMPORTING VALUE(it_data) TYPE STANDARD TABLE OF zsales_order,       update_sales_order_data         IMPO...