ABAP SQL & AMDP

Guide for writing modern ABAP SQL statements and ABAP Managed Database Procedures (AMDP) in ABAP Cloud and Standard ABAP.

Clean core context: SELECT from a released CDS view is Level A. Direct read access to an SAP database table is Level C (ATC priority 2); direct write access is Level D (ATC priority 1). EXEC SQL (native SQL) is a critical statement → Level D. SYCM_USAGE_OF_APIS reports SQL statements on SAP database tables and views. See the abap-cloud skill for level details.

Workflow

1. Determine the user's goal:

   • Writing or optimizing ABAP SQL queries
   • Using advanced SQL features (window functions, CTEs, aggregates)
   • Creating AMDP procedures or functions
   • Implementing CDS table functions via AMDP
   • Understanding PRIVILEGED ACCESS for authorization bypass

2. Identify the context:

   • ABAP for Cloud Development vs. Standard ABAP (affects available syntax)
   • Performance optimization needs
   • Whether AMDP is justified (prefer ABAP SQL when possible)