The SAP HANA runtime for transformations executes data logic directly within the SAP HANA database, which requires that all transformation rules are HANA-compatible.

- (C) Lookup from Data Store object (advanced): This is a standard, declarative rule type that is fully optimized for execution in SAP HANA.

- (B) SQL Script field routine: This allows for custom field-level logic using HANA's native SQL Script, ensuring the routine runs entirely within the database.

- (A) ABAP start routine: In SAP BW/4HANA, a start routine can be implemented as an ABAP Managed Database Procedure (AMDP). This allows developers to write SQL Script within an ABAP class method, which is then executed on SAP HANA, making it compatible with the HANA runtime.

D. ABAP end routine: While an ABAP end routine can also be implemented as an AMDP to support the HANA runtime (similar to a start routine), the selected answers represent three distinct categories of supported rules.

E. ABAP field routine: This refers to a classic ABAP implementation for field-level logic. Unlike start or end routines, it cannot be implemented as an AMDP and always forces execution in the ABAP runtime.

1. SAP Help Portal

SAP BW/4HANA 2021

"Transformations in SAP HANA Runtime": This document explicitly lists rule types optimized for SAP HANA. It states

"The following rule types are optimized for SAP HANA: Formula

direct assignment

reading from master data

looking up from DataStore objects (advanced)

and routines (start routine

end routine

expert routine and field routine) that have been implemented as AMDP scripts or SQLScript." This supports the correctness of options A

B

and C.

2. SAP Help Portal

SAP BW/4HANA 2021

"Routine": This documentation details the creation of routines. It specifies that for a Start Routine

you can create an "AMDP Script". For a Field Routine

the HANA-native option is a "SQL Script Routine"

distinguishing it from the non-HANA "ABAP Routine". This confirms that "ABAP field routine" (Option E) is not HANA-compatible

whereas "SQL Script field routine" (Option B) and AMDP-based "ABAP start routine" (Option A) are.