Which rule types support SAP HANA Runtime for Transformations in SAP BW/4HANA? Note: There are 3 correct answers to this question

Question

Options

• AABAP start routine
• BSQL Script field routine
• CLookup from Data Store object (advanced)
• DABAP end routine
• EABAP field routine

• A
  9% (4)
• B
  71% (32)
• E
  20% (9)

Explanation

In SAP BW/4HANA, the SAP HANA Runtime for Transformations (push-down execution) requires rule types that can be processed natively on the HANA database engine. SQL Script field routines (B) are written in HANA-native SQL Script, making them inherently compatible. Lookups from DSO (advanced) (C) leverage HANA's in-memory table joins and are fully supported. ABAP end routines (D) are compatible because they execute after the core HANA processing completes, allowing the main data load to still benefit from HANA push-down.

ABAP start routines (A) are excluded because they pre-filter the entire dataset in the ABAP application layer before HANA processing begins, breaking the push-down chain. ABAP field routines (E) are excluded because they require per-record ABAP processing, which forces the entire transformation back into the ABAP layer - SQL Script field routines were introduced specifically as their HANA-compatible replacement.

Memory tip: Think "SLE = HANA OK" - SQL Script, Lookup (advanced DSO), End routine are HANA-safe. Anything that forces ABAP to touch data before or during field-level processing (start routines, ABAP field routines) kills the push-down.

No community discussion yet for this question.