ABAP SQL

Host expressions and the @: your first defense against injection in ABAP SQL

Host variables, host expressions with @( ... ) and dynamic SQL. The difference between passing a value and concatenating a string is the difference between a secure system and one with an open door. With real code.

Feb 21, 2026

#ABAP#ABAP SQL#CTE

CTEs with WITH and subqueries: step-by-step queries without throwaway views

The Common Table Expression (WITH +cte AS ...) breaks a complex query into readable steps that live inside the statement. With real code, the mandatory + prefix and the ENDWITH people forget.

Feb 18, 2026

#ABAP#ABAP SQL#GROUP BY

Aggregations and GROUP BY: let the database hand you the totals, not the rows

SUM, COUNT, MAX and GROUP BY in the statement. Summing in a LOOP is fetching ten thousand rows to produce three. With real code over the flight tables and the HAVING filter many forget.

Feb 17, 2026

#ABAP#ABAP SQL#CASE

SQL expressions in ABAP: let the database compute for you

CASE, arithmetic and functions inside the SELECT. Everything you resolve in the statement is computation that never travels up to ABAP. With real code for CASE, CAST, DIVISION, ROUND and string functions.

Feb 15, 2026

#ABAP#ABAP SQL#JOIN

JOIN in the database or nested loop: the pattern that decides your performance

The SELECT inside a LOOP still shows up in every code review. A JOIN resolves in one trip what a nested loop resolves in thousands. We see it with real code over the flight tables.

Feb 13, 2026

#ABAP#ABAP SQL#Open SQL

Modern ABAP SQL: why the comma and @ syntax isn't cosmetic

Commas between columns, INTO at the end, inline declarations with @DATA and host variables with @. The new Open SQL syntax isn't sugar: it's what switches on strict mode and saves you from silent errors.

Feb 12, 2026