Show TOC

Transformations in SAP HANA DatabaseLocate this document in the navigation structure

If you are using a SAP HANA database, all transformations will be processed in the SAP HANA database as far as possible.

When a transformation is activated, the system checks whether the transformation can be performed in SAP HANA. If the transformation can be performed in SAP HANA, you can set whether the transformation should be performed in SAP HANA or on the application server. You make this setting when creating a data transfer process. If the transformation has an ABAP Managed Database Procedure however, it must be performed in SAP HANA.

By choosing CheckCheck to the right of the transformation's name field, you can check for yourself whether the transformation can be performed in SAP HANA. The system then attempts to create the transformation in SAP HANA. If this is successful, the transformation is flagged with Can be performed in SAP HANA. If the check is not successful, you can find out why by viewing the log.

If you need special transformations that are not possible with the standard transformation rules, you can create these as ABAP Managed Database Procedures in SAP HANA. This function is only intended for use by experts. You need to be registered as a developer, in order to use this function. For more information about ABAP Managed Database Procedures, see the ABAP key word documentation at . http://help.sap.com/abapdocu_740/en/index.htm?file=abenamdp.htm

Note You have to model date calculations (such as sy-date + 1) with formula ADD_DAYS_TO_DATE, both for internal and external display.

The following objects are supported as targets: DataStore object (classic: standard and write-optimized), DataStore object (advanced), semantically-partitioned objects based on DataStore objects, open hub destinations with DB tables (without database connection) or third-party tools.

The following objects are not supported for executing transformations in SAP HANA:

  • Queries as InfoProviders are not supported as the source.
  • ABAP routines are not supported (rule types Routine, Characteristic Routine, Start Routine, End Routine and Expert Routine).
  • Rule groups are not supported.
  • To read data from DataStore objects, the entire key must be provided.
  • Near-line connections are not supported.