#ABAP#HANA#ABAP SQL

The golden rules of SELECT on HANA: no SELECT * and no nested loops

HANA is fast, but it won't forgive a SELECT inside a LOOP or a SELECT *. The five rules that separate data access that flies from data access that drags the whole system down.

Apr 7, 2026

#ABAP#HANA#performance

Analyzing performance on HANA: measure with ST05, SQLM, SAT, ATC and SWLT

Optimizing without measuring is superstition. An honest tour of the tools HANA and ABAP give you to find the SQL that's actually slow: each one answers a different question.

Apr 6, 2026

#ABAP#HANA#code-pushdown

Code pushdown in practice: what to push and how far

Pushdown isn't optimizer magic: it's your decision. CASE, SQL functions, WITH, UNION and hints. We review what you can push to HANA with ABAP SQL and when you shouldn't.

Apr 4, 2026

#ABAP#HANA#code-to-data

Code-to-data: stop dragging the database into ABAP

The code-to-data paradigm isn't a HANA fad: it's admitting that moving millions of rows to the application server to sum them in a LOOP was always a mistake. Explained with real examples.

Apr 2, 2026

#ABAP#HANA#CDS

CDS Table Functions: when a CDS view isn't enough and you need SQLScript

Table Functions merge the best of CDS and AMDP: you model like a CDS entity but implement in SQLScript. When to use them, how the two pieces wire together and the SELECT-OPTIONS trick.

Apr 1, 2026

#ABAP#HANA#AMDP

AMDP: SQLScript inside an ABAP class (no database user)

ABAP Managed Database Procedures let you write HANA SQLScript as a class method, transported as ABAP code. When it makes sense, how it's declared and why it isn't your first choice.

Mar 29, 2026

← All posts