SAP / SAP Mid Level (3 to 8 yrs) Interview questions
What is code-to-data pushdown in the context of HANA?
Code-to-data pushdown means moving data-intensive processing logic (filtering, aggregation, joins) into the database layer itself — executing it as SQL or HANA-native logic close to where the data actually lives — rather than pulling large volumes of raw data up to the application layer and processing it there in ABAP.
" anti-pattern: pull everything, aggregate in ABAP SELECT * FROM sales_transactions INTO TABLE @DATA(lt_all). LOOP AT lt_all INTO DATA(ls_row). " manually accumulate totals per region in ABAP ENDLOOP. " pushdown: let the database do the aggregation SELECT region, SUM( amount ) AS total FROM sales_transactions GROUP BY region INTO TABLE @DATA(lt_totals).
Since HANA's in-memory engine can aggregate and filter enormous datasets extremely fast, and network/data transfer between the database and application layers is comparatively slow, pushdown avoids moving far more data than necessary across that boundary — a core principle behind modern ABAP development (CDS Views, AMDP) built specifically to encourage this pattern rather than the older habit of pulling data into internal tables for processing.
More Related questions...
