Processing the Data Transfer Process in SAP HANA

If your BW runs on a SAP HANA database, it is possible or necessary in certain cases to process the data transfer process (DTP) with processing mode SAP HANA Execution. The processing type is defined in the header data area in DTP by setting the corresponding SAP HANA Execution flag.

When processing the data transfer process in SAP HANA, the following applies:

The data transfer process can be processed with processing type SAP HANA Execution if the data transfer process check finds that all transformations can be executed in SAP HANA. In this case, the flag in the data transfer process maintenance screen is input-ready, and you can set the flag if the prerequisites for this in the data transfer process are met (see below). If this is already the case during creationg, the flag is set by default.
The data transfer process must be processed with processing type SAP HANA Execution if you are using ABAP Managed Database Procedures in one of the transformations for the data transfer process. In this case, the flag is set in the data transfer process maintenance screen and is not input-ready. Processing type SAP HANA Execution is therefore set.
The data transfer process cannot be processed with processing type SAP HANA Execution if you are using an ABAP routine in one of the transformations for the data transfer process. In this case, the flag is set and not input-ready in the data transfer process maintenance screen, and a processing type is set that can be executed on the ABAP server..

Prerequisites for Using the Processing Type

If the transformation supports execution in SAP HANA, the following prerequisites have to be met in the DTP in order to use processing type SAP HANA Execution:

Error handling is deactivated.
There are no requests in the DTP error stack.
No list is maintained for semantic grouping, meaning that the data is not extracted and posted in semantic groups.
If the target of the DTP is a DataStore object: On the Update tab, Subsequent Processing without Master Data is selected.
If the target of the DTP is an open hub destination: The destination is a database table or a third-party tool.
If the source of the DTP is a DataStore object: On the Extraction tab, the parameter for DeltaInit extraction from Active Table (with Archive) is not set.
If the source of the DTP is a DataSource: The data extraction comes from the PSA, meaning that the option from From PSA is selected in the parametrs of the DataSource under Data Extraction on the Extraction tab.

Checking and Setting the Processing Type

The processing type is preset when creating the DTP if the prerequisites for this are met or processing in SAP HANA is required because of the transformation.

While editing the DTP, you can set the input-ready SAP HANA Execution flag. The system then performs a check. If one or more of the prerequisites is not met, it is not possible to set the flag, and the system displays messages about the incompatibilities in a popup.

If the SAP HANA Execution flag ist set in the DTP, and you make a change to the DTP, which is incompatible with the SAP HANA execution (activating error handling for example), the system removes the flag and displays messages about the incompatibilities in a popup.

By pressing Check Availability, you can also check whether procesing in SAP HANA is possible in display mode.

Parallelization of Processing

If you implement SAP Hinweis 1935460 Information published on SAP site , the requests are processed in parallel processes, meaning that a parallel process is derived from the main process for each data package. This parallel process extracts and processes the data. On the Extraction tab page, the Parallel Extraction field is selected.

Effects of changes to the transformation

For an active DTP with processing type SAP HANA Execution, changes to the transformation have the following effects:

If execution in SAP HANA is not supported any more after the transformation changes, the system changes the processing type of the DTP to a suitable processing type in the ABAP server and reactivates the DTP.
If the transformation is inactive, the system sets the DTP to inactive too.
In most other cases, the DTP remains active.
If changes to transformations cause the error stack to change, the system reactivates the DTP.

If execution is possible in SAP HANA after the transformation changes (or meets another prerequisite in the DTP, such as deactivating error handling), processing type SAP HANA Execution is not automatically set in the DTP and needs to be set by the user instead via the SAP HANA Execution flag.