Performance-Aware ABAP on SAP HANA

Keep this: job aid

ABAP on SAP HANA performance card

• Code-to-data: join, filter and aggregate in the database; keep business rules in testable ABAP.
• SAP's rules: small result set, few columns, few reads, buffer repeated data, use indexes.
• ABAP SQL first; CDS view entities for reusable models; AMDP last.
• Red flags: SELECT in LOOP, nested SELECT loops, SELECT *, filter or sum in ABAP, FOR ALL ENTRIES with empty table, EML in loops.
• Large keyed lookups: hashed, sorted or secondary keys; no BINARY SEARCH in new code.
• No ORDER BY means no guaranteed order on SAP HANA.
• Tools: ATC (static), ST05 SQL trace and SAT / ADT Profiler (one run), SQLM (system-wide), SWLT (findings × runtime).
• Criterion = operation + volume + environment + threshold + method; three runs; reconcile results.
• Prioritize by time × executions × business impact; retire dead code; re-rank after each round.